That's the name of the table you gave in your original post.

John

Several ways to do this. Probably the easiest is something like this:

INSERT INTO #order

EXEC xp_cmdshell 'dir /b \\order\2016'

John

I copied and pasted those very words into my favourite search engine. The question was answered in the very first result.

John

The first thing I would try is to change SQL Server Agent to run under a domain account instead of a built-in account. I appreciate that it's frustrating that...

It's not what you can access that's important - it's what SQL Server can access. If I remember correctly,...

Not necessarily. The query below...

Grumpiness will be the least of your worries. It will be more difficult to validate entries, and you're breaking the rules of normalisation by forcing two attributes into one...

You can't fit a square peg into a round hole. If you don't want to add and extra column to t3, you'll have to resort to unsatisfactory methods such...

Do you have sp_whoisactive on your server? If not, look it up, install it on a test server, and when you're happy with it, put it on your live...

Gail is right about Task Manager, of course. But even if we assume Task Manager is telling the truth,...

What details of the password policy are you looking for? As far as I know, the password policy is inherited from Windows and doesn't change from login to login.

John

If the source and destination are in the same database, or even a different database on the same instance, I'd be surprised if SSIS were the better option. But...

It's better use proper date arithmetic than rely on character conversions that are less efficient and vulnerable to regional settings. Try something like this:

SET @START_DATE = DATEADD(MONTH,@START_MONTH-1,DATEADD(YEAR,@START_YEAR-1900,'19000101')

John

Does the query work if you run it in Management Studio?

If this is something you're going to do frequently (or even if it isn't), you might consider creating a permanent...

You haven't posted the stored procedure definition, but I'm guessing it connects to a remote server, maybe using a linked server. Perhaps 2:00 to 2:30 am is when index...