Hi any pointers to official / supporting docs re. the point...

Gina

in the examples you give code/spreadsheet can you please clarify what pre exists as data and what you are calculating.

sorry for being thick 😛

Hi Gina

just back from work...so sorry for delay.

I must admit that I am struggling to understand your reqs.

there are rows for exactly same date/time/lotid...with a qualifying column of lotidbalseq...have you...

ben.brugman (4/16/2013)

---

J Livingston SQL (4/16/2013)

---

Hi...at the moment I am not at all clear what the "data" is ...it lives on SQL...but how did it get there and what is it...

deleted

VegasL (4/21/2013)

---

Hello,

I am trying to combine multiple tables, and then show only when value [Qry] when it is greater than 1 after combining the tables, below is what i wrote...

jkury (4/20/2013)

---

I have a table that has some result that scan over a period of several days. I want to display a value who's count is the largest over...

gcresse (4/20/2013)

---

Perfect! That's exactly the answer I was looking for. I tried all sorts of SUM OVER PARTITION BY combinations with no luck, but I see the PARTITION...

is the following any where near what you are looking for?

note...rounding issues...used for simplicity

SELECT PudID

, TranDate

...

one way to consider

SELECT

A.Empid,

ISNULL(B.WeekoffChangeDate, A.WeekoffDate) AS ActualWeekOffDate

FROM Table_A AS A

LEFT OUTER JOIN Table_B AS B ON A.WeekoffDate = B.WeekoffDate

AND A.Empid =...

SELECTPudID,

TranDate,

TranQty,

RunBal,

PudIDPct,

LotID,

PudIDLotBal,

LotIDBalSeq,

'help?'PudIDAsOfBal

may be I am being particulalary thick this morning but I cant seem to follow your spreadsheet for "Runbal" and "PudIDLotBal"....are these columns in your database table that are already...

what exactly are you struggling with...??

care to share what code you so far?

an idea to get you started

SELECT COUNT(MRN) AS visits,

DATEPART(MONTH, ApptDt2) AS monthno,

DATEADD(day, 6 - DATEDIFF(day, 6, ApptDt2) % 7, ApptDt2) AS...

rs80 (4/16/2013)

---

You were right. The datasets were referred incorrectly.

In the merge join transformation, when I do an inner join I only get 1 record back. However, when I...

NineIron (4/16/2013)

---

I am trying to get a count of visits by week with the week ending on Saturday. My problem is getting the count to start on the first day...