15,347,000 members
Sign in
Email
Password
Forgot your password?
Sign in with
Search within:
Articles
Quick Answers
Messages
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Python questions
View Javascript questions
View Java questions
discussions
forums
CodeProject SenseAI
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
stuff
Competitions
Conferences
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
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.