Viewing 15 posts - 5,551 through 5,565 (of 13,877 total)
Min(isnull(AMT,0)) should get rid of the warning.
June 12, 2017 at 8:53 am
As the available answers are 25, 50 and 60, it's one third.
If the answer is 25% (one possibility) the probability is 0.5.
If it's not 25% (two possibilities)...
June 12, 2017 at 6:27 am
June 11, 2017 at 9:50 am
June 9, 2017 at 12:36 pm
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
Viewing 15 posts - 5,551 through 5,565 (of 13,877 total)