@Lynn - I was wondering how you were going to answer this one - you did a superb job!

Because you're trying to do it as an integer...

You need to convert put it in a string to convert it to smalldatetime. Try:

set MyField = convert(char(8), 19000101)

Hi J,

It really does help to have some test data to work against. See the first link in my signature for how to do this.

But, to help you out, here...

For me, programming computers is my passion. There are other things that I enjoy, but this is my passion. I can't imagine doing anything else.

It does have its downsides......

Use a table-valued delimited-split function, with a cross apply, to handle this. The tvf returns the individual parts of the passed-in string as a table.

First, if you don't have the...

jcrawf02 (5/27/2010)

---

Jack Corbett (5/27/2010)

---

jcrawf02 (5/27/2010)

---

Paul White NZ (5/27/2010)

---

Dave Ballantyne (5/27/2010)

---

I find intellisense and its most annoying when putting together test code , ie where im quite happy for a column...

So, if it does upset me, then you'll go ahead and buy...

LOL

The Dixie Flatline (5/27/2010)

---

At the last PASS summit, I had a chance to talk for about an hour at breakfast with a man from Microsoft who is part of the...

Check out the two links in my signature for CROSS-TABS and PIVOTS.

If you still need help, check out the first link in my signature.

Good going Lutz. I completely missed that he specified one column with CSV output... Thanks!

This little bit of code makes a dynamic table of the possible strings, then gets the next one from what is passed in.

declare @test-2 varchar(4)

set @test-2 = 'AAZ'

-- See Jeff...

cmckenzie-656927 (5/27/2010)

---

I have to tables for a report. the first table has customers and the second table has orders for customers. I would like to create a query and/or report...

Check out this link for how to add to the "My Places" bar on the left side of the open/save as dialog box. Note that the instructions are for SSMS...

Paul White NZ (5/24/2010)A full-text index is the same, storage-wise, as any other non-clustered index. The parent object has an entry in sys.internal_tables, and the DBCC commands can be...