Greg Snidow (8/28/2012)

---

Now let's not be too hasty. Some of us do care. In fact, I'd hazard a guess that if the total number...

I think the Hudson is clearer than this question.

RBarryYoung (8/28/2012)

---

Lynn Pettis (8/28/2012)

---

And this is the ANSI standard way of doing the same update as above:

UPDATE Orders SET

some_col = (select

...

GSquared (8/28/2012)

---

Lynn Pettis (8/28/2012)

---

And this is the ANSI standard way of doing the same update as above:

UPDATE Orders SET

some_col = (select

...

Making it easier for others:

http://www.flixxy.com/chubb-chubbs.htm

Sorry, but my crystal ball is in the shop still. You haven't provided nearly enough information to really help you as we can't see from here what you see...

Duplicate post. Although not sure if SSRS 2005 or SSRS 2008 is being used, please post all responses here.

Please do not cross post, it can result in fragmented responses.

And this is the ANSI standard way of doing the same update as above:

UPDATE Orders SET

some_col = (select

...

anthony.green (8/28/2012)

---

Sorry all, just got a total mind block all of a sudden.

The below table has PK as defined in the script below.

CREATE TABLE Table1

(

Col1 VARCHAR(64),

Col2 INT,

...,

...,

...,

PRIMARY KEY CLUSTERED (Col1,...

Luis Cazares (8/28/2012)

---

I'm sorry I didn't replied yesterday but we had to leave the office because of Isaac.

Here's a query that will work as a static report. It can be...

sam 55243 (8/28/2012)

---

Hi All,

I need one help in formulating select query.

I have a table with 50 columns in it, now i want to retrieve not all the columns from this...

CELKO (8/28/2012)

---

I got the impression, from the Connect article, that UPDATE FROM wasn't a part of the ANSI standard. That MERGE was to be favored; and frankly...

Try the following:

Click on the Tools menu, select Options.

Go to Query Results -> SQL Server -> Results to Grid, change Maximum Characters Retrieved for Non XML data to 4000.

Do the...

How are you determining that the data is being cut off at 255 characters?

My recommendation is to compare the features between your current version and the 2012 versions. Easier for you to do this than wait for someone here to do it...