Viewing 15 posts - 796 through 810 (of 1,469 total)
Thank you Des. So if we use SUSER_NAME() then user logged into...
July 3, 2018 at 5:37 am
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
Viewing 15 posts - 796 through 810 (of 1,469 total)