😀

(You didn't think of my article for explaining it?...

Well, just expanding upon your cte, we can get the other columns that you're looking for:

(Note that I shifted over to using a table variable instead of the temp table...

1. I don't think that you need to use the double-quotes around the 3-part db.schema.object unless it contains a space or quotation mark; then you would also need to use...

Matt,

Based on the sample data that you provided (BTW - THANK YOU!!!), can you show us what the expected output is?

(Question - is the data really INT? You're putting character...

This article should help you out - both with understanding, and coding: SQL Server Ranking Functions[/url]

Hmm. It's the end users that keep you in a job... 😀

Craig Farrell (3/14/2011)

---

The above will work if it's in the command of the jobstep. If it's buried in SSIS, you're SoL. You can try a trace to track...

timotech (3/14/2011)

---

Hi all, please how can i ensure that i get accurate dates for example, if i enter '28 feb 2011' for @BeginDate, and i count one year back, i...

drew.allen (3/14/2011)

---

There is a separate forum for SQL...

Steve, I thought you looked over all of them anyway? 😉

mattboston (3/14/2011)

---

I currently have a single SQL Server 2005 Standard 64-bit server running on Windows Server 2003 Enterprise. To plan for redundancy I'm looking at using the Microsoft Failover...

NP 😎

mar311 (3/14/2011)

---

Thanks for the feedback. What I'm ultimately looking for is to create new columns for the "Grand Totals" and then pull the single value from that column via SP...

The only way you're going to be able to do this is if you add the comID column to TableA, insert into that, and use the INSERTED.comID to insert into...

Let's see if I understand this correctly. If we take the information from your last post, and only do the inserts for TableC, you then want to insert all the...