Welsh Corgi (12/1/2016)

---

Luis Cazares (12/1/2016)

---

Welsh Corgi (12/1/2016)

---

ok, I'm sorry for not being clear.

The following article is great but it does it drops off on returning full record set.

https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets

I need to...

Welsh Corgi (12/1/2016)

---

ok, I'm sorry for not being clear.

The following article is great but it does it drops off on returning full record set.

https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets

I need to get the result set...

SteveD SQL (12/1/2016)

---

Hi Luis,

Thanks for responding but similar to John's solution, since this is using the RootRunLogID, it doesn't allow me to filter on other RunLogs 5 thru...

Poe

Is the Med_Rec_Nbr a varchar? If it's an integer or other numeric type, you won't be able to add leading zeros.

Here's an example:

SELECT Nbr,

RIGHT(REPLICATE('0',7)+Nbr,7)

FROM (VALUES('1'),

...

You mean like using a query/stored procedure as source in the Data Flow task?

That's part of SSIS 101.

WebTechie (12/1/2016)

---

I would like to have an app built also.

However, as I mentioned, I am the new guy on the block. Senior guy, but still the new guy.

I don't...

Chocolate

I'd go with the SSIS option because I know how to do it and it's pretty simple. This article might help: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/99287/

Another option, which might be preferred by others is...

You might want something like this?

WITH cte_RunLogandChildren AS

(

-- Anchor

SELECT rl.RunLogID AS RootRunLogID

,rl.RunLogID

...

abhisheka.dalal (11/30/2016)

---

Thanks Kevin ... this worked for me .. i have a function in place to reformat the start date and enddate to a month end date... So i should...

For people that are not native English speakers, it would be easier to understand numbers table instead of tally table.

You could use the lookup transformation. Set the larger table as source and then the filter table in the lookup transformation. Be aware that it will have to load the...

Loved this phrase.

I hope that you're not using strings or integers to store dates.

To achieve this, I'd recommend an inline table-valued function based on a tally (or numbers) table[/url]. With that, the...