brian_winzeler (9/15/2010)

Msg 8155, Level 16, State 2, Line 23

No column was specified for column 1 of 'drvU'.

Msg 8155, Level...

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

-- it would have made things easier...

What is the datatype of the bodyTextTable.bodyText column?

Edit: Is there supposed to be a difference between the two update statements?

Edit2: is the '%' actually in the data, or are you...

duplicate post.

Do not post replies to this thread.

Use this thread to post all replies.

Are you sure that pageDate is a DateTime...

Use the VB Join() function to pass all of the items.

1. Change "Today" to "GetDate()".

2. In your example, you want the date range to end on 9/14/2010. I assume this is a typo, and should be 9/14/2009?

What happens if the column is, and remains, NULL? Or if it's being updated from NULL to a value? Many addresses won't have an address2/3, and that could be null...

vivek.verma (9/15/2010)

@Wayne

Your solution is also working, is it some way possible to order the final result by date desc as the present final result set is as order...

One other point to make: the keys that make up the clustered index will be used in all other indexes. You might want to consider having an identity column that...

Brandie Tarvin (9/15/2010)

That would be nice, but is...

Jeff Moden (9/14/2010)

CirquedeSQLeil (9/14/2010)

WayneS (9/14/2010)

assh1122 (9/14/2010)

Thank you both for taking your time to answer my question. I could able to successfully change the table owner using the sp_changeobjectowner '[currentschema].[currenttable]' , 'dbo' command....

Very nice article - Thanks!

I'm especially glad to see the effect of an update statement on the different methods discussed. And as you so properly point out, the proper answer...

LutzM (9/14/2010)

Lynn Pettis (9/14/2010)