Viewing 15 posts - 1,756 through 1,770 (of 2,645 total)
This should do it:SELECT V1.F_PRODUCT,
STUFF((SELECT ',' + V2.F_TEXT_CODE
FROM (SELECT V3.F_PRODUCT,
...
January 29, 2019 at 4:33 am
January 29, 2019 at 4:06 am
January 28, 2019 at 1:50 pm
Have you tried adding an order by in the stuff:F_TEXT_CODES = STUFF((SELECT DISTINCT ',' + V2.F_TEXT_CODE FROM FIRST_VIEW V2
WHERE V1.F_PRODUCT = V2.F_PRODUCT ORDER BY colToOrderBy...
January 28, 2019 at 10:35 am
January 28, 2019 at 9:54 am
I think you can use perfmon for this. Just select the statistics you want to track and you can get it to write to a flat file or a database...
January 28, 2019 at 7:42 am
How to take/schedule database backup in SQL Server Express edition (latest version)
Required log backup every...
January 27, 2019 at 1:23 pm
I was wondering how much time was taken going through a 900 line case statement 1 million times.
It would certainly contribute to the runtime of the query.
January 24, 2019 at 7:59 am
January 24, 2019 at 4:34 am
January 24, 2019 at 3:49 am
January 23, 2019 at 2:37 pm
January 23, 2019 at 2:12 pm
You are joining two tables together some how but you haven't shown us the rest of the query.
January 23, 2019 at 2:09 pm
I know, i've tried converting everything to varchar(6) (even the principalid in the underlying table) and...
January 22, 2019 at 12:19 pm
January 22, 2019 at 9:53 am
Viewing 15 posts - 1,756 through 1,770 (of 2,645 total)