You can use MAX to make this work:

SELECT t.ID
      ,MAX(t.LegalName)
      ,MAX(t.City)
      ,MAX(t.Zip)
FROM...

Assuming Cost = 500, FeeMargin = 10% and NettMargin = 5%

Sell - Cost - (Sell * FeeMargin) / Cost = NettMargin

Sell -500 - (Sell * 0.10) / 500 =...

Phil

I am struggling to explain this, hence  a valid result in the table.

I need to calculate the sell price by changing the nettmargin

The cost and FeeMargin will persist. The...

Your TEST table appears to include all of the items which you are trying to calculate, making this a little difficult to fathom.

What are the inputs to the problem and...

Too busy trying to cool down their server CPUs after all those wildcard searches, no doubt.

Here's the same example using a...

• This reply was modified 5 years, 3 months ago by Phil Parkin.

Here is another possibility, which separately adds the hours and minutes to the starting date:

DECLARE @d DATETIME = '20201120';
DECLARE @i SMALLINT = 725;

SELECT @d
,   ...

Is the package deployed to SSISDB? Did you use the project or package deployment model? Do you use project parameters or connections?

Thanks, Sue

I tracked down the only version of RegSvr.XML I could find on my machine and it does not appear to hold the same list of registered servers which I...

And where are you expecting the messagebox to be displayed?

Change your simple script such that it does not require any sort of UI interaction and you should find that it...

You would probably do something like this:

DECLARE @LatestExpiredDate DATETIME = DATEADD(d,-1,GETDATE())

SELECT * FROM Book_Reservation br
WHERE @LatestExpiredDate >= br.reservation_To_date

This sets a temporary variable to the date/time of 'now'...

• This reply was modified 5 years, 3 months ago by Phil Parkin.

I appreciate that you are dealing with sensitive data, but are you able to put together some example data – which could be completely nonsensical – along with desired results?...

Are you saying that the column you are searching may contain two numbers (eg, '123|456') or that the user may enter two numbers and you want to search for both...

What is your question?