Phil Parkin

Forum Replies Created

Viewing 15 posts - 3,811 through 3,825 (of 13,877 total)

RE: Sort comma separated value in SQL Table

PSB - Tuesday, December 4, 2018 10:38 AM
All right, I have changed the compatibility level to 140 for my database .
I...

December 4, 2018 at 11:08 am

#2015484
RE: Sort comma separated value in SQL Table

PSB - Tuesday, December 4, 2018 10:32 AM
If I change it to 140, will there be any implications ?
Thanks,
PSB
Of course. It will...

December 4, 2018 at 10:36 am

#2015480
RE: Sort comma separated value in SQL Table

PSB - Tuesday, December 4, 2018 10:14 AM
. Set at 110
So now you understand the problem, I presume?

December 4, 2018 at 10:20 am

#2015475
RE: Sort comma separated value in SQL Table

PSB - Tuesday, December 4, 2018 10:10 AM
What is the compatibility level of the database you are working in?

December 4, 2018 at 10:13 am

#2015471
RE: Sort comma separated value in SQL Table

Bert-701015 - Tuesday, December 4, 2018 9:04 AM
Phil Parkin - Tuesday, December 4, 2018 8:56 AM

December 4, 2018 at 9:09 am

#2015454
RE: Sort comma separated value in SQL Table

The problem with these solutions (mine included) is that they don't work :blush: At least not on my instance.
The CTE produces the correctly ordered resultset.
STRING_AGG then appears to...

December 4, 2018 at 8:56 am

#2015450
RE: Sort comma separated value in SQL Table

Thom A - Tuesday, December 4, 2018 6:47 AM
Have a look at delimitedsplit8k_lead and FOR XML PATH. Have a go, and if...

December 4, 2018 at 7:44 am

#2015439
RE: Holiday Calender. Second Table has calculated column which add days which are not in weekends and not in holidays

awzali - Monday, December 3, 2018 11:41 AM
Hello Gentlemen
Your kind support in below
Table 1 named Calendar
Table 2 DataBT.
Calendar table in holiday calendar...

December 3, 2018 at 11:45 am

#2015352
RE: Update Row for same ID

Something like this?
UPDATE wrong
SET names = correct.names
FROM
   #exceptions wrong
JOIN #exceptions correct ON wrong.Id = correct.id
WHERE
   wrong.Names   = 'Generic'
   AND correct.Names...

December 3, 2018 at 7:05 am

#2015299
RE: Pseudo code help

Jonathan AC Roberts - Sunday, December 2, 2018 10:42 AM
Using your proposed algorithm you won't necessarily find the minimum number of recipes...

December 2, 2018 at 11:00 am

#2015243
RE: Pseudo code help

IMTM2 - Saturday, December 1, 2018 2:32 PM
Need a little guidance regarding a personal project. I don't want any actual code, just...

December 2, 2018 at 10:06 am

#2015239
RE: Writing to multiple XL spreadsheets of the same workbook within same workbook

VoldemarG - Saturday, December 1, 2018 11:06 AM
DO you think it is better to start doing it via a SCRIPT task right...

December 1, 2018 at 1:22 pm

#2015215
RE: Writing to multiple XL spreadsheets of the same workbook within same workbook

VoldemarG - Friday, November 30, 2018 8:09 AM
and if i use 2 OLEDB sources and 2 XL destinations in same Data Flow,...

November 30, 2018 at 8:13 am

#2015127
RE: Writing to multiple XL spreadsheets of the same workbook within same workbook

Thom A - Friday, November 30, 2018 7:54 AM
Phil Parkin - Friday, November 30, 2018 7:40 AM

November 30, 2018 at 8:09 am

#2015125
RE: Writing to multiple XL spreadsheets of the same workbook within same workbook

Thom A - Friday, November 30, 2018 7:31 AM
Phil Parkin - Friday, November 30, 2018 7:19 AM

November 30, 2018 at 7:40 am

#2015115

Viewing 15 posts - 3,811 through 3,825 (of 13,877 total)