I found this also. Seems to work. Takes less code.

SELECT * FROM TABLE

WHERE (@CUST='' OR CUSTNMBR IN (SELECT LTRIM(item) value FROM dbo.DelimitedSplit8K(@cust,',')))

Worked like a charm

That makes sense. I'll see if I can get that to work.

Thanks

AA

Do you have this line at the top of your sp? That's helped me in the past.

SET NOCOUNT ON;

I have over 30,000 customer IDs. Reading the split, it looks like it can handle 8,000 characters.

I've tried the Draw side by side, but it doesn't do the trick. No matter what I have tried, I always wind up with a Gantt chart, even when...

Impressive. Thanks. It did the trick.

I'll mess with his logic and see if I...

The start date on 6 is before the end date on 5, so it would be continuous.

fahey.jonathan (1/18/2012)

---

Sean Lange (1/18/2012)

---

How can you get a value from an insert that isn't in the inserted table? If you insert it, it is in the inserted table. The inserted...

The Merge and Output worked like a charm.

Thanks

Thanks. Briefly looking at it, I think it might be what I need. I have also been reading about Ident_Current, Scope_Identity and @@Identity. Output is looking like...

A couple of guys that I talked with here mentioned dropping the index as well and then add it back. Maybe one day one of us can take ownership...

This one is not a dedicated SQL server though. What raised my concern is 100% memory being used and nothing was available. Right now with the 6gb max...

I moved it up to 6gb last night after I did some maintenance. That gives me 2gb for the OS and the ERP. I'll just watch it for...