Viewing 15 posts - 811 through 825 (of 26,490 total)
Think dynamic pivot of the delimited values. You will need to determine the maximum number of values in the column being split. Really looks like something for dynamic SQL, but...
October 24, 2018 at 2:22 pm
October 24, 2018 at 2:17 pm
October 24, 2018 at 2:16 pm
ScottPletcher - Wednesday, October 24, 2018 1:51 PMLook for function (ITVF) dbo.DelimitedSplit8K,
And that will help make additional rows, but the OP needs...
October 24, 2018 at 1:57 pm
Okay. I had my annual review yesterday, and it was good. Also had a discussion about changes in the group that I am currently in. The gist of the discussion...
October 24, 2018 at 1:54 pm
October 24, 2018 at 11:20 am
October 24, 2018 at 9:10 am
October 24, 2018 at 8:54 am
October 24, 2018 at 8:41 am
Try this:
update [a]
set [a].[Address1] = .[Address1]
, [a].[Address2] = .[Address2]
, [a].[city] = .[city]
, [a].[stateAbbrev] = .[stateAbbrev]
...
October 24, 2018 at 8:38 am
October 24, 2018 at 8:34 am
October 24, 2018 at 8:18 am
rodjkidd - Wednesday, October 24, 2018 4:52 AMSecond win of the season!
But up against Lynn next!
Now what it is Lynn says...
😀Rodders...
Any given...
October 24, 2018 at 8:13 am
Just remember that cursor code is RBAR (Row By Agonizing Row) and will not scale as well as well written set-base code.
October 23, 2018 at 7:58 pm
October 23, 2018 at 4:52 pm
Viewing 15 posts - 811 through 825 (of 26,490 total)