It may just be the pathing. I've broken the XQUERY component out here directly as a local doc. See if this fixes the issue, else we'll have to...

I... think so.

Tell me if this does basically what you're looking for, and where, if anywhere, it goes awry:

DECLARE @CHG_ITEM TABLE(

CHARGE_BATCH_ID int,

CHARGE_ITEM_IDint,

REVENUE_SITE_IDint)

INSERT INTO...

+1 to Sean's recommendation, OUTPUT is the way to go for this from SQL 2k5+.

The earlier alternatives are very, very messy and require a lot of coding to make your...

*scratches head* This seems like standard ETL and warehouse work. Are you looking to know the keywords to reseach on? I'm not sure what you're looking for here.

SQL_Enthusiast (1/29/2013)

---

I admit, I was frustrated yesterday and I took it out on the forum. It just appears that with little effort on a post, I get the "best practices"...

:blush:Yeah, that works too guys. Sorry about that, I'm chalking that one up to cold meds and a different DB system mixing up my head. Well, now the...

EDIT: That query can't run as is, need to adjust for the group by.

Ah, apologies, I could have worded that a LOT more clearly. Easy enough. You take...

UPDATE table SET newcol = @@SERVERNAME

Unless I'm really not understanding the question?

That is a wild solution. Out of curiousity I went bounding through the intertubes to attempt to figure out what that does. It appears to suppress warning errors...

Subquery it. IE:

SELECT * FROM

( SELECT max(abc) AS maxABC FROM #table)

ORDER BY

maxABC

Pretty much, but you're not dealing with a server problem with PAGEIOLATCH. That's a Disk I/O wait type. Your Drive I/O is just huge and you're waiting until...

As Pedro mentioned, size of table is important to seek vs. scan, but as is order of fields in the index and continuity. There are a number of rules...

I finally managed to get my google-fu going, but posting for resolution.

The answer is.... (Hey, Maestro... drumroll please? Dude? Dammit)...

TRIM( (DT_STR,16,1252)Quantity) =="" ? (DT_STR,16,1252)NULL(DT_STR,16,1252) : Quantity

You have to...

Heya Newbie,

We're gonna need a bunch more to help you on this one, including the .sqlplan and query. Check out the second link down in my signature on the...

Abdul Rahman (1/23/2013)

---

Hi

We have simple Adhoc queries running from an application.

The query runs for hours and gets timed out.

At the same time I could see from Activity Monitor that it...