You could as well use MAX and Group by... it should work 🙂

SELECT ID,MAX(COUNTER) COUNTER, DATA FROM TABLE

WHERE daterange between date1 and date2

GROUP BY ID,DATA

Modified Smash125's code a bit so that the order is sequential and eliminated the use of case in CTE.

WITH C AS(

select

year(OrderDate) AS OrderYear,

MonthForTheYear= DateName(month,DateAdd(month,Month(OrderDate),0)-1),

Quarter = CASE WHEN MONTH(OrderDate) BETWEEN 1...

You could probably call sqlpubwiz with xp_cmdshell (in a stored proc) and run it as a scheduled job..

for more info check this site out...

http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/