glad to hear you have solved the problem,,,care to share so that others may learn?

for clarification...based on your sample data provided....can you please post your expected results.

thanks

hi...these...

whats the relationship between "Trade" table and "Platoon" table?

http://www.apexsql.com/sql_tools_refactor.aspx

see above link...its free, but requires you to set up your preferences....can be a bit awkward for fine tuning

I prefer Red Gate...but as freelance cant justify the cost

maybe be helpful....and...

as I am sure...

maybe something along these lines will get you started

SELECT

ACCT_ID

, ORD_DT

FROM yourtable

WHERE (DATEPART(q , ORD_DT) = DATEPART(q , GETDATE()))

...

phingers (9/2/2014)

---

Yes, the data will be used to calculate storage charges for pallets based on the number of days the pallets have been in stock. I have a stored...

phingers (9/2/2014)

---

Thanks for all your help guys, I marked Adi Cohn's as the solution because that's what I used in the end, but the other solution does also achieve the...

take a look at the windowing functions in 2012

something along these line may help you get started

SELECT

Month

, Year

, TotalRevenue

, Company

, Descr

, SUM(totalrevenue) OVER (PARTITION BY company ORDER BY...

-- similar solution but with page numbers...may give you some ideas

-- test data

SELECT TOP 1000000

CodeID = 1 + CAST(Rand(Checksum(Newid())) * 100 AS INT)

INTO ...

Hi..how do you propose to determine the latest data for CaseID 542345...you show two rows with same opening date?

your spreadsheet displays an order that cannot be determined without another level...

JackTimber (8/28/2014)

---

Naa re, its a different asignment. I am working by keeping ChrisM solution as a base from previous example, and lets see.

If i come up with a solution would...

JackTimber (8/28/2014)

---

Actaully i was not able to come up with a solution for that problem, so the assignment was given to other guy. I had shown him this thread....

reading the previous thread...it seems that you have 20 million rows....

what solution did you finally decide upon...pls post that here ....and...