Thanks! Me too some more £££'s would be nice!

Hi,

So i've just got back into work having passed 70-463! It was an interesting exam with a good mix of questions accross all the topics, some easy, some not so...

Hi,

Turns out I've answered my own question thanks to this thread: http://stackoverflow.com/questions/12526795/print-an-ssrs-report-multiple-times-based-on-a-value-entered

I've used a matrix with a dataset called AccountManager then used a sub report within the matrix to run...

Congrats! I personally found 461 easier than 462. I've got 463 on Friday... gonna take a study break for a while after that!

Cool, glad it's helped. Post back if you have any problems.

Thanks,

Simon

Or.... here's a really simple example but should get you going....

/* Set up a table variable to hold the XML*/

DECLARE @table TABLE

(

RiskXML XML

)

/* Insert some very simple XML */

INSERT INTO...

Hi,

If you look at the details of this post it may help you. If I understand what you want....

http://www.sqlservercentral.com/Forums/Topic1438775-3077-1.aspx

Thanks,

Simon

Hi,

Here's a screenshot illustrating what i mean....

Thanks,

Simon

If you look at the properties of the report body there is a language property. Just change that to en-GB and that should do the trick. Let me know if...

SQL Server books online is essentially the documentation for SQL Server. Just use the drop down to change the version as you require. You'll need to look in there really...

The error seems to suggest your script task may be trying to display a message box. When this package is running via the agent there is no user to display...

SELECT

a.Eid,

b.cDocNo

FROM

@a a

LEFT OUTER JOIN @b-2 b ON A.Eid = b.cid AND a.DocNo=b.CDocNo

WHERE

Eid IN (SELECT Cid FROM @b-2)

ORDER BY

a.Eid

That...

Make sure you've got a valid upgrade path first:

http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx

Hi,

In that case I don't know of a way to retrieve your data I'm sorry. You needed a full backup of the DB after you created it in order to...

Do you have the previous full backup and all transaction log backups that cover the insert and the delete?