It's not that we can't, it just seems useless if the weeks will always be 52.

This is an example on how to do it.

Note that I changed the code to...

Study, practice, study, practice and keep going even if you get a job.

I met Kendal once in a SQL Saturday at Orlando but couldn't relate him. the description doesn't fit him at all. 😛

Is the order your only problem?

There's no need to read the table trice.

WITH CTE AS(

SELECT ID,

Orderamt,

...

You shouldn't cross post, it will only fragment the responses.

No more answers here, all should refer to: http://www.sqlservercentral.com/Forums/Topic1588259-3412-1.aspx

That's because you're not executing steps 2 and 3.

Step 3 will fail because you only have a condition. I'm not sure what you are trying to do with step 2,...

That's because you're not executing steps 2 and 3.

Step 3 will fail because you only have a condition. I'm not sure what you are trying to do with step 2,...

Have you used TRY...CATCH to handle errors?

Could it be possible that you have that limit established on the "max server memory" configuration options?

SELECT *

FROM master.sys.configurations

WHERE name = 'max server memory (MB)'

There are many things that...

Why do you want to use dynamic SQL?

It's used to review...

The reason behind this problem is that the results grid is not intended to be copied to Excel. For a huge amount of data, you could get out of memory.

You...

Remove the quotes from '@periodname'

declare @period_name as date = 'DEC-10'

SELECT CASE WHEN substring(period_name,5,2) = @periodname THEN SUBSTRING(@periodname ,5,2)

You can't use GO in an EXEC statement for dynamic code.

You could use the SP sp_executesql from the destination database. You could complicate it more and use dynamic code to...