Words cannot express how glad I am I don't have to deal with names like that! =) How about something like this?

SELECT INID, SUM(SumaAkcjiDeponowanych * CASE WHEN TransakcjePapieryWartoscioweTypTransakcji IN...

You basically need to use dynamic SQL to generate the columns for the pivot. Jeff wrote an article on it here:

http://www.sqlservercentral.com/articles/Crosstab/65048/

You are much more likely to get an answer to this if you provide sample data and expected results. The article in my signature explains how to do this...

Thanks for providing your code. However, if you could provide sample data and the results you would like to get (see the link in my signature on how to...

Different databases isn't really an obstacle, you just need to provide the database name as part of the object name. For example, say you have DatabaseA and DatabaseB.

All you...

It looked to me like it would have to rescan the table for each row in the table for that WHERE clause. I may have misread the execution plan,...

Are the number of '\'s always the same either to the right or the left of the data you need?

(NOLOCK) allows dirty reads. Basically, there is a chance that if you are reading data out of the table while it is in the process of being updated, you...

It depends. Can you post some more examples? Also, why did you get rid of the \837\? How did you know to do that? Basically it...

My pleasure. Let us know if you need any help adapting to the new requirements.

That's OK, yours was better. I was just in the car thinking about all the extra ADD's...

Did you get this all figured out Tacy?

How's this coming John? Get it all figured out?

So the 16th of the previous month + 1s?

SELECT DATEADD(s,1,DATEADD(d,15,DATEADD(m,-1,(DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)))))

Not a whole lot prettier, but no varchar conversions and it won't get screwed up in January like yours...

Depending on how many different entities / how long each takes / what kind of downtime you have in the evenings / etc, it might be worth looking into making...