You're looking at using a LEFT OUTER JOIN read up on themhere http://msdn.microsoft.com/en-gb/library/ms187518(v=sql.105).aspx

I would suspect that there's some sort of internal algorithm used to select the best sort algorithm for a given data set, based on the data type, data volumes etc

You are missing the quotes round the value on the name = CFGMGR.

select *

from sys.databases

where name = 'CFGMGR'

Thanks for the feedback, I was glad to help.

This should work especially if you're not bothered about the order of the insert for Table 1

INSERT INTO @test1(C_NAME, C_CODE)

(SELECT P_NAME,

C_CODE = 'CL' + CONVERT(VARCHAR(5),@x+ROW_NUMBER() OVER...

Sorry my misunderstanding about the columns.

No problem, Its what ever is best for your environment and organisation.

The problem with the table is that you stated it was for a dynamic, number of columns so...

When you build the column list you could build them with an alias in using a ROW_NUMBER() over (ORDER BY).

Create Table #TDP_AP

(

periodo varchar(10)

)

Insert into #TDP_AP

Values('201201')

,('201202')

,('201203')

DECLARE @columnsVEN_AP_REP_Alias varchar(max)

SET @columnsVEN_AP_REP_Alias

=...

The problem is that you are using

Select

Table1.*

,Table2.*

From

Table1

...

You might actually benefit from setting up a calendar table with a Column indicating the Start of the week, and once set up it should also enable you to quickly...

I'm not sure what you are trying to do here.

The problem that you have is that on the first two rows you indicate for a required data set, the data...

As everyone else has said they wouldn't have hired you if they didn't think you were up to the job.

as it is if they have as many servers as you...

At the moment you have it written like an IF Statement

CASE

WHEN conditional_a = conditional_b THEN something

ELSE conditional_a = conditional_c THEN something_else

...

This is called a cross Tab.

The simplest method is

SELECT

CourseId

,SUM(CASE WHEN ScheduleTerms = 'Q1' THEN 1 ELSE NULL END) [Q1]

...

If you go to this link http://www.sqlservercentral.com/articles/71564/ there's a link to a free book about how the query optimizer works, its not a deep dive, but goes into the basics...