IF TOTAL_BILL_AMT_PROD = NULL THEN NULL ELSE (TOTAL_BILL_AMT - TOTAL_BILL_AMT_PRD = O then 0 Else 1 ) ISNULL(TOTAL_BILL_AMT_PRD) == ""? NULL(DT_STR, 4, 1252) : ((DT_NUMERIC,10,2)TOTAL_BILL_AMT_PRD - DT_NUMERIC,10,2)TOTAL_BILL_AMT == 0...

What does adminstroedproc  do? Or should it be adminstoredproc ?

Is it returning anything? Presumably not, otherwise I would suggest using WITH RESULT SETS, which is the usual way of solving...

Please also try this ... you shouldn't need those casts:

TOTAL_BILL_AMT - TOTAL_BILL_AMT_PRD == 0 ? 0 : 1

What are the data types of TOTAL_BILL_AMT and TOTAL_BILL_AMT_PRD within the data flow?

Also, try removing the quotes throughout the expression – if the 0, 0 and 1 are supposed to...

Is this as part of a data flow? If yes, add a derived column to your data flow and put the calculation in there.

ExecuteSQL tasks do exactly what they say...

• This reply was modified 6 years, 7 months ago by Phil Parkin.

i think you need to execute a script after the dacpac deployment. a dacpac will create tables and objects, but there's no scripting involved, so no, no script can...

• This reply was modified 6 years, 7 months ago by Phil Parkin.

I cannot see how executing a SELECT query in a post-deployment script will achieve anything useful. Where are you expecting the SELECTed data to go?

And I just logged in to respond to your original message! 🙂

How can we resolve this issues without changing any code?

Your options are limited.

Reducing the length of one or more of the underlying table columns is the best idea that comes...

That's how...

I get that error when i run my code against a very large table. Most Prod_IDs have two dashes. I want to pull the value between the dashes.  This...

• This reply was modified 6 years, 7 months ago by Phil Parkin.

SELECT ...

FROM ...

WHERE @SomeTime >= StartTalk AND @SomeTime <= EndTalk

Try this

DROP TABLE IF EXISTS #SomeTable;

CREATE TABLE #SomeTable
(
    Id INT
   ,EventId INT
   ,A VARCHAR(20)
   ,B VARCHAR(20)
  ...

There is an option, but it's well...

Can you briefly explain why this is required?

And if there are three rows of source data, what do you want to see?