Viewing 15 posts - 4,921 through 4,935 (of 13,877 total)
A general observation: CASE expressions do not 'bring anything in', nor do they 'take anything out'.
If your query works fine without joining to a CTE but results in duplicates...
November 12, 2017 at 6:02 am
Because of user constraints, I cannot follow through with your stored procedures suggestion.
I tried...
November 10, 2017 at 1:57 pm
Thank you for your contribution, but no matter what variation of your code I try,...
November 10, 2017 at 1:42 pm
I have two tables tblData2017 and tblData2018...
November 10, 2017 at 1:21 pm
Sub ClickButton()
Dim SQL As ADODB.Command
Set...
November 10, 2017 at 1:09 pm
leavesandmusic - Friday, November 10, 2017 11:31 AMI would like only one column: for example,Dim arr As Variant
arr = Sheets("Sheet1").Range("E3:E20").Value
Have you...
November 10, 2017 at 11:46 am
November 10, 2017 at 8:26 am
November 10, 2017 at 7:39 am
Naveen J V - Friday, November 10, 2017 3:50 AMPlease do help.
With which part, exactly?
November 10, 2017 at 5:35 am
November 10, 2017 at 5:32 am
November 9, 2017 at 11:22 am
This looks like the best approach to me.
To avoid wasting time updating rows which have not changed, I'd suggest using
...WHEN MATCHED AND NOT EXISTS
(
November 9, 2017 at 11:20 am
November 9, 2017 at 11:08 am
November 9, 2017 at 8:09 am
Grant Fritchey - Thursday, November 9, 2017 6:02 AMForgive us our typos as we forgive those who typo against us.
That was...
November 9, 2017 at 6:13 am
Viewing 15 posts - 4,921 through 4,935 (of 13,877 total)