Good stuff.. but please check the data is consistent with what you expect.. cheers jd..

You could try something like this:

INSERT CruiseOffersTmp

(

voyageNumber,

departureAirport,

duration,

departureDate,

availability,

cabinGrade,

cruiselineID,

cruiseshipID,

bestPrice,

brochurePrice,

uploadEntryDate,

flyCruise

)

SELECT

pt.Cruise_Number,

pt.Embark_Date,

pt.Air_City,

pt.Air_Indicator,

pt.category,

am.cruiseLineId,

pt.Category_Status,

pt.Best_Price,

pt.Brochure_Price,

pt.Duration,

cgv.ship_code,

cgv.brand...

I dont like it much but you could try something like this :

create procedure spRPT_INV_StockMovement

@branch_id uniqueidentifier,

@from_date datetime,

@to_date datetime,

@column_name nvarchar(255),

@filter_value nvarchar(255)

as

begin

select t.* from

MyTable t

where

t.branch_id = @branch_id

and

t._from_date >= @from_date

and

t.to_date <=...

I have seen situations where query hints were vital. see http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2005-123 it relates to indexing heavenly bodies and uses a TVF as a kind of spatial filter. Without...

Hi Chris, thanks for the reply.. I really thought there would be an elegant solution!! never mind I have got around it (after a fashion) using sp_executesql

step 1 create a...

Horses for courses... SQL will still be the language for manipulating sets but CLR opens up a whole load of opportunities to those who want to get involved.. I am...

A common solution to this problem is to have a view the contains GetDate() and query the view in your function...

HTH jd