I would use the dreaded Dynamic SQL to build your email. Embed the whole proc and arguments into the dynamic sql, adding in the proper name, then execute it.

Depending on...

There are multiple types of snapshots in SQL Server. Please clarify which type you're referring to.

Lowell, that's brilliant code. Even though this wasn't my question, I may have to keep your solution in my SQL files for future reference. @=)

I am curious, though. Why would anyone burn data files on DVD? There are more reliable and much better storage options available that allow for bigger files. These options will...

1) Only pull the columns and rows you need from the source (instead of everything). -- In other words, Filter, Filter, Filter.

2) Run the package when little-to-no other traffic or...

FYI: Port 1434 is the default UDP port.

On my local box, I have two Dev servers installed (2k5 & 2k8). Looking at my SQL Server Configuration Manager, both servers have...

karthikeyan-444867 (2/6/2011)

---

All,

I have installed sql server 2005 in my home machine. when i open management studio, it is prompting to choose the server name (By default nature). I didn't create...

anilkullam, as this is an old thread, you are more likely to get assistance if you start your own new thread and use english to ask the question instead of...

We can't see (or at least I can't) your tables. Can you repost?

EDIT: Please post table DDL (the create scripts with all keys and indexes). Pictures don't help us help...

As Jeff said, post both queries (with comments on what each is supposed to do) so we can help you combine them together or offer other advice.

WOTD: Fidget.

Hugo Kornelis (2/7/2011)

---

If I have to make a guess, it is probably because over the past years, there has been a consistent...

Ditto. I did get the correct answer, but that's not been my first choice of resolution in these instances.

Toreador (2/7/2011)

---

I wonder why they...

If you have any IT experience at all, the certs are iffy as to whether or not they'll help you get the job. If you have no official IT experience,...

Craig Farrell (2/4/2011)

---

Also, to the original question:

StartDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date) -4, +2))

EndDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date) -3, +1))

ReportDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date)-2, +1))

This query gives the...