This is a suggestion for all those intending to wear Kilts at the next PASS... ask the organisers to get in some special chairs for you 😛

Which is exactly why...

I've just bought SQL Server 2008 Administration with Windows Powershell (ISBN 9780470477281).

I'm only on page 60 of 500+ so far, so I can't give a full review.

What I will say...

You've already said you think it's a bad backup plan, so I won't pass any comments on what you're doing.

Switching from full to simple won't make any difference to your...

Exactly what do you mean here?

Do the nested stored procedures have their own transaction handling i.e. BEGIN TRAN......

What sort of backups... database or transaction log?

When you backed up your transaction log, how big was the backup file?

Is...

I don't think Technet will allow the OP to do...

I don't think there is, Lynn... this is from the MSDN site

MSDN subscriptions are licensed on a per-user basis....

See if your company will swing for an MSDN subscription.

That will entitle you (and only you) to install and use as many copies of the software included in your...

This wasn't the article I was thinking of, but is Microsoft's explanation:-

http://msdn.microsoft.com/en-us/library/ms178050(SQL.90).aspx

This is a gotcha with correlated subqueries.

The tblCard table is implicitly included in your outer select (tblStop). Because SQL Server can't find SerialNumber in tblStop, it has a look in...

Are you sure, Jeff?

I know the initial snapshot uses BCP, but (unless it's changed...

You seem to be posting an awful lot of very open questions, most of which you could find the answer to by doing a bit of research on Google/Bing.

Are these...

The join syntax using 2 derived tables is no different to any of your other joins, I just think you've missed it out.

Without table definitions, sample data and expected results,...

I presume you are getting a syntax error with your 2 derived table script.

It looks as though you have missed out the join criteria where I've highlighted.

SUM(valowbincid.Bincid) as 'BincidDocTesouraria', SUM(valorIVA.IVAdoctes)

FROM

(SELECT...