Thanks Craig!! That sounds like a better idea.

Thanks opc!

GSquared - Thanks for your reply!

ItemNbr is buried in another string, ProductNbr. ProductNbr donot have spaces

Sample data:

ItemNbr: 1455363 (ItemNbr though varchar(100), it has integer values)

ProductNbr: ZEFT.97771455363

Unfortunately, the...

Ok - I figured out that checkpoints donot work well with parallel tasks. Thanks.

Thank you guys. I appreciate ur quick replies.

Thank You very much, Gus. I appreciate all your help.

Hi Gsquared,

That was good explanation. Thank You.

I have link table which links to tables.Their columns are basically

LinkID(Primaty key idendity column)

OrgID(Foreign Key)

ProductID(Foreign Key)

StartDate

EndDate

IsActive(bit)

Now i wanna if i...

GSquared,

Thanks for ur reply. But if I add them to other index say PathID, then in the WHERE clause i should use the columns in same...

ThankYou Guys, I really appreciate that

Wow.. Jack, U are awesome. That was quite an effort on ur part. Thank you very much 🙂

Hi Lynn,

I am trying to create a generic audit process in stored proc. I know there is going to be some performance degradation. But my manager wants it...

Thank you jack and steve,

I am doing somethin like this in a trigger for update

select * into #td from deleted

select * into #ti from inserted

exec samplestoredproc

This...

Hi,

The update trigger will trigger even if the record is actually not updated right. Can we stop the update to the main table if the update dint actually...

Hi Steve,

yep that makes sense. So when we dont delete the records from main table, then joining the audit and main table shoud have audit data for...

We are creating the audit process for clients to track changes which means we have a screen for them to display the audit data. In that case, all the foreign...

Hi Gsquared,

That was a quick reply. I read ur articles on auditing a month back. Those 2 articles was awesome and Only that got me started. Again now...