I have written (necessary) dynamic sql that actually need '''''' (that is six single quotes) '''''' around pieces of code to get what I wanted. writing dynamic sql is...

morepainot (8/3/2012)

---

Lynn Pettis (8/3/2012)

---

morepainot (8/3/2012)

---

Incorrect syntax near the keyword 'of'.

SET @nsql = '

SELECT

DataType of Column + ColumnName + '' of the Table ' + 'TableName+'' is...

morepainot (8/3/2012)

---

Incorrect syntax near the keyword 'of'.

SET @nsql = '

SELECT

DataType of Column + ColumnName + '' of the Table ' + 'TableName+'' is not same as...

Here is part of your problem.

The function dbo.fnRubricDomainScoresMarzano is a multi-statement table valued function. What this means is that the function does not return its value (table) until the...

Are you using Hyper-V? If so, moving to Windows 2008 R2 makes sense. We made the move for the enhanced capabilities within Hyper-V as we started using virtual...

Okay, we have another tvf, dbo.fnDomainCalculateMarzano. Can we get this code as well? By the way, I think I may know part of the problem and I will...

There is a slight logic error in the following CASE statement. You will get a NULL value returned if TV.OverallScore is 0.0, 1.5, 2.5, or 3.5. If you...

Not enough info to really answer your questions. First, you say the mirror went down, how about more information about you mean by went down? Did the server...

benjamin.reyes (8/2/2012)

---

Between partially contained databases and being able to create your own server roles in 2012 I'd imagine you could do what you're asking.

Though you'll want to have someone somewhere...

Can you post the DDL (CREATE FUNCTION statement) for [dbo].[fnRubricDomainScoresMarzano]?

Have you compared execution plans on the queries/procedures between the two systems?

bsclyde (8/2/2012)

---

I am humbled by the response to my original post and am grateful for all the input. Yes, even those that were

and

possibly even...

Jan Van der Eecken (8/2/2012)

---

Wow, Lynn. You are still following threads you participated in three years ago, and then really go back and correct them? That's what I call dedication...

capn.hector (8/2/2012)

---

LOL :w00t::w00t:

i posted what i had figuring on working on it and actually expecting some one to beat me...

That's what I get for not checking first.