Viewing 15 posts - 796 through 810 (of 1,468 total)
I have to write a procedure where I need to capture some data from application...
July 3, 2018 at 5:11 am
June 28, 2018 at 10:14 pm
If only i could, the SQL code is genereted in Java at runtime alas.
Good...
June 28, 2018 at 5:11 am
i'm having trouble separating the total query duration into SQL processing time and...
June 28, 2018 at 4:47 am
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
Viewing 15 posts - 796 through 810 (of 1,468 total)