Topics
Started by
Posts
Last post
Hi, I work in a hospital and look after a db containing the surgical procedures performed on our pa…
12 replies
I'm trying to create a query that pivots on 2 fields(entity,channel) and produce a daily sum of cha…
11 replies
Is there a way to take these two records and update the NULL values in one to match the filled in v…
11 replies
I'm doing an update using a self-join, and just want to confirm something. If the query updates a …
5 replies
Hi, I need to limit my data within 2 years, now I have no version of scripts, but I'm not sure whic…
1 replies
It's not my program, but it's a really nice Stored Procedure that was written by Richard Ding back …
12 replies
hi all i'm trying to write a query to summarize attendance counts per department i've two tables on…
2 replies
We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or view…
1 replies
I'm struggling with the performance of one of my stored procedures. Depending on the user that is c…
9 replies
I have 3 large tables with 133 million rows in 2 of the tables and over 570 million in the other. I…
47 replies
Good morning, I'm trying to get the Temp value at the maximum value of the Cond column. The …
6 replies
We have a Transaction server writing records to SQL recording machine data. The process writes reco…
10 replies
Is there any way to get the following code to ROUND UP instead of DOWN?: AVG(CASE WHEN [TIM…
4 replies
Good evening, I'm trying to find the MAX value on the TOC column, my current query does show…
8 replies
I have a main table with two columns Support_Start_Date and Support_End_Date and I need to join to …
2 replies
Viewing 15 topics - 121 through 135 (of 4,984 total)
You must be logged in to create new topics.