Viewing 15 posts - 1,396 through 1,410 (of 8,731 total)
Eric M Russell - Friday, April 7, 2017 12:19 PMI wonder what is the oldest post on SQLServerCentral?
This is the oldest I...
April 7, 2017 at 12:31 pm
f.keler 18216 - Thursday, April 6, 2017 7:20 AMCool thanks! Don't understand the logic behind it but I'll give it a try 😉
Be...
April 6, 2017 at 7:37 am
As personal experience, I would suggest that you avoid loading data into Oracle using SSIS. Even with specialized drivers as Attunity, the load will be a lot slower than using...
April 6, 2017 at 7:21 am
Take a look at this article: http://www.sqlservercentral.com/articles/T-SQL/68467/
If you're able to work with 2012 or something more recent, you would just need an OVER() clause.
April 6, 2017 at 7:09 am
April 6, 2017 at 6:58 am
Would something like this help?
SELECT DISTINCT
CASE WHEN ClientRef <= LinkedClientRef THEN ClientRef ELSE LinkedClientRef END AS ClientRef,
CASE WHEN ClientRef <= LinkedClientRef THEN...
April 5, 2017 at 10:59 am
This article solves a similar problem: http://www.sqlservercentral.com/articles/T-SQL/103343/
However, if you need values in separate columns, here's an option.
declare @a table(
begindate varchar(50),
April 5, 2017 at 9:53 am
April 5, 2017 at 9:11 am
WayneS - Tuesday, April 4, 2017 11:37 AM
Congratulatios! I'm surprised you weren't an MVP already.
April 5, 2017 at 8:27 am
Failed to create the store procedure with 2 input parameters for the below logic....
April 5, 2017 at 6:33 am
April 4, 2017 at 9:36 am
April 4, 2017 at 8:47 am
April 4, 2017 at 8:43 am
Viewing 15 posts - 1,396 through 1,410 (of 8,731 total)