Now we fall into the troubleshooting steps of why it cannot connect.

Server up and running?

Correct server name listed in the -S switch?

Can connect via SSMS to the server?

Server set to...

what error do you get?

Can register from the Prometric site, there are two options for MCM when I log in selecting the UK as my country,

Microsoft Certified Master Programs (088)

Microsoft Certified Master Program...

Setup a windows scheduled task which executes a batch file that contains the nessesary SQLCMD switches and pass in the command in a SQL file via the -i switch.

http://msdn.microsoft.com/en-us/library/ms162773.aspx

You need to select it from the lab section of the MCM its not in the theory list.

I would seriously recommend getting them to unblock the site then as there is just to much information on that site to copy and paste into the forum

Would have to do something like the following due to the way that CHAR stuffs the white space with a space

declare @i char(8) = '1'

select right('0000000'+REPLACE(@i,' ',''),8)

Use Ola's index maintenance scripts, give you a lot more control than the standard MP's do.

Link can be found in my signature.

Then I suggest you build a table which houses all the different probabilities

You need to do a condition where Date >= FromDate and Date <= ToDate

DECLARE @Table TABLE (FromDate DATETIME, ToDate DATETIME, ResultDate DATETIME)

INSERT INTO @Table VALUES

('2012-01-01','2012-03-31','2011-12-31'),

('2012-04-01','2012-06-30','2012-03-31'),

('2012-07-01','2012-09-30','2012-06-30'),

('2012-10-01','2012-12-31','2012-09-30')

SELECT

ResultDate

FROM

@Table

WHERE

GETDATE() >= FromDate

AND

GETDATE() <= ToDate

Please can you follow the second link in my signature on posting code and data so that we can help you with a query.

The alias needs to be created on the clients.

Please do not cross post, replies here please http://www.sqlservercentral.com/Forums/Topic1381095-17-1.aspx

Check out the Microsoft learning pages for the exams, they have the official recommended training materials advertised for each exam which do not infringe on the NDA.

Also you cannot have spaces in element names, <Data Extract> needs to be <DataExtract>

DECLARE @SQL NVARCHAR(MAX) = '<DataExtract><Graduates><Candidate><FirstName>Shaun</FirstName><LastName>Slabber</LastName></Candidate><Candidate><FirstName>paul</FirstName><LastName>devine</LastName></Candidate></Graduates><ExperiencedHires><Candidate><FirstName>paul</FirstName><LastName>devine</LastName></Candidate><Candidate><FirstName>Meera</FirstName><LastName>Bhana</LastName></Candidate></ExperiencedHires></DataExtract>'

select @SQL

select CAST(@sql as xml)