Must be...

EXEC (@Cmd)

I noticed that the growth rate is set to 10%.  At the current size, that means that then next growth will be approximately 16 gig... that will take quite a...

I believe what you're looking for is a kind of "histogram".  The other solutions are great but if there are any unexpected characters, the cross-tabs will miss them and, if...

Have had similar problems in the past and have found it quicker to re-export the desired rows and re-import them using the parsing of Bulk Insert or BCP.

Post the code, Will...

Hey, Phil...

I just went back and read my reply about testing it... it sounds a lot sarcastic and I didn't mean to make it sound that way.  Hope you took...

Ya beat me to it, John.

Now, there's some common sense thinking outside the box... thanks, Lowell.

No, no... he's not miffed... it's a bit of a language barrier thing and, because of that, he comes off as being short...  He's really trying to help you think...

Thanks, Lynn...

Heh... I don't have 2k5, either... was going on someone else's word... thanks.

Just additional info... Foreign Keys must reference either a PK or a column with a UNIQUE index... that not-with-standing, you still can't reference a computed column as a Foreign Key...

I have a table which contains a date field which is a string with format 'yyyymmdd' ...

It's almost...

I don't think so... foreign keys don't automatically make indexes like Primary Keys do.  They make excellent candidates for indexes, though.

Pretty sure "OR" can't be used here....

 SELECT CASE RowNum

          WHEN 1 OR 10 THEN '1 or 10'

          ELSE 'Not 1 or 10'

        END

   FROM jbmTest

  WHERE RowNum <=10

Server: Msg...

The only thing you can pass to a function are scalar values... can't pass a query.