Wouldn't it be easier to use

SELECT COUNT(DISTINCT col2)

FROM [Table A]

WHERE col3 = 196

Or am I missing something obvious?

Would the following help you to get closer to your expected result?

SELECT

row.value('1+count(for $a in . return $a/../*[. << $a])','INT')-2 AS row,

col.value('1+count(for $a in . return $a/../*[. << $a])','INT') AS...

I think the following solution will cover all scenarios:

DECLARE @ProductID INT

DECLARE @Runbalance INT

DECLARE @StockDays INT

DECLARE @RunningBalance INT

UPDATE [dbo].[temp_AVDays]

SET

@runbalance = runbalance...

Absolutely agreed.

And based on...

Sagar Sawant (7/19/2010)

---

Eugene,

I have applied necessary changes in query.

If I removed below code from sql query then query executed in 2 seconds.

,str_SourceID=STUFF(( SELECT ','+ str_SourceOfData FROM tbl_MARC_MemberSourceData MSD,tbl_MARC_SourceMaster SM

WHERE...

Like I stated in my first post: It depends on the requirement.

You cannot use DATEPART() if you need to get the week as per ISO specification.

Furthermore, DATEPART(WEEK,somedate) will return different...

I think the solution I posted will not cover all scenarios (e.g. if the 2nd or 3rd ProductID will have a stock less than the amount received last).

I'll have a...

gah (7/18/2010)

---

????

I'm kinda confused...

The code I provided include the following line:

ELSE ISNULL(@RunningBalance,Current_Stock)...

Hi gah,

GREAT JOB!!!!

As far as I can see, this solution will work.

I would make two changes:

#1: you need to cover the scenario where your stock is less than the amount...

Your c.u.r.s.o.r (*cough*) suffers the same problem David and myself were talking about: there is absolutely no guarantee to get the rows back in the same order as the rows...

Several things:

#1: 2 seconds and 1.36 seconds, respectively, are both below your target of 5 seconds 😀

#2: instead of using a table variable you should use an indexed...

What would be your expected result other than what you already have?

Isn't the result already what you're looking for?

Yes, it's possible.

Have a look at "GROUP BY".

duplicate post.

Discussion alread started here.

@scottichrosaviakosmos

Is there any specific reason for starting a separate thread with an identical subject instead of simply answering the question I asked?

I did...