Thanks for your Help Madhivanan. We have KeyWord "@@NESTLEVEL" to find out the level of the Procedure. For Exapmle: CREATE PROCEDURE innerproc as...
Hi, I have a Stored Procedure which in turn calls another Procedure and which in Turn calls another procedures ..... The Problem is Level of Calling...
Extending my Previous Question, How we can select ItemType and Jan'07, Feb'07 Columns? Item, ItemType and Anual are Static Columns and Remining are...
Thanks for your Valuable replies. I got the logic.
Not in the Table; It's in the Result Set.
Hi I want Query for Increase the Table columns Dynamically with the given Date range. For Example, COnsider a Sales table SALES...
Ohh..I over looked the post, Thanks for Help Adriann
Hi Adriaan, I'm looking for User Defined Function type. Can We make it in a Query instead of UDF? If Possible post both of them.
I want the <font color="blue">Multiple Row Values </font id="blue"> to be <font color="red">Concatinated </font id="red"> into <font color="blue">One...
Yes, you are correct Kenneth, I missed this logic while Itrating in the Loop. Thanks for your Clear and Detailed Example.
declare@startdatetime,@enddatetime select@start = '20060101',@end= '20070210' selectfd= (n * 90) + 1, td= (n + 1) * 90, qt= datepart(quarter,...
Thanks for your Valuble and different Solutions...
Yes, KH
To the extension of the above, How to get, to Which Quarter the above Range Belong to in the same date Range i.e, '01/01/2006' AND '10/02/2007' ?...
Thanks for your Reply KH. Hi Frank Kalis, I just came accross a Seinario, where I want the Date Range in Days instead of 3 Months or Quater.
Thanks for your Prompt Reply... I have a small Doubt, what if the 'n' value has to exceed 9?
I want the Days to be splited into intervals of 90 days between the two given Dates. Like if we Give the dates as '01/01/2006' AND '10/02/2007',...
Thanks for spending your Valuble time on this thread.
Hi, I Have Table called Numbers which Contains Columns Num1 and Num2 of same data type. I want a Single Query to swap the rows in the Table. The...
What is @@ Called in @@ERROR?
Separate names with a comma.
