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
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.
Apr
3
asked Select query having count and variable
Dec
17
awarded  Supporter
Oct
11
awarded  Autobiographer