Thanks for your Help Madhivanan. We have KeyWord "@@NESTLEVEL" to find out the level of the Procedure.
CREATE PROCEDURE innerproc as...
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.
I want Query for Increase the Table columns Dynamically with the given Date range.
For Example, COnsider a Sales table
Ohh..I over looked the post, Thanks for Help Adriann
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.
[email protected] = '20060101',@end= '20070210'
selectfd= (n * 90) + 1,
td= (n + 1) * 90,
Thanks for your Valuble and different Solutions...
Separate names with a comma.