Hi Luis,

Not sure how I would do that..

Lowell (3/9/2015)

---

a practitioner could have more than one location; you know, he works at Baptist East, Baptist North and Baptist South, so that would be normal to see the same...

Thanks Lowell and Sergiy.

I assumed the ID values were being forced they were not.

Thanks again guys.

This is close -

http://dba.stackexchange.com/questions/45137/sql-server-agent-jobs-and-availability-groups

Thanks tho!

Thanks wrong column...geez...need some more coffee today

ScottPletcher (2/27/2015)

---

You can also use CROSS APPLY to do that:

select VC.COLUMN_NAME,

case when

ROW_NUMBER () OVER (

partition by C.COLUMN_NAME order by

CHARINDEX(',',VIEW_DEFINITION,CHARINDEX(C.COLUMN_NAME,VIEW_DEFINITION))-

CHARINDEX(VC.COLUMN_NAME,VIEW_DEFINITION)

) = 1

then 1

else 0 end

as lenDiff

,alias

,CHARINDEX(',',VIEW_DEFINITION,CHARINDEX(C.COLUMN_NAME,VIEW_DEFINITION))...

my mistake Grant - I didn't...

I don't think I explained this very well..let me try to do a better job.

A developer came to me yesterday and asked if he can reference the table/column alias he...

Oh okay. Thanks Lynn.

thanks guys!

Thanks Lowell That worked perfectly.

Just curious why must that be converted to varchar?

Hi Phil.

I'd prefer to do it all in SSIS, but it's not a requirement.

Is there a way to do use an external file splitter and call it from SSIS?

Thanks guys.

It may be okay in this instance - because the table is just being used as a dump table and gets truncated every run.

Thanks again everyone for...

Thanks Josh. Much appreciated.

Great.

Thanks so much for all your help Matt.

So do I create a new temp table for every insert?

Do I have this correct? I think I am doing what you said...