While the script above is handy, it doesn't work if you don't have Excel installed on the server.

I did have an occasion to import a SYLK file in a previous...

Do you have to use BCP? DTS has a builtin Datetime transformation.

Is the destination table the final destination, or is it a staging table. If it's not a staging table,...

Firstly, I don't know why you would waste time fiddling with this when DTS has a perfectly usable datapump that exports to Excel.

The error that you're getting is because it's...

Don't know why you have

WHERE Convert(VARCHAR,GLPeriod) + '/' + Convert(VARCHAR,GLYear) IN 
(
SELECT Convert(VARCHAR,GLPeriod) + '/' + Convert(VARCHAR,GLYear) 

As you're doing the concatenation in the where and the select, couldn't...

Ummm ... sorry ... just remove the "del" from the first line.

How many records are in each table? The main problem I see with queries using IN and EXISTS is the number of reads that are being performed.

You could try the...

A quick "google" on the HRESULT returns

"0x80040E4D -2147217843 Authentication failed"

Pretty much points the finger at permissions

Table variables cannot be sent to the client as this is an SQL Server specific datatype.

The PRINT statement is handy for issuing status messages when you're executing an SQL statement,...

Without getting into the reasoning for the two databases, the best solution will probably be triggers. You should put a trigger on each table to check the other table whenever...

This any help?

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarsqlsg/html/msdn_interntl.asp

As per Books Online, the default must be a constant or NULL.

You could re-code your stored procedure like this,

CREATE PROC NWtest 
 @endDate datetime = NULL
AS

IF @enddate IS NULL
 SET...

My stock of invitations has also returned to 50. Family and Friends have already profited.

Any further takers?

I'm presuming that you have an integer value for each date.

Given your de-normalised structure, how do you find out the attendance for a month, quarter, year ??

Maybe if you post...

To locate the version information, type the URL of the report server (for example, <A href="http:///reportserver">http://<exampleWebServer>/reportserver). At the bottom of the page you should be able to see the version.

RTM...

Use a LEFT JOIN.

INSERT INTO Prop (ListingID, Address, City, Zip, ListPrice, PropCID, PropTID)
SELECT
    LSID, B.Address, B.City, B.Zip, B.Price, 
PropCID = (CASE B.PropID WHEN 'A' THEN 'AA' WHEN 'B' THEN...