Some DDL and a test set. Alas, I lost some valuable time writing this while you could have easily provided it yourself 🙁 -see the posting etiquette link in...

Recurs1on (3/6/2012)

---

I have no idea why your query doesn't work, but if you re-write it as follows, it seems to work fine.

WITH SALES

AS (

SELECT

...

Yeez, it's a game. And the only thing you can win is 'points'...

Get a life guys.

What differences have you found so far? Try and explain in your own words and you'll either get applause or explanations where you've gone wrong.

i.e. assuming the name...

As usual when service broker is involved the code is bit lengthy, but it is a good question.

In my experience errors like these are less likely if you get used...

And again I learned something. I've never had to use dbmail so far. So I googled and quickly found the right answer 😉

Thanks

I too was looking for the catch for a while and then decided there was none. Nice, basic question. Thanks

Have a look at openrowset(). This can be used to read from a file on the server's file system (if the admin permits it. If not you'll get a lot...

Now that you've explained that this is for study purposes, we'll be able to give you the information on a level that you will be able to understand.

You'll have to...

User ZIYkkE22ol has been reported.

ladyblue1075 (3/4/2012)

---

Ok. This answers one of the errors. I'll note that. Thanks, Grasshopper!

manukumar (3/4/2012)

---

You can not truncate the table if any column is referred by any other table like primary...

Your bulk insert doesn't need to go into the production database directly. i.e. You can ask your admin to create a separate 'staging' database on the same server as your...

ColdCoffee (3/2/2012)

---

This?

SELECT OutTab.TABLE_NAME,

STUFF ( (

SELECT ', '+InTab.COLUMN_NAME

...

Best use a 'calendar table'; A table that has a row for each period that you want to group by on. Such tables are very handy in many queries, so...