15,611,854 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
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 Python questions
View Javascript questions
View C++ questions
View Java questions
discussions
forums
CodeProject.AI Server
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
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
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
Search within:
Articles
Quick Answers
Messages
Comments by itsmypassion (Top 30 by date)
itsmypassion
26-Oct-18 5:48am
View
You can debug stored procedure.
https://msdn.microsoft.com/en-us/library/hh272701(v=vs.103).aspx
itsmypassion
20-Jun-18 2:59am
View
https://stackoverflow.com/questions/1151987/can-i-set-an-unlimited-length-for-maxjsonlength-in-web-config
Check above link
itsmypassion
24-May-18 1:33am
View
you can use arrays or object literals instead
https://stackoverflow.com/questions/2307157/alternative-to-the-switch-statement
https://toddmotto.com/deprecating-the-switch-statement-for-object-literals/
itsmypassion
28-Mar-18 23:50pm
View
You can use CTE instead.
itsmypassion
23-Mar-18 2:28am
View
Do not include Column "No" in Group by List.
itsmypassion
23-Mar-18 2:28am
View
Deleted
Do not include Column "No" in Group by List.
itsmypassion
19-Feb-18 5:30am
View
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f6466a82-caf7-4053-94a4-a6f756b2f5c6/calling-stored-procedure-invalid-cursor-state?forum=sqldataaccess
itsmypassion
18-Feb-18 23:42pm
View
Please share sample data.
itsmypassion
5-Feb-18 3:47am
View
Deleted
You can club it in a subquery
itsmypassion
5-Feb-18 1:27am
View
With GROUP BY you can not get NULL or 0 if no records found.Try to omit Group BY
itsmypassion
4-Jan-18 0:48am
View
You can make it Public procedure instead of private.
itsmypassion
15-Dec-17 1:00am
View
https://stackoverflow.com/questions/43408012/mysql-invalid-utf8-character-string-when-importing-csv-table
itsmypassion
1-Dec-17 3:06am
View
Please provide table structure and sample data
itsmypassion
24-Nov-17 1:48am
View
Can you please mention sample data
itsmypassion
17-Nov-17 1:59am
View
You can export data to excel to download.
itsmypassion
15-Nov-17 7:12am
View
https://www.codeproject.com/Articles/265371/Common-Table-Expressions-CTE-in-SQL-SERVER
itsmypassion
15-Nov-17 6:45am
View
You can use RowNumber instead.I have modified solution.
itsmypassion
15-Nov-17 1:41am
View
Sorry LAG was introduced in SQL Server 2012.You can try following
Update EC1
SET EC1.OLD_Store = EC2.NEW_Store
from Employee_Change as EC2 ,Employee_Change as EC1
WHERE ec1.staff_id =ec2.staff_id and
ec1.transaction_date =Dateadd(d,1,ec2.Transaction_date)
itsmypassion
15-Nov-17 1:33am
View
Deleted
Which version of SQL Server are you using?It was introduced in SQL server 2012.
itsmypassion
31-Oct-17 8:37am
View
In that case you can generate for dynamic query using loop.
https://www.codeproject.com/Articles/20815/Building-Dynamic-SQL-In-a-Stored-Procedure
itsmypassion
27-Oct-17 4:45am
View
OK
itsmypassion
25-Sep-17 7:01am
View
Please specify table structure.
itsmypassion
5-Sep-17 2:11am
View
YEs there is flaw in the table structure and also the solution is inefficient.But it gives expected results.
itsmypassion
5-Sep-17 2:00am
View
It worked
itsmypassion
5-Sep-17 1:32am
View
You can use CTE
itsmypassion
28-Aug-17 7:57am
View
Can you please mention exact error.
itsmypassion
28-Aug-17 0:52am
View
Use Convert
SELECT DATEADD(ms, SUM(DATEDIFF(ms, '00:00:00.000', convert(datetime,YourFieldName))), '00:00:00.000') as time FROM YourTableName
itsmypassion
23-Aug-17 22:59pm
View
Its float.tryparse
itsmypassion
23-Aug-17 8:56am
View
Can you please provide table structure.
itsmypassion
23-Aug-17 8:39am
View
Please explain in detail.
Show More