To be a little more specific:

to find the max sname is like searching for the largest ASCII value of the first position of sname, continues moving to the right for...

Slightly off topic:

would you mind stop qualifying your requests as "very urgent" or "urgent"? (Seems like it became a habit...)

If you ar requested to migrate a db from SS2K to...

I'm not sure if SSIS would allow it:

I would store the output from the string parser into a separate table (temp table or table variable), do a direct join in...

You might want to search for "XML Workshop" on this site.

It will give you a series of artivles by Jacob Sebastian covering usage of XML in SQL server (both directions:...

The bold font you mentioned didn't show up.

Please show us your expected result together with what you've tried so far.

Would you mind showing us what you've done so far and where you got stuck?

This one actually does look like it can be included without a function.

Regarding the other ones: I still don't know.

If you need to do a different handling the CASE...

Would you mind sharing the code for the function etl.fn_Lookup_SK_OrganizationKey_Costcenter_Admunit as well?

Maybe it's possible to change it into a normal join...

Now you know why I didn't want to show my function... :crying:

The varchar(max) discussion is an ongoing subject on various threads from time to time but I didn't think a...

Your very welcome.

Did you notice how fast you got an answer once you provided ready to use sample data?

And no, I cannot say "I know SQL". I know just enough...

The "trick" is to concatenate the two columns Price and Money and treat it as one column inside the PIVOT statement:

SELECT ProductName, [NewYork] , [Berlin], [Moscow], [Zurich]

FROM

(SELECT

ProductName,

SalesPointName,

CAST (Price...

Obviously, I've been wrong in guessing your table structure then...

Before I give it a second try I kindly ask you to provide sample data in a ready to use...

[SET VENTING ON]

A vendor I've been forced to deal with late in a project used NHibernate to connect to a database he designed (for us).

When facing major performance issues I've...

I don't want to sound offending but there still might be something wrong with the sp.

The way you describe it it sounds like you're using a cursor which might be...

It looks like you have duplicate values for [CompanyNumber_PK] in your table.

You can check for duplicates with the following code:

SELECT CompanyNumber_PK

FROM YourStagingTable

GROUP BY CompanyNumber_PK

HAVING COUNT(*) > 1

Second question: why do...