Viewing 15 posts - 5,551 through 5,565 (of 13,874 total)
June 9, 2017 at 10:57 am
Thanks for your Input. I will try that Statement tomorrow if i am...
June 9, 2017 at 10:43 am
DECLARE @x VARCHAR(15) = '(SS)(DD)(GG)';
SELECT
col1 = SUBSTRING(@x, 2, 2)
, col2 = SUBSTRING(@x, 6, 2)
, col3 = SUBSTRING(@x, 10, 2);
June 9, 2017 at 9:40 am
June 9, 2017 at 9:38 am
If that's the best identifier you have, then I would expect your query to look more like thisMERGE dbo.dreamlines_sails t
USING
(
(SELECT
nid
...
June 9, 2017 at 9:36 am
First of all, here's that query again, for those of us with screens less than 3m wide 🙂MERGE dbo.dreamlines_sails t
USING
(
(SELECT
nid
...
June 9, 2017 at 8:30 am
June 8, 2017 at 12:26 pm
I'm having some problems with a stored procedure which is called every hour...
June 8, 2017 at 9:20 am
June 8, 2017 at 8:35 am
This is a tough requirement, I sympathise.
MERGE JOIN in SSIS is not something I would recommend for such high volumes.
Maybe you could split this into two parts:...
June 8, 2017 at 6:48 am
coool_sweet - Wednesday, June 7, 2017 2:22 PMsorry I m using execute process task but how can I get .gz extension here
I'll...
June 7, 2017 at 3:11 pm
i am using execute sql task to zip my files to .gz extension.
but getting error...
June 7, 2017 at 2:14 pm
It seems that many others have experienced similar issues. One method which appears to have worked for some is using an ODBC connection rather than ADO.NET. Is this a possibility...
June 7, 2017 at 1:10 pm
Anyone in the mood for talking about RAM requirements while remaining tight-lipped about the use of NOLOCK? Here you go.
May 22, 2017 at 6:00 pm
It does sound as if locale might be the issue (DMY vs MDY).
Just to be clear, please confirm the following:
a) The source is a spreadsheet with a date...
May 22, 2017 at 1:42 pm
Viewing 15 posts - 5,551 through 5,565 (of 13,874 total)