101 reputation
15
bio website maabookings.com
location Hyderabad, India
age 25
visits member for 2 years, 2 months
seen Oct 9 at 7:32

I'm a .Net Developer Working in Hyderabad. I have Knowledge on .NET, SQL SERVER, and other .Net Extensions


Apr
28
comment Add Contents in a Column and make them 0
Thank you But I need to Update the Main Table as the output table. I'm so sorry that I missed to mention that in the question
Apr
6
comment Select query having count and variable
@JNK, Would you mind checking this question also please dba.stackexchange.com/questions/39130/…
Apr
6
comment Select query having count and variable
Hey Can you Help me in another Query ?? sqlfiddle.com/#!3/cfa20/6 In this I will pass a sno and I need all the parents of that sno. and all the Childs of that no in two tables.
Apr
3
comment Select query having count and variable
I'm sorry. Thank you I'll keep that in mind.
Apr
3
comment Select query having count and variable
,Thank you Sooo much. This Is the one I exactly require.
Apr
3
comment Select query having count and variable
I'm so sorry that I'm not able to explain my problem in the way you understand. @JNK is Right that I'm using 1 as RefID in the Parameter
Apr
3
comment Select query having count and variable
Once check the First Table. In that the RefID contains Value-2 1 time. The Value-2 is the Serial No of the same Table and since SNo 5 is not Present as the RefID in the First Table the Cnt is 0 in the output Table. In the Output, the cnt column is the count of the RefID s. ie If there is a SNo 1 in the Output, The Cnt would be 5. Because, since the SNo 5 is Used 5 times as RefID in the First Table. Ok?
Apr
3
comment Select query having count and variable
Because the SNo 5 is not there in RefID column. and Since Sno 2 is referenced 1 time in RefID, the Cnt of Sno 2 in Output is 1.