great question and great discussion 🙂

good tricky question 🙂

can you please some more information what you required as its not clear to us...

Also please post the DDL scripts to create the table and script to insert data into...

You havn't provide much information but I am suggesting you a solution that you can follow to accomplish your task:

you can first import all the username from excel sheet...

this problem is not realted to SQL server so please post this to a relevant forum

the requirment that you have specified is not clear....

can you please provide some more detail information ?

Erland Sommarskog (8/19/2013)

kapil_kk (8/18/2013)

Yes. It is common...

Erland Sommarskog (8/18/2013)

DEALLOCATE implies CLOSE, so CLOSE it's not needed. You need CLOSE if you intend to...

Great formatted post this time 😛

I think this is what you are looking:

select d.drugname, d.packsize,

doc.name, doc.location

from drugs d

left join doctor_prescribed_drugs dpd on d.drugref = dpd.drugref

left join doctor doc on doc.doctorref...

Easy one at start of the week 🙂

Thanks

Creating Linked Server will solve your problem......

Can you please post what exact error you are getting while inserting?

If you want to get rid off loops then you can use TALLY table.

Here is the excellent article by Jeff about Tally table, please read it, it will...

Slight changes in Erland script as cursor was not close in that script :

Here is the modified script:

DECLARE cur CURSOR STATIC LOCAL FOR

SELECT FileName FROM tbl

OPEN cur

FETCH...

Also read the article that Jeff has posted, it an excellent article...

Previously I used to use PIVOT but after reading Jeff's article I start using CROSS TAbS....

Thanks Jeff for that...

Welcome to the SSC 😛

While you post the problems please the DDL statements of Tables, Insert data and desired output so that we can help out you guys quickly.............

Here is...