February 9, 2016 at 9:13 am
This is my table
t_mcnot_citgt_trdt t_shft t_wght(No column name)
F01 1010052016-01-12 00:00:00.0004 0.000.00
F01 1010052016-01-12 00:00:00.0003 0.000.00
F01 1010052016-01-12 00:00:00.0002 0.000.00
F01 1010052016-01-12 00:00:00.0001 0.000.00
F01 1010052016-01-11 00:00:00.0004 17.9617.96
F01 1010052016-01-11 00:00:00.0003 0.000.00
F01 1010052016-01-11 00:00:00.0002 0.000.00
F01 1010052016-01-11 00:00:00.0001 0.000.00
I am expecting below result order by shift as well.
t_mcnot_citgt_trdt t_shft t_wght(No column name)
F01 1010052016-01-12 00:00:00.0004 0.0017.96
F01 1010052016-01-12 00:00:00.0003 0.0017.96
F01 1010052016-01-12 00:00:00.0002 0.0017.96
F01 1010052016-01-12 00:00:00.0001 0.0017.96
F01 1010052016-01-11 00:00:00.0004 17.9617.96
F01 1010052016-01-11 00:00:00.0003 0.000.00
F01 1010052016-01-11 00:00:00.0002 0.000.00
F01 1010052016-01-11 00:00:00.0001 0.000.00
February 9, 2016 at 2:09 pm
Your question is unclear to me. This is a good place to start: http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
-- Gianluca Sartori
February 9, 2016 at 2:16 pm
Also of note, this seems to be the exact same problem that has been worked on in another thread, starting here: http://www.sqlservercentral.com/Forums/Topic1759368-3412-2.aspx#bm1759448
Cheers!
February 9, 2016 at 2:24 pm
Yes.. I got it. I wasn't get answer clear at that time on that threat.
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply