Viewing 15 posts - 10,546 through 10,560 (of 13,469 total)
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...
September 11, 2009 at 12:28 pm
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...
September 11, 2009 at 12:15 pm
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;
September 11, 2009 at 8:14 am
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,...
September 11, 2009 at 8:05 am
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...
September 10, 2009 at 9:22 am
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...
September 10, 2009 at 9:14 am
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...
September 10, 2009 at 5:48 am
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...
September 9, 2009 at 9:11 pm
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...
September 9, 2009 at 10:45 am
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...
September 8, 2009 at 6:51 pm
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...
September 8, 2009 at 6:25 pm
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...
September 8, 2009 at 5:42 pm
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...
September 8, 2009 at 5:12 pm
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...
September 8, 2009 at 2:32 pm
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...
September 8, 2009 at 11:05 am
Viewing 15 posts - 10,546 through 10,560 (of 13,469 total)