Thanks, that helps.

I've started re-writing, but I'm struggling with the relationships between these tables.

There's a connection from spvohdr_all to gltrxdet by the PO control number, which is denormalized in gltrxdet...

The proxy account is for xp_cmdshell to use. It should have the rights needed to do what the stored procedure needs done, but no more than that.

Long Integer in Access = Integer in SQL Server.

Memo = varchar(max)

That one's not the text property, it's a value. Has to be queried differently:

SELECT X.SR.query('.').value('declare namespace RS="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition";(/RS:DataSet/@Name)[1]',

...

SQL Server doesn't just keep stats on indexes. It can also keep stats on columns used in queries, even if they aren't indexed.

There's a good article on it here:...

WayneS (11/2/2011)

---

Stefan Krzywicki (11/2/2011)

---

Thanks, I know I don't know everything and I might be reading things wrong, it helps to have extra opinions, especially from people who know what they're...

O.RecID being null doesn't necessarily mean a missing row. Might, but could also just be a nullable columns in the table.

JamesMorrison (11/2/2011)

---

Then they won't be DBAs long term.

Learning...

Stefan Krzywicki (11/2/2011)

---

GSquared (11/2/2011)

---

Stefan Krzywicki (11/2/2011)

---

I'm trying to find out what a support service is doing for some databases that another group here uses. We got a response that they...

Okay, so the dataset should be 1 column for the customer ID, and 14X3 (42) columns for the products. Got that.

Got it on the data being provided as-is. ...

You can't use table variable names in column-qualification. Have to alias them for that.

Exact problem is "@JobTbl.jobN".

I've seen some Convert()/Cast() uses that were SARGable, like from DateTime to Date. Does that count?

Stefan Krzywicki (11/2/2011)

---

I'm trying to find out what a support service is doing for some databases that another group here uses. We got a response that they haven't done run...

Sorry. Wasn't clear enough. What I meant was I need the create scripts for them. Then I can create copies in a test database, and rewrite the query...

GilaMonster (11/2/2011)

---

Inequalities are SARGable. It's not just equality...