It will only show some pointer information in the Grid mode... you must be in the Text mode to see the data from a Text datatype.

Best thing to do would...

If you feel that you must split application code to make it easy to find, create a new database for each application... store only code and definition tables in these...

Heh, heh... in my shop, yes... 😛

Check the following URL... someone made the terrible mistake of naming tables and objects after customers and now he's in a bit of trouble...

http://www.sqlservercentral.com/Forums/Topic439936-5-1.aspx

Do...

This will do it... could turn it into a function...

DECLARE @PurchaseReqNo VARCHAR(50)

SET @PurchaseReqNo = '12,241,342,34234'

DECLARE @TempTab TABLE (Element INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, ReqQty INT)

INSERT...

If you have TempDB set up to auto-grow by 10% like everyone else seems to, it will cause 73 fragments as it grows to 1 gig. And, I agree...

Just so you know... Books Online comes with SQL...

The beating is better...

If the code must ever be executed more than once, it will fail because the tables in the two or more instances of the proc will be...

Didn't look that way to me,...

What do you use SQL Server 2000, instead?

Yeaup, we all need rules... but to keep from becoming a non-thinking "SQL Clone", ya gotta read about the "5 Monkeys Experiment"... you'll see what I mean... 😉

http://www.lanebaldwin.com/v03I8.htm

Dunno if there's...

If you use the extra parameter I posted in 2k or 2k5, it will also...

Maybe not in SQL Server 7 because of the...

Yes... and sorry I missed that... I verified that Store_key was the same in both tables and didn't even look Orig_Store_key.

That's pretty cool... Thanks, Rob...

Carl Federl (1/7/2008)

---

"f I am understanding what you wrote then the solution is truly laughable from a performance (and coding) standpoint!! You have to create two tables and populate them...