Viewing 15 posts - 4,486 through 4,500 (of 13,871 total)
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
This statement is false:
So currently there is a need to upgrade the excel sheets from .xls format to .xlsx format since our target server is 64 bit.
April 30, 2018 at 2:06 pm
Take a look at the picture...
April 30, 2018 at 12:32 pm
In case you have not solved this yet, please try the following:
RIGHT( (DT_WSTR, 15) [PCMRetrievalCode] , LEN ( (DT_WSTR, 15) [PCMRetrievalCode] )- FINDSTRING( (DT_WSTR, 15)[PCMRetrievalCode]...
April 25, 2018 at 12:04 pm
I've built a basic ETL ssis package that drops an Excel file from on network...
April 23, 2018 at 12:52 pm
April 23, 2018 at 11:59 am
So, it turns out that the version of BIDS I'm using doesn't have the...
April 23, 2018 at 10:56 am
Viewing 15 posts - 4,486 through 4,500 (of 13,871 total)