Well, maybe you should ask somewhere else - this is SQL Server Central, I'm not sure if anybody will be able to help you... and surely not if you don't describe...

To sum it up very briefly - both is allowed, SET is recommended and SELECT is more efficient and more flexible :-).

I mostly use SET only when setting fixed value of...

I think the reason could be somewhere in the settings (your PC could have other settings than her PC)... did you try to ask her to run the same query...

Hello,

I still think it should be possible to do it without dynamic SQL, but have no other ideas than those already presented... However, if dynamic SQL will be your solution,...

Wanderer,

as I understood Larry, this is not a permanent removal - it is used just to create a search pattern or matchcode or whatever you want to call it. In...

Ian has explained almost everything there is to explain... just a few details: The "n" varieties are useful only if you plan to use some special chinese or japanese character...

Well, if it's just removing certain characters, I would recommend using REPLACE - this will work without cursor. You can nest several REPLACEs, which makes it a lot easier.

SELECT REPLACE(BusNm,...

Wouldn't it be better to store all items (main and substitute) in one table and define the substitution using a substitution table with columns MainItem, SubstituteItem? If any item can...

If it is just a one-time issue and you have no experience with DTS, you can import the data into SQL table as they are and concatenate after. If you'll be doing...

I have to say that I don't understand the question... what does it mean, 2 foreign keys on one column? Is it like you want to have a FK column...

Hi Farrell,

the error is caused by SUBSTRING( '13071961', 2, 2) , which should be SUBSTRING( '13071961', 3, 2) . Just a typo, I guess, because you have it right in...

Hi,

I tested rhunt's SQL and it does precisely what you need - as far as I can tell. I thought there was a typing error in it (superfluous FROM on the first...

That's not a problem, just add them to the inner query (aliased Q) and then select all you need from Q. If you have any problems, please post the whole...

I don't know how you wish to calculate percentage, but you can easily change the formula so that it suits your needs. And I suppose there are some columns from the...

Hm... since you didn't provide any info about your query, it is rather complicated to find a solution. What about this (sorry for the pseudo-SQL, but you didn't supply anything...