Use the DATEDIFF functions ...

for example

SELECT DATEDIFF ( datepart , startdate , enddate )

This will return the number of days difference.

SELECT DATEDIFF(d,'2013-04-05 10:45:41.013','2013-04-07 14:45:41.013')

returns 2 days

This returns the...

bigshopmall (4/4/2013)

---

Suppose the column name of table is mValue and tablename is xy then following query will give the result:

select mvalue,RequiredValue = case when ISNUMERIC(left(mvalue,1))=1 then SUBSTRING(mvalue,1,CHARINDEX(' ',mvalue)-1)

...

Knew two - guessed the 3rd .... but wondering how many of those answering the question actually use the Resource Governor ?

I would suggest you start your upgrade task using the Upgrade Advisor

here is a link that will assist you in starting your upgrade

http://msdn.microsoft.com/en-us/library/ms144256(v=sql.90).aspx

The above reference starts with assistance in upgrading...

Without sample table definition(s), and sample data it is difficult to make a recommendation.

That said, I would recommend that you look at the MERGE statement.

For example:

[ WITH <common_table_expression> [,...n] ]

MERGE...

Thanks for a nice clear question

Very, very good question + nice question ... made me aware of the subtle elements of using tables as parameters, and thanks

Revenant (3/22/2013)

---

I agree that the question is murky due to the exceptions. It took me 25 minutes to figure this one out; it forced my to read BOL really carefully.

Thanks,...

Can I brag, can I boast ..... can I pat myself on my own back ... wether I can or can not .. I will

My one hundreth QOD has been...

Nice question - had to think long and hard for the correct answer

You could get a good idea of what needs to be done for the upgrade by running the UPGRADE ADVISOR available at:

http://www.microsoft.com/en-us/download/details.aspx?id=11455

Nice question .. learned something from it ... thanks

Without actual test data all I can suggested is that you look up the REPLACE function.

It is used in this manner:

REPLACE(<old_text>, <start_num>, <num_chars>, <new_text>)

If you would provide some sample data,...

Rauf Miah

Your request sounds very much like home work. I am not adverse to helping a student, but first post what you have attempted, and the error message returned...

If I understand what you desire to do correctly, this should do the job.

CREATE TABLE T(COMCOD nchar(4), ACTCODE nvarchar(6), ACTDESC nvarchar(250),

PRIMARY KEY (ACTCODE))

...