i recently had a view that gave different column definitions that if i ran the select portion of the view from getting the select via SP_HELPTEXT viewname.

as a result, i...

perfect; that's why i love the forums here; somewhere, sometime, someone must have fixed a problem someone else is going to get;

way to go!

you still need to use DTS, but instead of selecting a table, you can choose the second option "Use a query to specify the data to transfer"

in my example, i...

here's noeld's script witht he username pulled out as a parameter:in my example the username is 'hds'; i don't know how this will work for NT logins.

declare @cmd varchar(300)

declare...

you've got to look at the vb6 code; the issue is that you are referencing an object that hasn't been initialized; for example, if you create an ADODB.Connection but forgot...

here's an idea pending better definition of the WHERE statement: note that everything would be in foreign key hierachy as described previously.

this assumes that the foreign key column name is...

i've got a decent idea how to do this, but what is your filter criteria?

i assume it is sometable.columname in(1,2,3) or sometable.columname  < 3000 or something, and you want to...

the DDL helps a lot, in this case i think i'd need row values to extrapolate this correctly.

i think this group by statement would give you the question as well...

error trapping in TSQL is pretty limited;

if an error is level 16 or above(foreign key constraint violations, primary key, etc), they raise an error that cannot be trapped in TSQL,...

there is a stored procedure you can use to get all the tablenames in hierarchy order.

here's an example:

create table #tuser (type int, oname varchar(517), owner varchar(517), seq int)

insert #tuser exec...

you can do it in a single with something like this:

declare @somekey int

set @somekey=1

if exists(select * from ItemTableOne  where someval=@somekey)

select * from ItemTableOne  where someval=@somekey

else

select...

nothing predefined, but you can easily take Tyson's example and create a stored proc witht eh same code.

if you change a .config file or .aspx, no recompilation is needed. if you change a .vb file, then yess you have to recompile.

i'm guessing table joining and reserved word issues here?

does this look a little better?

SELECT ICDCODE FROM DIAGS

INNER JOIN [PROCEDURE] ON  DIAGS.DIAGID = Procedure.DIAGID

i think the issue is permissions. the user running the app does not have write permissions to HKey LocalMachine;

When you type in an instance in the SQL manager, it tries...