L' Eomot Inversé (9/24/2012)

---

Sean Lange (9/24/2012)

---

Tom I was typing before I really understood the question completely. Maybe if I had used the...

Tom I was typing before I really understood the question completely. Maybe if I had used the word history instead of audit...

Oh I think I see your error. You fully qualified the column to update which I think will not work. If Lynn's does not work try this one. Although he...

Gazareth (9/24/2012)

---

Ha, almost certainly!

Thanks for your input Sean, just had a nagging thought at the back of my head that I can...

SQL_beginner1 (9/24/2012)

---

Sean, the code you provided returned one row of data that included all the columns from table ContractData; and accountnumber, sourcesystem, effectivedate, siccode & coreprocesstoken18 from UDBSourceData for the...

SQL_beginner1 (9/24/2012)

---

Lynn, it's a table.

Both the source and the destination tables have the same columns, and I need to update the column coreprocesstoken18 in...

Gazareth (9/24/2012)

---

Sean Lange (9/24/2012)

---

Are you trying to audit when a given sourcefile was used to update a specific server? The way you have this coded you can only ever update...

I too suspect this is a view. What does this return?

select top 1 *

FROM ContractData AS cd

INNER JOIN

(select accountnumber, sourcesystem, effectivedate, siccode, coreprocesstoken18

from RR_GMC.RCA.dbo.UDBSourceData

where sourcesystem = 'CAN'

and effectivedate = '6/30/2012')...

I see you are pretty new around here. For this type of thing it really requires that you post ddl (create table statements) and sample data (insert statements) along with...

Gazareth (9/24/2012)

---

Hello,

I seem to recall from my database design classes a while back, being told that a link table with just a datetime field in wasn't really a link table.

I've...

chinn_chris (9/24/2012)

---

Yes, that does help. Thank you for your almost immediate response! I had a feeling it might be that but couldn't find anything online about that particular...

chinn_chris (9/24/2012)

---

Okay, here's the deal. I have the below select statement I'm trying to analyze but I've never seen this particular use of NULL in a select statement of...

As previously stated this is high potential of the issue.

WHERE SD.Code IS NOT NULL AND RTRIM(LTRIM(SD.Code ))<>''

That renders your query nonSARGable. You could change that be simply:

WHERE SD.Code > ''

This...

mick burden (9/24/2012)

---

if I have a table with fields which contain common delimited data in them, is there a way I can read them into some kind of temporary table,...

martin 81121 (9/24/2012)

---

Hi

We are looking to upgrade our current SQL and Server, at the minute a lot of our larger tables (2-3 million rows) are timing out when I...