What you're looking for here is a Calendar/Tally table[/url].

Yes., There's a few different ways, for example:

SELECT GETDATE() AS CurrentDateTime,

(DATEPART(HOUR, GETDATE()) * 10000) + (DATEPART(MINUTE, GETDATE()) * 100) + DATEPART(SECOND, GETDATE()) AS...

How is your HTML being generated? I assume that it is not a dataset, which means that SSRS will see your HTML string as one item, not 4. I wouldn't...

Chris Harshman (10/27/2016)

---

I agree that FORMAT is terrible for performance, but since the desired end result is INT for all these ID columns, why not just change them all to...

I really wish it wasn't. It's a lazy man's dream. :hehe:

One thing I've been told here, repeatedly(cause i keep using it), is that FORMAT (T-SQL) is awfully slow, which I agree it is; I'm just lazy.

On a silly dev PC...

Welcome to SQL Server Central. When posting, it's always helpful to provide DDL's and INSERT statement for your tables and data, rather than a copy and paste. Have a look...

Not your SQL logs, your event logs. This'll give better information.

When posting, you should really provide the INSERT statements, as a copy paste of data can be awful to read. I've done this for you:

CREATE TABLE #Primary (DealNumber INT,

...

You probably could do this in SSIS using WMI tasks (WMI Event Watcher). You can set the task to wait for a file creation, and then once it has been...

Instead of using variables in the child package, use parameters. You can then pass the variables within the parent package as parameters to the child.

dramaqueen (10/25/2016)

---

I managed to solve it.

SELECT O.ow_id

FROM props.dp_owner O

JOIN props.dp_entry E

...

Does day 1 always have a default value? is so LEAD has the option of providing this, as the format is [expression], [offset], [default value].

So for example you could have:

--Assumes...

it's always best to give some more data that your query, it's very hard to do anything without data (see the link in my signature for how to post).

I've gone...

If my understanding is correct, and you're always after the next tick value, have you considered using LEAD (T-SQL), rather than doing a self join?