Can we get you to post your sample data in the form of insert statements? This will make it A LOT easier to test the result before we post it....

First, let's put the test data in a format that can be easily used by people here. If you had done this, other people would have been more willing to...

Hi Parthi,

This is actually pretty easy to do... once you understand how to do it 😀

First, you need to put the data into something with an XML data type. In...

Excellent article. The only thing I think would have been nice to add (and which has been covered in this discussion forum) is how to pass the data into the...

Duncan Pryde (7/8/2010)

---

It only "tabifies" groups of 4 spaces starting from the left, so if you have 5 spaces at the beginning of the line, you'll get a tab and...

select name

from sys.objects

where type IN ('IF', -- SQL_INLINE_TABLE_VALUED_FUNCTION

'TF',...

crossmj (7/7/2010)

---

Wayne,

It took me awhile to understand this message:

Msg 214, Level 16, State 2, Procedure sp_executesql, Line 1

Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

I finally...

I'll bet you didn't know you can update variables at the same time as columns in an UPDATE statement. This should work for you.

declare @clientid int

select @clientid = select max(clientid)+1...

mmcardle (7/7/2010)

---

I was hoping to use a table variable because a) I was a bit temp table-happy when I first started with SQL and realised later that it's best to...

SQLEE (7/7/2010)

---

How do I account for the value of an identity column when doing an insert to a table. A NOT NULL vaule won't work and throws an error. Col4...

Grant Fritchey (7/7/2010)

---

WayneS (7/6/2010)

---

Jeff Moden (7/6/2010)

---

CirquedeSQLeil (7/6/2010)

---

WayneS (7/5/2010)

---

Since there's a bit of talk going on about topics to present and such, I'd like to get some input from some of...

Jeff Moden (7/6/2010)

---

CirquedeSQLeil (7/6/2010)

---

WayneS (7/5/2010)

---

Since there's a bit of talk going on about topics to present and such, I'd like to get some input from some of the Threadizens...

I've been...

crossmj (7/6/2010)

---

Thanks to Wayne and Lowell.

My project is currently on hold, but I have been able by using a modified version of Lowell's script to find the tables containing...

I ran the steps you posted, but did not receive an error. It looks like you might be utilizing the GetBytes function when it's generating your error, but you didn't...

Mr_Bacon (7/6/2010)

---

I think I have cracked it, might be overcomplicating things but the below seems to work, pending further testing. The below covers me for the 24 hour period required.

I...