I'm guessing that your code looks for the file at C:\ReportFooter\Test.txt, which likely doesn't exist on your server. Place the file somewhere that it is visible to both your local...

Did you run the code I posted to see what it returns?

Did you mean something like this as far as the revenue calculation?

SELECT

 CustNum = lg.Customer

  ,TxnMonth = lg.TxnMonth

  ,Revenue = Sum(Isnull(lg.Price,0))

FROM

  dbo.Logs AS lg

GROUP BY

  lg.Customer

  ,lg.TxnMonth

ORDER BY

  TxnMonth

  ,CustNum

Since you said it was a many-to-many, are you actually going to have contacts that span multiple customers?

As for the identity issue, when you insert a new customer, you can...

Sam, even if you have BI installed, it does open up the XML (well, RDL technically, although VS sees it purely as XML) as he says, if you double click...

Open a BI project, and then under Reports in the Solution Explorer(? Sorry, from memory), right-click and choose Add Existing Item. Add the RDL and create the RDS that it...

I would recommend looking up the following in BOL:

EXECUTE

RETURN (both the T-SQL Reference and "Using RETURN")

Note: I thought I should note that when I interview people, I throw all sorts...

Can you do one quick favor? Drop the CLIENTNO DESC from the ORDER BY clause in the query that you're running against the view and report back. This is very...

T-SQL doesn't use "IF-THEN-ELSE-END IF" syntax. You'll find our own flavor of IF in BOL under "IF ...ELSE".

You could use the File Transfer Protocol task for FTP, and since you have an Execute Process Task available, you can do it in just about any manner you want,...

Just add WITH GRANT OPTION to the end of your grant statement, just like Oracle.

John, now I'm confused again. Your tables are constrained by the month as near as I can tell, yet your latest query crosses over months, so even a well functioning...

Cory, my first recommendation is to avoid it if possible.

The only reason we use it is we have individual tables that can have...

Loner, while I agree that it would be ideal if they could force their clients to use a standard format, I've been in too many situations where that was simply...

The one I linked to claims to have 77 conditions, including "Start/Finish", and then as automated actions you could send an e-mail, start the job, etc, but home-grown works if...