GilaMonster (6/26/2015)

---

Ask me over coffee sometime, somewhere.

I don't know. Company won't pay for me...

If y'all didn't know the speakers for this year's PASS Summit has been announced, http://www.sqlpass.org/summit/2015/Sessions/Speakers.aspx. Several Threadizens on the list, myslef included for the first time. The most...

Great solution Jeff. I had to think about it a bit to understand the why, but I get it.

Can you post the entire query?

I'd suggest you try this pattern:

WHERE NOT EXISTS(select DB2.dbo.tblFPO.WarrantyWOID from DB2.dbo.tblFPO where DIV_ID <> 5 and DIV_ID is Not null and WarrantyWOID = DB1.dbo.ITEM.item_ItemNumber)

It depends. Just changing the inline query into a stored procedure likely won't improve performance, but having the query in an stored procedure does make tuning the query easier...

This is a duplicate post. There are answers, maybe not adequate ones, here, http://www.sqlservercentral.com/Forums/FindPost1696979.aspx. Please put new answers there so the thread stays together.

Wow, that's an interesting stored procedure.

So just to be sure I understand, is the location_load table is the load table you are referencing in your initial post?

Are there more than...

Sean Lange (6/23/2015)

---

greglove (6/23/2015)

---

I want to study for SQL Server 2012 MCSA certification. Aside from study material, I assume I'll need SQL Server 2012 itself.

What edition do I need?...

The fields on the report are driven by the final Select query which gets its data from the @EmployeeTbl so you either need to join to that and add the...

What do you mean by "group all system 3 records"?

Are all the rows from the source table going to the same destination table? If they are why do you...

Steve Jones - SSC Editor (6/23/2015)

---

It did. Kevin Boyles and I broke it, but someone...

dunn_Stephen (6/23/2015)

---

TITLE: Microsoft Visual Studio

------------------------------

Error at Data Flow Task [Derived Column 1 [45]]: Attempt to find the input column named "xmlMessage" failed with error code 0xC0010009. The input column specified...

When I pasted in the expression it replaced the < and > so you need to replace "& lt" and "& gt" with < and >.

Try this:

SUBSTRING(xmlMessage,FINDSTRING(xmlMessage,"<dateTime>",1) + LEN("<dateTime>"),FINDSTRING(xmlMessage,"</dateTime",1) - (FINDSTRING(xmlMessage,"<dateTime>",1) + LEN("<dateTime>")))

Steve Jones - SSC Editor (6/23/2015)

---

This is exactly what DLM Dashboard was designed to do. Catch changes in schema. It works well for me in small projects here.

Disclosure: I work...