Viewing 15 posts - 4,486 through 4,500 (of 13,877 total)
Do you have Excel installed on the machine you are trying to run this from?
May 3, 2018 at 2:19 am
Your query just needed aliases.
A fixed version, along with an alternative which may perform better (you should test, of course)
SELECT * FROM #tblContacts c
JOIN...
May 2, 2018 at 12:37 pm
May 1, 2018 at 2:01 pm
May 1, 2018 at 1:42 pm
May 1, 2018 at 1:23 pm
May 1, 2018 at 12:05 pm
May 1, 2018 at 12:02 pm
May 1, 2018 at 11:52 am
As your code contains nothing which deals with the 5/10 dollar increments, I'd say that you were right in your assessment 🙂
Try this CREATE FUNCTION dbo.fn_ck_newBidIsHigher
May 1, 2018 at 7:20 am
Shows how often I create UDFs (they are notoriously bad performers, in case you did not know).
CREATE FUNCTION dbo.fn_ck_newBidIsHigher
(
@auction INT
, @bid NUMERIC(8,...
May 1, 2018 at 6:24 am
Try
If (condition)
Return 1
else
Return 0;
May 1, 2018 at 6:12 am
Please add another screen shot with the Result Set node selected.
Also, are you using an OLEDB or ADO connection?
May 1, 2018 at 5:09 am
Question:
Is there a way for us to have an variable...
April 30, 2018 at 3:23 pm
RE: If so, have you investigated using SSISDB environments to control...
April 30, 2018 at 2:12 pm
Viewing 15 posts - 4,486 through 4,500 (of 13,877 total)