Hello,

Scorpion_66 or anyone else who has the scripts, can I take a look at your scripts? I need to:

1. Periodocally Import data from a csv file into a temp table.

2....

Hello,

Got it done:

SELECT

a.Region Region,

COUNT(*) AS 'TouristCount'

FROM

Country_Codes AS a INNER JOIN Book1 AS b ON a.Code = b.Country

where region = 'canada'

GROUP BY a.Region

Hello,

Thanks a lot, that worked.

Tell me, is there a reference that one can use to learn these techniques, and which will show sample code. I have been using a reference...

Hi,

Just to clarify my requirements, I allow the user to search on a country:

(b.Country = @Country or @Country = 'ALL')

but then I only want to concatenate:

and (b.Arrival_date >=@ArrivalDateFrom And...