Comments by itsmypassion

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.

Comments by itsmypassion (Top 30 by date)