No promises, try casting the NOTES column to varchar(max) in the select list, CAST(NOTES as VARCHAR(MAX)) as NOTES.

Sean Lange (4/24/2012)

---

And the 28,000+ queries isn't exactly going to be fast. :w00t: Add to that the implicit conversion on every single column...might was well take a nap.

If we could...

GSquared (4/24/2012)

---

jfogel (4/24/2012)

---

TravisDBA (4/24/2012)

---

You just exactly made my point, you are admitting basically that you are already using (or would use) some type of illegal drug, just not blow at...

SQLRNNR (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

I didn't know JR was killed? I thought he was...

TravisDBA (4/24/2012)

---

Of course absolutely, I'm not preventing people from their opinions or their free choice for that matter, even if it is currently illegal. People are going to do what...

Read about Tally Tables, fourth reference in my signature block below. Start there and as you have questions, ask.

I didn't know JR was killed? I thought he was just shot. ...

TravisDBA (4/24/2012)

---

I'm sure there are other options, but there needs to be a open forum for discussion. This is where listening to those on the front lines is important.

The...

wutang (4/24/2012)

---

adrian.facio (4/24/2012)

---

Hi, what do you think about this one?

-- A tally table is needed.

CREATE TABLE Numbers (Number INT)

INSERT INTO numbers

SELECT TOP 1000 row_number() OVER (

ORDER BY column_id

)

FROM sys.columns;

--...

Let's see. If regulated (yes, under age...

That's why I said I...

TravisDBA (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

TravisDBA (4/24/2012)

---

You just exactly made my point, you are admitting basically that you are already using some type of illegal drug, just not blow at this time(which...

Dev (4/24/2012)

---

The following still holds good...

realyl need to find something from MS...

TravisDBA (4/24/2012)

---

You just exactly made my point, you are admitting basically that you are already using some type of illegal drug, just not blow at this time(which BTW is usually...

Read this article and the discussion following it.

http://www.sqlservercentral.com/articles/T-SQL/68467/