your psuedo code for your table wasn't readable to me, and oyu didn't provide any real, concrete CREATE TABLE or data for us to use.

here's a quick example i fleshed...

here's my version:

it returns a dataset of what matched, so you can drill down to it:

--ok, really you only need to search columns that are of type

--varchar,char,nvarchar and ntext....

--you...

so if you had a report, and say you wanted to barcode some invoice number, right, you would just add an IMG tag and build the SRC dynamically;

it doesn't get much easier than what Gianluca showed you:

i took that code, threw it on a web server, but had to hunt down the bar code font:

in my case,...

create an role or an application role,and add the windows users to the role? then they never need to touch the server password, they just have to have access to...

Thanks Jamie; that's about how i would have tackled it too, but i thought there was some new sys views or the DMV Data Management Views that might identify...

temp tables are dropped when you are done with them.

a foreign key prevents something from being dropped before it's child references. If you disconnect your spid, then if foreign keys...

numeric (38,0) would be 38 significant digits, NONE to the right of the decimal place.

you want numeric(38,6) for example...38 digits, so that would be 32 to the left of the...

ok, it's making a little more sense; do all the staging tables have a common layout, or, as in your example, they might be missing some columns? is there ONE...

ironically it's really easy: the INSERT command combined with a SELECT with no WHERE statement will copy it all for you.

Insert Into NewTable (ColumnList...)

Select ColumnList...

From OldTable

--Order By OldPK --optional...

well...yes it is possible, but without more info, you won't have any useful product.

100 tables? as many as 200 columns per table? an you just want to merge them all...

that is one of the coolest things I've seen in a long time; Thanks Paul, I learned something,and have a shiny new toy to play with now.

I added this to...

Paul i tried your example on SQL2005 Standard, SP3, but i get a syntax error in a 9.0 compatibility database, as well as master. is that a 2008 feature? it...

Mat gave you the script to read the flags of the status column; that is exact where it is stored/accessible...it might not be exactly what you wanted, but that's where...

not even familir with unix by any means, but if the commands you pasted can be copied/pasted to a Windows cmd window, which then does the connection to the remote...