This is the script

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[AgencyAccount](

[AgencyID] [int] NOT NULL,

[AgencyBalance] [numeric](19, 5) NOT NULL,

CONSTRAINT [PK_AgencyAccount] PRIMARY KEY CLUSTERED

(

[AgencyID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE ...

Thanks for the reply

Can u explain how to give this permissions(windows) to sql serservice account.

The SQL server and sql server agent is run under Built in account(Local system)

i tried this too but same error

Cannot access the specified path or file...

i had already given the db_owner permission...

Thanks Mark and jeff

Jeff great article written by you...trying to understand the tally table generation 🙂

Didn't seen your post, thanks once again

i will do some testing and let u know

I got this finally now i had to do some testing based on different data...

DECLARE @Checkin date = '2012-01-01'

DECLARE @Checkout date = '2012-01-04'

DECLARE @Checkoutin date

SET @Checkoutin = DATEADD(DAY,1,@Checkout)

--SELECT @Checkoutin

--SELECT @Checkout

DECLARE...

thanks dwain for the help.

Actually i got this result..didn't update the script with rate...got stuck with this query for almost 2 days.

As you see i use calendar table and tally...

thank you very much...exactly this one i wanted.

One more question

Isn't cross apply is slow...travesing so many tags

thanks for the reply

There will be two versions of application one for server and other as client, both needs sql server dataabase, and what type of licencing should I consider....

thanks srikant

can u explain why you r using '.' instead of tags

Thanks to all

I am following the generalization concept, it will be easy to implement and may be in future there will be new product, which can be easily implemented...

Hi Gail

Thanks for the reply

I decided to go for seperate tables, as it would be easy to maintain.

As i mentioned earlier each search request will go to their corresponding table...

Hi

This is B2B and B2C travel application with end users will be travel agents and customers.

Yesterday I read the Generalization (SuperType/SubType)concept in DB designing, According to this concept...

dev

I will keep the education in a seperate table add the referece to the profile table

Koen Verbeeck

For sparse it has disadvantage it will take additional 4 bytes + column...