You should find the approximate length of your rows that are being stored in @PIVOTSTR to prevent them of overflowing the length. A safe approximate could be 86 (number of...

It really looks like a CROSS TABS problem. Read the articles that Sean mentioned and remember that you can use MAX() for strings.

Would you mind sharing it with the rest?

How do you define that you need 2 or 3 lines?

That's the same link I posted. 111 is the code referenced as Japan's standard which is defined as yyyy/mm/dd. That's not exactly yyyy-mm-dd.

Dutch language uses the format dmy, so that...

How did you get the code 111 for CONVERT? That's completely wrong for YYYY-MM-DD. You could use code 120 or 121, however, that's an ISO stardard format so you shouldn't...

I haven't used it, so I'm not sure that it would work but Application Roles might help.

http://technet.microsoft.com/en-us/library/ms190998.aspx

What do you mean when you say "add date"? you want to add the columns to an SSIS package? to a table? or do you want to add values to...

Note that it won't return complete minutes (or any other period) and will count for the times the period changes.

In the following example both calculations return 1 and that is...

Just because I thought it would be fun to play around to give you an example, here's something I would propose you to try.

Assuming that you have 2 permanent tables...

If I understand correctly, you're loading a file into a table that gets recreated each time. You create the table with the columns from the file and add the other...

Maybe a free reference would be better. 😉

http://www.mssqltips.com/sqlservertip/1675/security-issues-when-using-aliased-users-in-sql-server/

Maybe you could use something like this:

SELECT TotalAmt

FROM (

SELECT TotalAmt

,CAST( ROW_NUMBER() OVER(ORDER BY TotalAmt) AS decimal(8,1)) rn

...

Please post DDL and sample data in a consumable format.

Jeans should be ok, you need to be comfortable but avoid going on your pjs.

You don't need to take a laptop, it's probable that you won't use it at all.