Fewer steps and converts nulls to blanks if you want them (take out the ISNULL operator if you don't want null values). You can also easily make the delimiter a...

Just yesterday by coincidence I needed a query to parse dynamic XML with different nodes and properties on each run and came up with this procedure using CTEs which is...

Here's a FAST function that avoids using a loop and uses a clustered index seek on the output table by adding a primary key and using that in the WHERE...

Excellent functions. I've already tested them on my own server (2008) and added them to my toolbox of functions. In case you are interested, I added a tiny modification to...

Eric M Russell (12/14/2011)

---

I think more explanation is needed about what your script is demonstrating. Is your specific intent to demonstrate how to select from a "remote" stored procedure?

When...

I learned long, long ago in a galaxy far, far away to NEVER EVER tell people "I work on computers" unless I want to be asked to work on THEIR...

My first thought on this topic had nothing to do with people per se.

I inherit a lot of databases and sometimes architect databases that I pass along to others later....

LightVader (9/9/2011)

---

Steven Willis (9/9/2011)

---

Not that SQL server development or administration is trivial, but I think the problem I see with the majority of developers is their lack of basic business...

I have been in IT since the 1970s (yes, I'm an old fart who remembers punch cards). I have a BA in Management and an MBA. I was an officer...

Now a second question...I personally avoid using UNIQUEIDENTIFIER cols as part of a primary key. But sometimes I have no choice when I've inherited a schema from someone else. I've...

Here's two sample queries that will run against the default DotNetNuke schema. Note the only difference is in the second query in which I've added to the where clause a...

Someone recently posted a function like the one below that I have modified to validate US/Canadian format phone numbers. Sorry that I can't remember the OP to give proper credit....

I've been using Jeff Moden's procedures and a tally table for years. The function in the OP is not the correct way to split CSVs, with the possible exception of...

This function as written may allow bad data to get formatted as what might appear as valid numbers. I liked the general idea but only wanted to allow 10 or...

Excellent script. Came in very handy today as I was working on a project to import Access data into SQL. Thanks!