Woo, Can't wait til I can use regX in a function in SQL 2k5

You of course could evaluate every row, one row at a time, but I do not know if a set based way to do it.

In books online you will have...

They have xpath queries in sql 2005.

But the decision to store an entire string of xml in a column in a table, and expect to use it for reporting an...

THanks for that, I knew if I put something in there someone would know a better answer.

Woo, They have the internet on computers now! Homer J

Lol, Didn't need the cheat, I was able to beat the game without it. But I do remember.

Yeah, one and the same.

Just shortened my name to protect the innocent.

I didn't realize I had any style.

Just...

I talked w/ him via messenger, and I believe what he wants is

create table TestTable (AppSourceId int, appID int, SourceTypeID tinyint, score smallint, ScoreModelTypeID tinyint, Createdon Datetime)

truncate table TestTable

Insert...

Okay,

There are 2 rows with application id 6004701.

Which one do you want returned?, The first one, the last one?

What columns from this table do you want returned?

Pic is a broken link.

When you post Please post your query, a sample table definition, some sample data, and what you would like the results to look like.

http://www.aspfaq.com/etiquette.asp?id=5006

Lol, Pain.

Try this.

Alt, then Left arrow, then down arrow, then x

Woo Hoo, I hate that too.

Without sample data, I cannot test, but It looks like you do not need re.renderedemailstatusid in your group by.

What results are you getting?

and what results would you like to get.

Post...

I guess its my curious nature, or the urge to help out, But why do you want to use float?

Float is termed an approximate datatype.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_03_6mht.asp

Read this for more information.

As...

Similar thing happened to me.

You need to check the application log, it should tell you what the problem is.

It happened to me after installing service pack3a.

I was getting error

Like stated colorder does not matter, but if you must.

Using EM, Edit table in Design Mode, Add column where you want it.

Instead of hitting save click the Save changes to...

Like previously stated, No.

I guess you could create a trigger on syscomments and record the offender and time in a different table. But I'm not sure.

sushila got anything on this?