SQLBill (12/8/2015)

---

Now this is why I like these forums.....

Someone posts code that works but might not be the best way (me) and then others follow-up with their suggestions. No...

J Livingston SQL (6/30/2015)

---

just a thought......move the "grand total" into the report footer section and not in the detail section.

google will be your friend if you are not sure how...

Jason A. Long (6/29/2015)

---

skilly2 (6/29/2015)

---

This solution worked as well. It works well with a small number of rows, but I don't think is easy as the above solution to...

pietlinden (6/27/2015)

---

UNION your real result set with something like

SELECT Null, Null, Null

FROM Tally

WHERE n<=@NumRows

you would need to figure out the count of missing rows to do it, but that would...

Eirikur Eiriksson (5/11/2015)

---

skilly2 (5/11/2015)

---

I have a stored procedure that runs every 5 minutes. I have one block in the procedure that will only run if there are records in...

After reading Scott's reply, I further simplified the code to: IF (DATEPART(MINUTE,GETDATE()) BETWEEN 00 AND 04

OR DATEPART(MINUTE,GETDATE()) BETWEEN 30 AND 34)

AND OBJECT_ID('tempdb..#tmpClosedPOs') IS NOT NULL

I had to change it to...

Thanks Andrew! I didn't realize I could use DatePart directly in the IF statement. For some reason I was thinking I had to somehow get it into a...

Jeff Moden (4/13/2015)

---

Stop using Pivot altogether. Just use a CROSSTAB, which is driven by CASE statements to begin with. See the following article for a primer.

http://www.sqlservercentral.com/articles/T-SQL/63681/

As a bit...

This is what I ended up doing. I just wasn't sure what aggregate to use for the PIVOT portion...

This worked perfectly! I'm still trying to wrap my head around it though. I understand what the Over (Partition statement does normally, but I've never used the Rows...

Thanks for the compliment on the sample and explanation... However, I still didn't explain it 100% correctly :-). The query you gave is exactly what I asked for, but...

Sorry about leaving the specifics of the group out. Before submitting, I read my post and it made sense to me - of course. Sorry I missed the...

Lynn, I was just putting together the sample DDL for creating the tables and sample data as Sean suggested, when I saw your post come through. Your post is...

Sorry my post wasn't very clear. Each audit needs to have someone assigned to complete the audit. I'd like to assign the next employee in our employee table...