Skip to content Skip to sidebar Skip to footer
Showing posts with the label Sql Server 2008
Sql Group By Acting Like Facebook Messaging (mssql Sp)

Sql Group By Acting Like Facebook Messaging (mssql Sp)

Post a Comment
im trying to group messages like conversations, user1 is @user (logged in user) UserName, UserFu… Read more Sql Group By Acting Like Facebook Messaging (mssql Sp)
Ssis Execute Process Task Hanging From Sql Server Job, No Errors Given

Ssis Execute Process Task Hanging From Sql Server Job, No Errors Given

Post a Comment
I have a basic SSIS package that has an execute process task which runs a .exe sitting on our NAS/S… Read more Ssis Execute Process Task Hanging From Sql Server Job, No Errors Given
Trigger Error: The Current Transaction Cannot Be Committed And Cannot Support Operations That Write To The Log File

Trigger Error: The Current Transaction Cannot Be Committed And Cannot Support Operations That Write To The Log File

Post a Comment
So I am getting the following error message from SQL Server when sp_SomeProc tries to execute an in… Read more Trigger Error: The Current Transaction Cannot Be Committed And Cannot Support Operations That Write To The Log File
How To Sanitize Input With Php And The Sqlsrv Driver?

How To Sanitize Input With Php And The Sqlsrv Driver?

Post a Comment
I'm working on a PHP MSSQL project that is using the sqlsrv driver. What's the best way to … Read more How To Sanitize Input With Php And The Sqlsrv Driver?
Create A Binary String Of Zeros, With Variable Length

Create A Binary String Of Zeros, With Variable Length

Post a Comment
What is the most elegant way to create a string of binary zeros, of type varbinary(max), if the len… Read more Create A Binary String Of Zeros, With Variable Length
Higher Query Result With The Distinct Keyword?

Higher Query Result With The Distinct Keyword?

Post a Comment
Say I have a table with 100,000 User IDs (UserID is an int). When I run a query like SELECT COUNT(… Read more Higher Query Result With The Distinct Keyword?