What are you expecting for results? Also, could put that into a consumable format as described in the first link in my signature? It'll help us give you...

herladygeekedness (6/21/2012)

---

I would love more info on how to add conditional logic to a SQL Agent job as I have not found that functionality and could certainly put it to...

Heya there, and welcome to the forums. If you'll take a look at the first link in my signature below, you'll see a recommendation...

Um, that's Charmer, nothing new there. He's always had a very difficult time with the English language, enough that it...

L' Eomot Inversé (6/20/2012)

---

The thread seems very quiet. I've been away three days and there are only 62 new posts on it.

But I may not find...

You most likely want to work off the lot inventory instead off the transactions list because you have to resum all sells to determine what tax lot you're involved with...

Jeff Moden (6/18/2012)

---

But, do you know your business? Can your "code" support the required spreadsheet for some, the "report" for others, PowerPivot or other DW based system...

Mmmmm... tasty foot. Anyone want a bite? :pinch:

One of those days... :Whistling:

WayneS (6/18/2012)

---

I'll be starting the new job in a couple of weeks. I'll be a DBA with a small company that some of you'll in the northeast corridor might have...

Jan Van der Eecken (6/18/2012)

---

Evil Kraig F (6/18/2012)

---

LOL, at this point, either is acceptable. 😉 :w00t:

It just depends...

Meh, I can't be bothered to de-rant him this time. Someone else do it...

LOL, at this point, either is acceptable. 😉 :w00t:

It just depends on which of the twins you want...

Jan Van der Eecken (6/18/2012)

---

If you run

select * from sys.sysprocesses WHERE spid = @@SPID

does it give you what you need to know in the nt_domain and nt_username columns? I'm running...

Hope you don't mind if I chime in on this discussion Jeff. 🙂

Jeff Moden (6/18/2012)

---

SQLKnowItAll (6/18/2012)

---

So, when working with a set of data I believe it is much easier and...

kharol (6/18/2012)

---

Duncan:

I thought about parameter sniffing, but all resource I found about it was related to stored procedures. Nevertheless, I tried wrapping it in stored procedure that would do exactly...