Matt_V (2/14/2011)

---

Hmmm, interesting idea. I haven't used computed persistant columns much so I'll have to look into that more, however it would my my queries much simplier again.

Quick question,...

Have you looked at the for each object in SSIS? Perform a loop using the file name's pattern to find all the instances, and then do what's necessary to...

I could think of a few ways, such as doing an UNPIVOT on the data, assigning row_numbers partitioning on ID and ordering by the value, but they're no less complex...

WayneS (2/14/2011)

---

Craig Farrell (2/14/2011)

---

Grant Fritchey (2/14/2011)

---

Roy Ernest (2/14/2011)

---

I think you just have to say Yes I want to move and I am sure someone will come and knock on your...

Grant Fritchey (2/14/2011)

---

Roy Ernest (2/14/2011)

---

I think you just have to say Yes I want to move and I am sure someone will come and knock on your door and ask...

At the time of this posting, 18 ppl got it wrong.

I have to wonder, are they simply people who answer (E) to every question on the SAT, 18 people who...

GilaMonster (2/14/2011)

---

$#%$$#%#@#!!!!!!!

Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!

I'm almost at the point of walking away and going to work in a book store for a...

Jeff Moden (2/13/2011)

---

It's funny how well people document when you have managers that tell them it's a part of the job... and then give them time to do it... and...

Jeff Moden (2/13/2011)

---

Now be careful folks. You've both built Triangular Joins which can be literally millions of times worse than a cursor. If you don't want to use...

Try this:

SELECT a.DocNum,Convert(varchar(10),a.DocDate,103)'DocDate',a.cardcode,a.cardname, a.Doctotal,

(Select SUM(Doctotal) from ORCT where a.cardcode='C000732' AND a.DocDate>='2010/04/01' AND a.DocDate<='2011/02/14' and DocNum <=a.DocNum ) AS RunningTotal

FROM ORct a where a.cardcode='C000732' AND a.DocDate>='2010/04/01' AND a.DocDate<='2011/02/14'

GROUP BY a.DocNum ,a.DocDate,...

What Pankush said above is correct.

However, when you do review table hints, you'll always want to throw in a comment about them being done only as a last resort, and...

It's because in this statement:

SELECT a.DocNum,Convert(varchar(10),a.DocDate,103)'DocDate',a.cardcode,a.cardname, a.Doctotal,

(Select SUM(Doctotal) from ORCT where cardcode='C000732'

and DocNum <=a.DocNum ) AS RunningTotal

FROM ORct a where a.cardcode='C000732' AND a.DocDate>='2010/04/01' AND a.DocDate<='2011/02/14

GROUP BY a.DocNum ,a.DocDate, a.Doctotal,a.cardcode,a.cardname

ORDER BY...

I'm not sure what I can add to what Grant said about the tools, however, a few additional things to think of.

One of the things that will help to guide...

What does this query do?

My first instinct is to tell you to look at the waitstate on the proc while it runs slow during the day. Next thing I'd...

Anamika (2/13/2011)

---

On the basis of the value is not null I'm adding those in to where conditions. while doing this i want to find the IDs from a comma separated...