So how about a DBA who does not possess those qualities and does not qualify the criteria you have laid out? What's wrong with them? If I'm reading your editorial...

Generally, I would not care if my neighbor was one of the "people of faith" or not. Nor would I care if my neighbor's political views or non-political ways of...

nathan.holtrop (7/22/2009)

---

Ken,

I...

Thank you so much!

Slick84 (7/22/2009)

---

can I do a select against the @value to see what value its giving me after the update has been executed? in my example the @value should be 222...

can I do a select against the @value to see what value its giving me after the update has been executed? in my example the @value should be 222 rows.....

How about the below:

DECLARE @value int

UPDATECatalogFeedTestDB.dbo.tblProductSizeWidthColor

SETfbitDeleted = 0

WHEREfintProductSizeWidthColorId IN

(

SELECTpswc.fintProductSizeWidthColorId

FROMCatalogFeedTestDB.DBO.tblProductSizeWidthColor pswc

INNER JOINBMBSTAGING.dbo.tblRegularItems ri

ONri.ItemNo=pswc.fstrLongSku and ri.EdpNo=pswc.fintEcometryId

WHEREpswc.fbitDeleted = 1 AND ri.Price > 0 --AND pswc.fstrEcometryStatus = 'A1' AND pswc.fstrLongsku LIKE '%FB%'

)

SET...

lol...

Thanks! I will try to implement that and provide an update here.

Btw, I know a lot of people come here to get their code written, and I probably sounded like...

Lynn,

Thanks for the hint it does help. Would it be too much to ask for if you could do this within my update statement ? Or would you need more...

Thats much better.

The recommended ANSI SQL standard is better to implement within the TSQL code to stay future-proof while also increasing your knowledge of joins which are an integral...

You could use SQL Profiler to generate a trace file and use that within the Database Index Tuning Wizard.

Not sure if this is exactly what you are looking for...

Also, from what I've read and learned and experienced, it would be better to use Inner Joins rather than joining within the WHERE clause.

Elliott W (7/20/2009)

---

The issue I have seen with SSIS and transaction is two different pipelines in the dataflow can block each other, they do not exist in the same locking...

Jeffrey Williams (7/20/2009)

---

PaulB (7/20/2009)

---

Two questions...

1- Are we talking about a small OLTP alike transaction OR are we talking about a large ETL...

PaulB (7/20/2009)

---

Two questions...

1- Are we talking about a small OLTP alike transaction OR are we talking about a large ETL alike transaction?

2-...