Dan, as John mentioned, if you are using a WHILE Loop or CURSOR to iterate through your tables, and assuming your table is a heavy-set, then it is absoultely unavoidable...

Assume all your 3 tables has only one column.

Values in Table RequestForServices:

A1

A2

A3

A4

Values in Table ReferralSourceTypes:

B1

B2

B3

Values in Table SourceOfReferral

A1

A2

So your following query :

SELECT ClientNumber,CaseNumber,ReferralSourceTypes.ReferralSourceType,ReferralSourceTypes.ReferralSourceDesc FROM

RequestForServices,ReferralSourceTypes

will produce a Cartesian Product ...

You're welcome buddy 🙂

~Edit: Wrong code at wrong place :sick:

Sachin, remove the "( )" from your code ;

Sample code:

create table #temp1

(

a int

)

select * From #temp1

alter table #temp1 add b int , c int ;

select * from #temp1

Tim, will your string have only two facility IDs and 2 patient IDs always? Will the format of the string change from row to row..

Please post us sample data...

I sense the OP needs 4 columns out of the string, as in, FirstFacilityID ,FirstPatieintID, SecondFacilityID, SecondPatieintID ; these 4 columns will hold only intergers, stripped from the real string..

My pleasureh helping you, welcome! 🙂

To illustrate what Gail had said , here is a small sample code that will auto-increment a column using IDENTITY column; execute the code in your SQL Express ; follow...

Ok, i get it.. Here is what you wanted (from what i understoood from your above post)

First lets build a temp table to hold some data that looks similar to...

Kavali, the request is quite unclear for me.. can you please put some visual samples of your request and its desired results?

for starters, this might help you!

DECLARE @SUB VARCHAR(2)

SELECT @SUB...

Goodness me, i lost track of this thread and now i saw that this alpha-numbering is a huge swear-word dump-yard.. hmmm,as u said Jeff, it will invite lawsuits.. lets wait...

More than simple and small, that code is highly-efficient for large...

hi there, here is one piece that might interest you! This is **NOT** the optimal solution for the problem, but for now, you can have this. The desired output can...

You're welcome Subhro! 🙂