Eric Russell 13013 (9/15/2010)

---

The problem with social engineering and digital authentication is that it involves information that can be easily forged. If I call someone up and say I'm from...

Since this is a character field, what happens to a date that just happens to contain a zero (like year 2010, or days 10, 20, 30)? You might need to...

brian_winzeler (9/15/2010)

---

I've tried running this code and these are the errors I'm getting:

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)

---

Thanks guys 🙂

@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)

---

I may be missing it but it doesn't look like there's anything that will prevent someone from using the max number you get in the first CTE before...

CirquedeSQLeil (9/14/2010)

---

WayneS (9/14/2010)

---

assh1122 (9/14/2010)

---

Hi,

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....