Thanks guys,

Yeah, I know it's not good practice to have servers doing multiple roles (ie Active Directory and SQL DB on same server) or (IIS and SQL DB on same...

I think this has potential to work, but right now its not. The rowcount is not coming from the dynamic sql statement. It looks like its coming from...

I like how that @@rowcount looks. Ill try that.

Thanks,

Strick

The print SQL returns

IF NOT EXISTS (SELECT PhotoID FROM Production.Product WHERE PhotoID = 3313553)

BEGIN

...

Hi David looks like there is an end quote. Its right afer End

End'

Strick

Thanks guys,

Look like what Adam has works good. Now, for my "stuff" in the if statement how would I set a variable bit value equal to 1? I'm...

Sweet thanks guys,

Its always something small..lol

Strick

I totally aggree. This is why I wouldn't recommend it. Unfortunately he said that he can't add a ID key field with an identity property on it. ...

Hi,

I see,

Do you have the ability to change the default propert in your time field? You can set the default propert to (getdate()) which will timestamp this field as...

Hi, Thanks,

Reason I can't write the queries I need is because the fieldname changes based on the variable making it a little more dynamic. What I have works great...

If I'm understanding you correctly, the best way would by to add an ID field and enable the identity property on it. This will automatically increment a unique number...

I agree with the posts that say you should use a programming language to do this. But if you don't have programming software and have to use SQL...

Matt,

We are definately seeing eye to eye on this one.

It's funny that you knew exactly where I was going with this once I explained it. We actually had a...

Thanks guys,

I was actually looking into the method you suggested Matt.

Also to answer your question, Matt, I'm implementing a trigger which will track all updates from tableA. ...

Thanks guys,

I'm going to test it out!

Strick