Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: jayesh222705
- Order by date
-
Calculate MonthlyVolume - PIVOT SQL
I tried something like this but it's not working the way I want. declare @Temp1 table ( RowID int, Serial_Num varchar(3), ReadingDate datetime, M_Counter int, Dyn_Counter int ) insert into @Temp1 select ROW_NUMBER() over (order by Serial_Num, ReadingDate), * from MyTable T select...- jayesh222705
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Calculate MonthlyVolume - PIVOT SQL
After processing data I just found today that there are some cases when prior month's reading is not there!! In that case sql should go back previous month to get the reading and do calculation. I will put this in store procedure and Calculation needed for last 4 months only (CurrentMonth + 3...- jayesh222705
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Calculate MonthlyVolume - PIVOT SQL
It will always have only one reading for each month and no missing months....- jayesh222705
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Calculate MonthlyVolume - PIVOT SQL
I am using SQL server 2008 and I have following Table with millions of rows...Here are few sample records Serial_Num ReadingDate M_Counter Dyn_Counter XYZ 3/15/2014 100 190 XYZ 4/18/2014 140 240 XYZ 5/18/2014 200 380...- jayesh222705
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
