Viewing 15 posts - 1,801 through 1,815 (of 5,111 total)
I think the better answer here would be to have 1 table with a column for the action. I note that these tables share the majority of columns, and those...
July 24, 2018 at 4:20 am
July 24, 2018 at 3:37 am
July 24, 2018 at 2:04 am
You can get the status of the last attempted subscription from the database. This is the query I use, which I'm pretty sure I stole parts of from somewhere many...
July 23, 2018 at 9:52 am
July 23, 2018 at 4:12 am
July 23, 2018 at 3:42 am
July 22, 2018 at 1:44 pm
In simple terms, yes. There are 2 connections, A-C and B-C. SSIS doesn't create a connection between A and B, it connects to each and then feeds the data from...
July 22, 2018 at 7:03 am
We're probably going to need the SQL behind "Function1" here, considering it's used to work out the values of columns 11 through to 93.
July 20, 2018 at 10:00 am
July 20, 2018 at 8:02 am
Looks like it will work but i am using SQL Server 2014.
we dont have this...
July 20, 2018 at 6:35 am
Steve, did you have any luck with a response on this?
July 20, 2018 at 3:59 am
That's not really string splitting. Splitting would be something like taking the string "a,b,c,d" and expecting the output:
a
b
c
d
What you want...
July 20, 2018 at 3:47 am
SQL Server is an awful tool for text parsing. There will be tools out there to do so, however, SQL Server is not the right tool for the job.
July 20, 2018 at 3:42 am
Sean Lange - Thursday, July 19, 2018 1:51 PMOH MY!!!!
I think it's more telling that for someone who has been working...
July 20, 2018 at 1:44 am
Viewing 15 posts - 1,801 through 1,815 (of 5,111 total)