Topics
Started by
Posts
Last post
I have a business requirement to produce a running total, but with a twist ... If the running total…
14 replies
I need to send a copy of this to our customer but do not want to send all of the data so I need to …
2 replies
So I'm using SQL Server 2014 and I've been using Jeff Moden's excellent string splitting functions …
3 replies
Hi All, been a while since I posted. Facing weird calculation, I cant wrap my head around on how to…
7 replies
I currently have multiple databases, many databases represent a single customer, but a couple repre…
5 replies
Hey all, Been a while since I posted here. Recently encountered an odd problem. In the below code, …
3 replies
I have a poorly performing proc, that is called heavily, and is taking around 4 seconds to complete…
2 replies
Hi I need to anonymize some of our members for an outward facing demo web site. Long ugly story, bu…
15 replies
Hi ALL I need help with the following query. declare @T table ( ID int identity , PAX_CNT INT , PAX…
2 replies
hi, IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='abc' AND COLUMN_NAME…
10 replies
Hello. I am a bit confused and not sure what terms to use to Google. I have a transaction that over…
9 replies
I have a database with two versions - a production version and a development version. As I fix and …
3 replies
If I have a query with multiple UNION ALLs, will the optimizer try and grab enough memory to run al…
4 replies
SQL just goes and goes and returns no records if I un-comment this date line: AND cp.from_service_d…
12 replies
Stored procedure OUTER_TEST calls stored procedure INNER_TEST. If an error in INNER_TEST, how do I …
6 replies
Viewing 15 topics - 31 through 45 (of 3,062 total)
You must be logged in to create new topics.