Post #482882 , just found this post. Same question.

Thanks a bunch, I getting this error now

(2 row(s) affected)

Msg 206, Level 16, State 2, Procedure up_FleetBalance_Control_Reporting_Services_Detailed, Line 0

Operand type clash: tabletype_StationLists is incompatible with varchar

Do I need to change...

Msg 2715, Level 16, State 3, Line 13

Column, parameter, or variable #1: Cannot find data type tabletype_StationLists.

Parameter or variable '@Stations' has an invalid data type.

Msg 1087, Level 16, State 1,...

I was off the radar yesterday, thanks for the help sean , its got most of the way

Chris just tried that, These two columns were identical

COUNT(*) OVER (PARTITION BY v.modelId, v.Type_Fleet) AS TotalModelsInFleet,

COUNT(*) OVER (PARTITION BY v.modelId) AS TotalModels

Thanks for your help

Thanks Chris, I think I need to explain myself a little bit better,

RepairSheetNr unitnr groupid brandId modelId version Type_Fleet close_date TotalModels TotalModelsInFleet

5000076 51 EDMN PEUGEOT 207 S 1.4 8V...

CREATE TABLE #Temp (RepairSheetNr int, unitnr int, groupid char(4), brandId varchar(40), modelId varchar(40), version varchar(40), Type_Fleet char(10), close_date DATETIME, TotalModels INT)

INSERT INTO #Temp

SELECT '5000023', '83', 'EDMN', 'FIAT', 'GRANDE PUNTO...

"What do you see if you order the results by Vehicle.modelId? Do you get multiple rows per model? That's what I'm looking for."

Yes when I order them by Vehicle.modelId I...

I am getting over 500 single results, heres some sample data to work with

CREATE TABLE #Temp (RepairSheetNr int, unitnr int, groupid char(4), brandId varchar(40), modelId varchar(40), version varchar(40), Type_Fleet char(10),...

RepairSheetNrunitnrgroupidbrandIdmodelIdversionType_Fleetclose_dateTotalModels

500000384EDMNFIATGRANDE PUNTO 1.28V DYNAMIC 5DROF 2012-07-31 00:00:00.0001

Sorry the query ran fine, it just returned the exact same result set as the query...

Didn't work just pulled back the same result set, I need the query to be able to search the vehicle table for all the modelid on the fleet at that...

Cheers andy, that worked a treat. learning all the time. Thanks.

Thanks so far, I will clarify further. The requirement is that i update the version field with the letters 'BT' at the end, So if the column is defined as...

--The problem with your code Luiz is that it is calculating the two periods together, but the date_block (20120406) is between the second period, so I need a way of...

sorry posted on wrong thread. with previous post