Click here to Skip to main content
15,347,000 members

Comments by kparun86 (Top 15 by date)

kparun86 24-Feb-14 5:03am View
   
DECLARE @LIST VARCHAR(200)
SET @LIST = '1,3'
SELECT Id, Descr FROM CSVDemo WHERE Id IN (SELECT * FROM dbo.CSVToTable(@LIST))

but i don have any id.
i'm getting the following error.

Invalid column name 'Id'.
kparun86 24-Feb-14 4:46am View
   
Alright how to pass the values to this function?
kparun86 5-Feb-14 0:18am View
   
Yep Now it s working. I Guess i made some mistake . now it s working fine thanks :)
kparun86 4-Feb-14 7:12am View
   
Nope it s not working. May i know why u have included sum (nvalue) in the query. actually i dont need to sum any n values.
kparun86 3-Feb-14 5:09am View
   
Ok Thanks Sandeep.
kparun86 14-Jan-14 2:40am View
   
Nope it s not working. i ll try in other ways i can.
kparun86 14-Jan-14 2:34am View
   
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

I'M GETTING TAT ERROR.
kparun86 14-Jan-14 2:28am View
   
HI CENARJUN. I KNOW TAT WAY. BUT I DONT NEED ALL THE INGREDIENTS WHICH HAVE N VALUE AS ZERO. WAT I NEED IS FOR INGREDIENT 2 AND 4 ALL THE VALUES ARE ZERO. I NEED OLY THAT PARTICULAR INGREDIENT ID WHERE ALL THE N VALUE ARE ZERO. IF I WRITE THE ABOVE QUERY I LL EVEN GET 1 AND 3 ALSO IN TAT LIST.
kparun86 28-Nov-13 2:08am View
   
Thanks Solution 2 is working.
kparun86 16-Sep-13 2:50am View
   
ok fine. thanks
kparun86 16-Sep-13 2:50am View
   
Deleted
ok fine
kparun86 16-Sep-13 2:28am View
   
Continuity in the sense we want a total count of how many data's are there. thats why i wanted to update it like that.
kparun86 16-Sep-13 2:09am View
   
Ok fine. i have a huge database which is containing 60,000 datas. We may delete few datas and update few data. we have to maintain the continuity in the serial no column. Thats why i want to update like that.
kparun86 16-Sep-13 2:09am View
   
Ok fine. i have a huge database which is containing 60,000 datas. We may delete few datas and update few data. we have to maintain the continuity in the serial no column. Thats why i want to update like that.
kparun86 16-Sep-13 2:08am View
   
OK will try that.