would need the actual talbe def and some sample date. Nonetheesee there are several ways. If you're not concerned w using transactions then u can use and update statement join...

-- you feel the need to use a second nickname to post something you should know that you shouldn't hit the "post" button.

It's common to use a "BUMP" post if...

very cool. I will be doing the same when i have downtime. i love writting c# executables.

yep. I've resoved the issue several different ways. This isnt a new issue. Is there a way to submit these sorts of simple issue to possably be address in...

My deepest apologies Jeff. I told someone he was as useful as a paraplegic mime in a past and that didn’t go over so well. So I was under the...

what about going the other way?

I'm familiar w/ sql server and not so much in mysql. Therefore if or when i have to work in mysql which isnt very ofter...

sorry, didnt realize u had question.,

I dont recall what it was for. i think i was generating a file and the end user consuming this file wanted the categories in...

nevermind i got it. no .. between db and table, no brakets and case sensative

'select * from localxml.claimed_business_record'

i changed it in the registry and rebooted my box. It was changed back. How to i make it change perminently?

the issue is if there is at least one record in the select inside the where that you are "not in"ing to then the whole result set returns nothing. So...

Figures.

I'll get the data from a different sys table.

Thanks for your response.....

got it...below is the solution

declare @sql nvarchar(1000)

declare @testInt int

declare @ParmDefinition nvarchar(100)

--set @testInt =0

set @sql = 'select @testInt =1'

set @ParmDefinition = '@testInt int out'

exec sp_executesql

yea, that doesn't work. I've got the solution though if you want ot see it.

declare @sql nvarchar(1000)

declare @testInt int

declare @ParmDefinition nvarchar(100)

--set @testInt =0

set @sql =...

this is a much better and simpler example...

declare @sql varchar(1000)

declare @testInt int

set @testInt =0

set @sql = 'select 1'

exec (@sql)

--how can i set @testInt = to...

Eugene Elutin is right, you should be able to deduce what needs to happen from what he supplied. However, everyone has to start from somewhere and after this issue is...