Great, thanks so much for you help!

Quick question,

I looked in the msdb database for the role 'sqlagentuserrole' and didn't see it (not sure if I can't see the role due to my rights) even though I...

Hello,

Sweet, this is exactly what I was looking for.

Thanks!

Hi,

Thanks for your response. We're using Enterprise edition. Do you know the steps we need to take to give permission to my login? I want to...

Hi,

The output MUST be in a specific order.

Thanks,

Strick

Hi,

You can use SSIS to do all of this. No need to have views and stored procedures doing this. You'd pull from you source table in SSIS ...

Thanks all,

This is a big help!

Strick

You can also use a data flow task with a source and a SQL Command data flow task. The source gets your data and the SQL Command task will...

Thanks,

I'll try that out. Yeah we're stuck with 2005. I have 2008 at home. I'll play with it just at home to get familiar.

Strick

Found it. There's an extra comma next to EN.State

Thanks all,

Strick

Per request here is the whole query.

SELECT

EL.SUBSCRIBER_ID,

EG.ENROLLEE_ID,

EN.FIRST_NAME MemberFirstName,

EN.LAST_NAME AS MemberLastName,

EN.DOB AS MemberDateofBirth,

EG.FIRST_NAME AS GuardianFirstName,

EG.LAST_NAME AS GuardianFirstName,

(EN.ADDRESS1 + ' ' + EN.CITY + ', ' + EN.STATE, + '...

Hi, Thanks for you response,

If I comment out the address line it works fine so I know it's not the join and/or where selects.

Thanks,

Strick

Hi Guys,

Thanks for your help. Actually the table already had the payee_id. I just needed to put the key on it. I also had to set the...

Hi,

Being an avid developer of both toold (VB.NET and SSIS) I'm one to use the tool that best suits the need. I think that SSIS should be used for...

Hi,

Thanks for your response. Yeah this is what I do to get it working except I just throw values there like this:

EXEC [dbo].[FinancialMembership] 'Test',2009, 0.0

My question is more of...