Topics
Started by
Posts
Last post
Hi all I have the following table DECLARE @T table (A int ) insert into @T values (1) ,(0) ,(1) ,(0…
6 replies
Hi , I need to do one of these ghastly pivots again... and looking for some help. Here is my…
8 replies
HI all, The famous SearchAllTables proc failed to find date values I know exist in my (DateTime) co…
10 replies
Hi In my code below the row data are not grouping into month by month name. I want to group row dat…
4 replies
Hey everyone! I have a SQL agent job that deletes data then inserts data into the same table hourly…
11 replies
Hello. We have inherited a system and some code and this has been flagged as a performance issue. I…
13 replies
Hi, Our DB vendor is now implementing a new FK. This new FK is not going in due to duplicates - The…
8 replies
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 ALL I need help with the following query. declare @T table ( ID int identity , PAX_CNT INT , PAX…
2 replies
Viewing 15 topics - 31 through 45 (of 3,067 total)
You must be logged in to create new topics.