Anyone know how to reoder the columns or remove some from the result set without affecting the column matching, I'm getting 46 columns back from the result.

Thanks

Thanks all for your help!

A friend send me this SQL scripts but I’m not sure which website he got from, anyway it does the job see below -

SELECT...

Hi GSquared,

The reason I wanted it as a stored proc was because other users from different countries (50+ so far) will may need to add/delete columns in the raw text/cvs...

I put this project on the back burner since it was give me nightmares but I can’t put it off any longer. Thanks for your last advice, the execution of...

I’m back again! This forum is fast becoming my most visited website.

I’m receiving an error message when I execute the master stored proc – see script below and...

Thank for a great scrip !!!!!! but I have come back a exhausted man since my understanding of variables in SQL non-existent – so my question is here do I...

Hi C.Hector,

Yes other users will need to EXEC the stored proc, and I don't mind using sql injection with 29 stored proc.

Your help is greatly appreciated!

I have attached 14 of the Kenya texts files out of 28 which need to imported into SQl server but there is another 51 countries with 28 tables with the...

Thanks for getting back to me, the problem I'm having now is that the filename structure below will keep changing through the depending

Projects_Russia_8_01_Country_Prog_V2_0_LFD_Project_Definition_SD

“Country”“Template No. and “LFD_CP_Goals “SD” -These parts of...

Your a great help Grasshopper that exactly what I needed since I don't mind creating 29+ stored procedures.

Is there a way to add an wildcard or variable to the...

Thank you! Exactly what i need.

Will follow the best practises guide for posting questions from on now.:-D