I was trying out ..:

exec (@sql)

SELECT CONVERT(int, @sql)

SET @CardCount = @sql

But yours did the trick.

Thanks PW.

Marshall,

Thank you for your response, it all makes much better sense now.

Todd, Thanks.

That's the game plan I have as well, I was hoping there would be some SQL migration tool like they have for Windows ...

dude, what the hell? you didn't try redgate sql back 4.1 or any of those other product because you want to make sure you can restore the database?  WTF is...

select * from table1 where DateCol between '2/03/2006' and '12/03/2006'

that should get you the date between those two time frames.  Good luck.

yeah I was looking at that sp_helptext, thought about trying another SQL analyzer app, but looking at the sproc itself, its hard coded for 255 char.

Thanks for the help, everyone.

Scorpion_66, if you can find the table please let me know.  I will look in BOL to see if the information is in there.

Lucky, thanks for telling me about sp_helptext...

I selected A as the answer:

1 (A).

Schema1    Table1dbo        Table1

My coworker suggested B as the answer but I know...

Choice C is:

The POWER function requires a parameter of either "HIGH" or "LOW"

PW, once again, thank you.

I was looking at the other functions (datediff, datepart, etc ...) and didn't look at convert.

hrmm not sure what happen to my other post but that was pretty damn easy.  I spent over 2 hours trying to figure this darn update statement out.

I appreciate your...

Yes the table does have a PKID for column cardnbr.  Other than that, that's it.

thanks for your response.

vendor is a column in the JackInTheBox table ... could you please expand further?

Thank you.

thanks, I will give it a shot later this afternoon.

Bellis, will that give me the yyyy/mm/dd format?