Hi

The below 3 sql statements give the contracts and the people under those contracts.

1: The first statement gives the work contracts for the...

Thanks for your efforts guys...

I solved it by using the distinct keyword and used site_name in place of posting_location_id in the Count statement!!!

Now i can count the site_name field...

Hi

i think i solved the problem.

thanks any ways

have you tried

if isnull(fieldname, '') = ''

select fieldname = 'xyz'

am not too sure... the above statement replaces a space with 'xyz' string.

regards

The actual query goes like this:

create function test(@idnumber varchar(27), @rangestart datetime, @rangeend datetime)

returns int

as

begin

declare @intdays as int

select @intdays = count(distinct date) from daystable as dates

                            inner join

                        (select ....'need to use...