Hopefully someone will know of system setting or other easier method. 

In case no one else thinks of anything, it seems to me you may have to do a fairly...

I would suggest another approach. 

If I am interpretting this correctly, SQL is interpretting your @Parm variable as a single value.  Hence, the code does not error, but also will...

I do not have Northwind (gotta save that space...), so I plopped your code into Dynamic SQL to see what you produce.  Other than the extra paren, this looks excellent. ...

If you are doing this from an application, I would recommend masking it.  In other words, your application will display an apostrophe [ CHAR(39) ], but you can use the...

Wait a minute.  The code seems to be changing here.  Your original posting had an additional AND at the end, this new positng now contains OR's.  Is there more we...

I don't see any problems with your code.  You "may" not need round, if in fact your data just shows zeros in the decimal places.  But otherwise it looks fine. ...

I am having some difficulty understanding your question.  I think you want the brand new data to have an id range similar to the new data, (as opposed to the...

Export the data, (with headers) to a text file.  I would recommend using something like a pipe | as the delimiter (if text is in the file, comma's might be...

I see two potential reasons behind this, (I have done similar testing in pushing the use of JOINs over WHERE clauses). 

First, the Optimizer will buffer up the plan for...

I think you and I are the same wave length.  UDFs do not always have to be deterministic, but SQL makes that assumption so it does not have to evaluate them...

I am probably way off base, but might the problem be that the UDF OUTPUT is what is causing SQL Server to recognize these as the same column?  The output...

Thanks noeld.  I was trying this with a UNION ALL, but I could not get the syntax down correctly; forgot to allias the UNION

. 

Funny you should mention this today.  I got something from Frank Kalis who get it from someone else; but it is pretty slick.  It is a function which removes characters. ...

You can try this...  I see no relationship between these tables; this is a straight select based on max value from a column. 

SELECT 10 AS 'C10', 20 AS 'C11'...

Very elegant. 

Thanks Frank (I figured someone would have a better approach than my bull dozer method)