Brad,

Welcome to SSC... consider yourself schooled. (I'm still there, and I've been here for a while!)

Looks like you're a recovering Access/VB(A) programmer. Definitely true what Jeff said. ...

One way to do what you want is to attempt the insert inside a TRY/CATCH block, and then use an OUTPUT parameter to return the error number to it when...

BETWEEN 2013-11-26 13:49:00 AND 2013-11-26 13:49:59?

https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

Happy reading!

You mean something like this?:

SELECT UniqueNum

,Somenum

, CHAR(ROW_NUMBER() OVER (PARTITION BY SomeNum ORDER BY UniqueNum ASC)+64) AS LetterSuffix

FROM #temp_Alpha_num

ORDER BY uniquenum,Somenum ASC;

so that when you get 121A to 121F and then...

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...