Solomon Rutzky (8/30/2016)

---

. In order to help see this, I modified one of your examples to show that the "float" value multiplied by the "term" isn't the original "amount" that...

You better hope they do.

Why - see below.

DECLARE @Amount MONEY, @Term INT

DECLARE @fRate float, @dRate...

Here...

If there would be the same identity generated an error would happen on insert to SESSION table.

Because of a primary or unique key on the IDENTITY column in table SESSION....

pstanislav (8/26/2016)

---

I agree with the comments here - the code as written will produce variable results as the separate GETDATE functions are evaluated. This can be avoided by getting...

That's pretty simple.

During reindexing the log grows until it runs out of free space on the disk.

Then it fails and stops.

The backup job comes couple of hours later, cleans up...

Just do what's requested:

STUFF('1000000017777', 1,1,'')

CONVERT(int, STUFF('1000000017777',...

To make it really painful:

DECLARE @Amount MONEY, @Term INT

DECLARE @fRate float, @dRate decimal (38,28)

SELECT @Amount = 1000000, @Term = 17*3*13*7*19*23*43*11

SELECT @fRate = CONVERT(FLOAT, @Amount)/@Term,

@dRate = CONVERT(DECIMAL(38,28), @Amount)/@Term

SELECT @fRate [@fRate], @fRate...

It took 2 minutes:

DECLARE @Amount MONEY, @Term INT

DECLARE @fRate float, @dRate decimal (38,10)

SELECT @Amount = 1000000, @Term =...

What do you want to work on?

You've been given the solution.

All you need to do is to translate it into SQL.

1. "...

Jeff Moden (8/29/2016)

---

I hope you're not using the FLOAT version. FLOAT is a binary "approximation" of numbers and it the scale varies according to how many...

Assuming the order of rows is defined by auto-incremental...

Here is what solves your problem.

SELECT h.Date

FROM dbo.Holidays h

WHERE Territory = @Territory

AND Level = @Level

AND Date >= DATEADD(YY, DATEDIFF(YY, 0,...

ChrisM@Work (8/25/2016)

---

Of course not. The function calculates US holidays because most users of ssc are in or from the US. I'm in the UK and I've written a similar function...

ChrisM@Work (8/24/2016)

---

paulo.margarido (8/24/2016)

---

i'm aware of what "inline table-valued functions" are, i have a few of my own in the DB

what i ask is how can i do it that way

if...