simple one today

i guess you have more than one hotelid in one of the table as your results shows diffrent resultid with same records

Thnaks for the Question.

I have learned something new today

may be this link is also usefull:

http://sqlserverpedia.com/wiki/Switching_Partitions_-_Prerequisites">

http://sqlserverpedia.com/wiki/Switching_Partitions_-_Prerequisites

Can you just post result of the below Query to see what value you are converting to numeric

dbo.FDiv((select Count(EmpNo) FROM SAR_WeekData where TotalHours >=30.10 and WeekStartDate='10/17/2010'),@TotalEmp)*100)+'%' as [Fourth Week]

Good Question with Proper Explanation. Thank u

i would be SQL DBA 😀

Create table Fruits

(Fruit varchar(10))

insert into Fruits

select 'apple' Union all

select 'apple' Union all

select 'grapes' Union all

select 'banana' Union all

select 'grapes' Union all

select 'blueberry' Union all

select 'grapes' Union all

select 'blueberry'...

for your information your 0 means "1900-01-01 00:00:00.000" in terms of datetime datatype

Really did not understand your requirments why you are getting diffrence in months between 0 and the getdate and then adding back to it

if you want your results then...

simple Question,

but the article that hugo has written are truly informative.

Simple but most of the people forget when they use it. Thanks any way

Simple one, First one to answer 🙂

Wiht the Chris idea on the cross apply and my previous split function that used for other perpose

i have written like this :

Declare @t Table

(

...

Thanks Chris now i got the idea of how you achived this.

Really i didn't understand the solution that is posted here.Please can some one explain me what exactly the Query is doing.