Viewing 15 posts - 2,071 through 2,085 (of 8,761 total)
June 22, 2017 at 8:20 am
June 22, 2017 at 7:36 am
The query finds the min and max dates, then uses a recursive cte to create a calendar table, adds a rank / grouping to each date, self joins the ranked...
June 22, 2017 at 7:28 am
when I run this :
SELECT collation_name FROM...
June 22, 2017 at 6:56 am
Using the database engine tuning advisor, is the any way to show how much each...
June 22, 2017 at 4:27 am
June 21, 2017 at 8:26 am
June 21, 2017 at 7:13 am
krypto69 - Wednesday, June 21, 2017 6:32 AMDoes anyone know if I can do an inplace update from SQL2014 to SQL2017 Enterprise?
Haven't...
June 21, 2017 at 6:58 am
I have 3200 records in table and want to segregate data as 600 rows...
June 21, 2017 at 5:29 am
This looks like relatively simple XML, you should just use XQuery to parse it
😎
Something like this:SELECT
REPORT.DATA.query('.')
FROM @TXML.nodes('Reports/Report') AS REPORT(DATA)
June 21, 2017 at 3:58 am
Viewing 15 posts - 2,071 through 2,085 (of 8,761 total)