Geez, Jeff: this was example code for posting to SSC only, and not the full text of what I was actually using.

In particular, the recursive CTE was junk code to...

Glad you got there!

Yes, with named instances you must include the server\instance in the connection string.

Thanks for letting us know you were able to make it work,

Rich

Can you please try connecting using the syntax I posted?

You have a line [.Provider = "Microsoft.Access.OLEDB.10.0"] in your code. If you are trying to connect to a SQL Server,...

Chris, thanks to you too, you nailed it. Dunno why I couldn't see that before....

Rich

Not quite, but I...

Here's some generic VBA code to get you started using ADO in Access. It relies on a trusted connection to the database.

You will always need to first set a...

Sean Lange (10/17/2011)

---

Good question and actually makes sense if you think about it. The check constraint is checking for values. From BOL

CHECK constraints enforce domain integrity by limiting the...

Thanks for a good question. I got it right, but I thought that perhaps only one such NULL INSERT would be allowed. After reading the BOL entry and...

Thanks for the reply. Let me respond bit by bit:

Why not spend that time coding a PowerShell script where you can move across the boundaries of the file system...

opc.three (10/13/2011)

---

Personally I think using the CLR functionality to access files from with a T-SQL context, while preferable over using xp_CmdShell, is still a misguided application of the CLR. It...

Great, glad to pass on good stuff I've found useful!

Rich

As Lowell and Craig both mentioned, you must differentiate between INSERTs involving a single row (OK to use SCOPE_IDENTITY) and those involving multiple rows (cannot use SCOPE_IDENTITY). SCOPE_IDENTITY will...

Did you search here? Here's a post on computing medians.

Rich

Well, I got it wrong [i]sic[/i] for the right [i]sic[/i] reason: like the rest of you, if my column names don't match in my queries, I usually get errors. ...

jcrawf02 (9/16/2011)

---

rmechaber (9/16/2011)

---

It's good that you "have a problem with this", b/c if you try doing it with a computer, you will have problems! The computer only approximates reality....