sorry 🙂 it was more to see of a way to see if i can understand it better if you know what i mean the STUFF syntax confused me, while...

It still comes back as 15122004 which is how it originally is stated. using that convert

the CAST(STUFF(STUFF syntax worked but trying to do it as a convert like if...

Msg 242, Level 16, State 3, Line 34

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

sorry what i meant was previous posts on SSIS were for other projects i've created around expressions - this is a new SSIS project i'm creating.

I'll try the ForEach instead...

Thanks guys, I didn't even think about using a union which was pretty simple idea. I was trying all other stuff.

In terms of my whole process - it...

Update:

I got around the issue by just doing a quick fix, just made 2 seperate scripts one to only be "Private" and one to exclude only "Private" in my...

Thanks for the reply, i did it as a Variable which calls thats expression so worked perfectly.

Sorry i tried to delete it from this thread but didnt know how &...

Thanks for the reply guys, i went with the expression as it was the easiest way to do & also understand.

just made a new variable and passed it all through.

Sean Lange (9/4/2012)

---

Tava (9/3/2012)

---

excellent, I got it working, created the Function & in the subquery now getting the results i wanted... really appreciate your help on this... no way...

excellent, I got it working, created the Function & in the subquery now getting the results i wanted... really appreciate your help on this... no way i would have...

sorry just a little confused. So i have to create the function (as per the script) & once created call it in the way you did to my reply.

1. CREATE...

When using that example it produced an error

IN

(

SELECT ConfiguredValue

FROM

dbo.table1(@CompanyID, ',')

)

Parameters supplied...

double post... removed.

I didnt even know you could do that, you learn something new everyday. I will give this a go and hopefully I pick it all up but at least I'm...

SQLKnowItAll (5/16/2012)

---

I would write a stored procedure to pull the data. I would then call that stored procedure from reporting services to generate a report. Either that, or...