And if you want a pretty good introduction to backup and restore, look on YouTube for ScaryDBA - Grant Fritchey has a video on doing just backups (differential, full, TLog)...

You can attach to lower versions, but not higher ones.

What is your compatibility level set to on the database?

To figure it out, right-click the database, go to Properties and then Options. I would bet that it's set to...

If you absolutely have to get the disk space free, then you can use SHRINKDATABASE or SHRINKFILE, but it does awful things to your databases. You have to reindex...

Uncharted territory... so here goes... I attached the RDL as a TXT file. (So just change the extension back to RDL and you should be able to import it...

See if Grant Fritchey has anything posted about it on YouTube. he might, since he works for them.

Gotta get out my book to be sure...

"Execution Context"

... an execution context can be specified for code. Specifying an execution context enables code to be run under a specific...

If you're fairly new to SQL, I would do this in SSRS, because you can get SSRS to do pretty much all the hard work for you (sorting, grouping, subtotals,...

Okay, read this article and follow the instructions... Not trying to be mean, just trying to teach you how to use this site. Because if you don't follow the...

Since you're new, I'll go easy on you... <g>

One thing to keep in mind when posting questions is that you're the only one with access to your database, so if...

If you're creating a stored procedure to put your CTE in, just pass @StartRange DATE, @EndRange DATE...

Kind of depends where you do the limiting... if you do it in the stored procedure, use something like

SELECT...

FROM ...

[SomeDate] >= DATEDIFF(m,-3,GETDATE())

Trying to subtract from a MONTH() value won't work.

Not sure you can show a many-to-many relationship without a child table. That's just the standard way to do it... the standard example is

Invoice--(1,M)--LineItem---(M,1)--Product

where the LineItem table...

In the first/inner query, use a DISTINCT.

SELECT DISTINCT [column list]

and then in the outer query, do your sum

SELECT Col1, Col2, SUM([numericColumn])

FROM

(SELECT...

Try this:

SELECT DocumentNum, LineNum, CustomerNum, MAX(VersionNum) AS MaxVersion

FROM tempSalesOrder

GROUP BY DocumentNum, LineNum, CustomerNum;