I believe the function we are using is the one described at MSDN Sql 2000: Building the Fn_Split() Function, but due to the rules here I cant paste it. I...

I read through this and the first thing I thought of was using fn_Split to break up the List, I wonder if his fn_IntListToTbl is some derivative of that.

I...

Kinda need to agree with Jay on this one. Even though it is functional, it is not something I would be using for my applications.

For my usage, I would probably...

I came up with the same solution as Lutz and I express the same reservations that Lutz and Gail pointed out.

A variant of this would be to copy the data...

It is the front ends responsibility to provide at least rudimentary validation of the data- you can use a date-picker, a pop-up picker for the text box, or even multiple...

You can use sp_OACreate to access the the File System Object (Active X)

reading & writing files in sql server[/url]

Jonathan Kehayias (9/24/2010)

---

Mad Myche (9/24/2010)

---

I don't get to play with all of the latest sql/os combinations yet (currently 2000 on 2003 server), but could scripting be created to integrate with...

I don't get to play with all of the latest sql/os combinations yet (currently 2000 on 2003 server), but could scripting be created to integrate with CLR or Powershell to...

I fully understand the need to have a solid car and a solid computer system, be it my home workstation, my webservers, or the Sql platform. I have also experienced...

You actually had me worried for a moment.

I have inherited some tables that use NULL as a 3rd value on Bit fields

I'm for saving the filename in the db- as you can search the text. Not to mention the bloat that images have been known to do

Thank you Jeff and Lowell, that block of code has been saved and executed (many times).

My SQL in the past has only been writing statements and creating views, with no...