Steve, first I think you fat fingered 'ot' - 'to' ... That will make the files more similar ot what I see in Object Explorer

Also, you can use a DB...

Digging deeper there was a varchar(15) to nvarchar(50) causing the CONVERT_IMPLICIT, changed to match the varchar(15) and problem went away. 😀

Love inheriting CODE and DATABASES.

I will look at this tomorrow. Thanks everyone.

🙂

That is the information I was looking for. I will begin adding indexes because these are multi "WHERE CLAUSES" column1 = @param1 AND column2 = @param2 AND @column3 =...

UPDATE ON THIS RESTORE ISSUE --- HOWEVER, I think by getting the SQL SERVER Service Key and Master Key correct the restore worked correctly as well. I will need...

More details - Why did I do a nested report?

The Course/SubCourse report is a tablix and I nested a matrix in order to utilize a pivot on the grades which...

Brian you should contact http://www.devproconnections.com/ and have this article printed. What a great piece of writting.

I ran your T-SQL on a SharePoint Content DB ---- ...

Thank you for the great article. Can you post a second portion on how a deveoper should truely read a execution plan and how to tune. ...

I am having a hard time grasping the concept. Below I have just done an inner join (aka) returning all values from the AnswerSessionDetail table and AnswerSession if...

bteraberry (7/30/2010)

---

A LEFT JOIN will include data from the tables left of the join and whatever data that matches up from the tables on the right side of the join....

SWEET!!!! SQL Server Central ROCKS!!!!!

This is my home for DB questions.................. 😀

DRI = ????

ty Jack...

The key question that I have still is what is the industry standard. An idea I am also thinking about is does it really matter leaving orpaned data in...