Viewing 15 posts - 796 through 810 (of 1,464 total)
If you add a ROW_NUMBER() it will return in the sort order of the ROW_NUMBER.
Technically, it still has an ORDER BY, but it's not directly on the field.
June 27, 2018 at 11:52 pm
June 26, 2018 at 1:31 pm
June 26, 2018 at 10:28 am
June 22, 2018 at 11:28 pm
June 21, 2018 at 2:05 pm
The following code should get you the desired resultsSELECT TOP 20 .name AS [@name], RTRIM(.value) AS [Value]
FROM xdMOBLateNoticeRunOtherFieldsUPV
FOR XML PATH('Key'), ROOT('OtherFields')
The...
June 21, 2018 at 1:47 pm
June 21, 2018 at 4:52 am
What is the data type of the date column? I would hazard a guess that it is stored as a varchar, and therefor not sorting as expected.
June 20, 2018 at 2:23 pm
June 20, 2018 at 2:20 pm
We have used SYNONYMs for this purpose.
Synonyms (Database Engine)
CREATE SYNONYM (Transact-SQL)
Use 2 identical tables.
Load Table1 and point the synonym at...
June 20, 2018 at 5:00 am
Thanks for the replies, gentlemen. Initially the idea was to store calculations...
June 19, 2018 at 10:55 am
June 19, 2018 at 10:49 am
Try adding this line ..., AvgSeconds = AVG(IncidentStatusDurationFactvw.TotalTimeMeasure) OVER ()
I do not have access to your data, so anything that I post is simply an...
June 18, 2018 at 1:32 pm
June 13, 2018 at 6:08 am
This should get you the desired resultsSELECT
src.ShipperID
, src.InvtID
, src.CONTAINER_NO
, src.ITEM_CODE
, NetWgt = SUM(src.NET_WEIGHT)
June 12, 2018 at 1:46 pm
Viewing 15 posts - 796 through 810 (of 1,464 total)