I was going through one white paper recently and thought its good. A lengthy one but discusses lot of aspects with performance tuning.

(May be more suited for a DBA...

Please read this article on how to post query,

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Is this what you need?

select geog.region_name, sum(sales) AS Total_sales

from store_info inner join geog

On geog.store_name = store_info.store_name

Where geog.region_name = 'west'

group by geog.region_name

Order...

What is the business rule to get your 'first' and 'last' row?

AS suggested earlier, give some test data in a consumable format and what you expect and the rule for...

Some test data and table script would help a lot.

But is this what you want?

Select X.id,Y.id,X.create_time Pending_time,Y.create_time unlock_time

From ticket_history X

JOIN ticket_history Y

ON X.ticket_id = Y.ticket_id

AND X.state_id = Y.state_id

Where...

Not completely sure if I understand your requirement, but i think 'multithreading' is something you may want to look at. Create a new thread and leave it to execute. This...

or this?

Declare @string varchar(20)

SET @string = '2009-Nov-11'

SELECT datepart(m,CONVERT(datetime, @string))

pesche_h (12/8/2009)

---

Thank you very much for the hints, that works nicely, so far!

However, is there also a solution for other conversions than date-conversions? (e.g. overflow when converting to smallint, conversion...

Checkout ISDate,

http://msdn.microsoft.com/en-us/library/ms187347(SQL.90).aspx

How is your date stored in char data type, I mean the format? what is the conversion that you are doing?

ALZDBA has given you a good example. How'd you tell SQL Server what is the 'last' message?

Isnt it the same as,

http://www.sqlservercentral.com/Forums/Topic829346-149-1.aspx

I thought arun has answered it and u dint give any feedback on that thing there?

Hi James, good to see data in a consumable format but I am afraid the requirement you are giving is insufficient. Its an attempt to answer your question and give...

Not sure but these date functions handle these things, no?

This,

Select dateadd(mm,1, dateadd(day,0, datediff(day,0,'2010-01-29')))

would give me the result,

2010-02-28 00:00:00.000

Edited: Ohh ignore it please Chris, I now got what...

You can use tally table also, does this help?

I think it will return the last record also which is of no importance in this case,

SELECT (U1.ROLLNO + 1)

FROM ...

If the deadline is going to be one month ahead of the current date when the update is happening, then can you use this?

sorry if I underestimated your requirement

Select dateadd(mm,1,...