Good comment here however consider...

Tatsu (9/21/2005)

---

It should be noted (and probably has been in the past) that stored procedure calls need to be parameterized as well. Use the appropriate Command class for the target...

To my knowlegde 64-bit should not even install. But no it (64-bit) will not work on a 32-bit enviroment. However, with that said I seem to recall 64-bit SQL 2005...

I assume the UID is part of the Table variable. This might work

DELETE

xT

FROM

@tblCustomers xT

INNER JOIN

Invoice I

INNER JOIN

InvoiceItems II

INNER JOIN

TicketPackages TP

ON

TP.TP_ID = II.SeatPackageClub_ID

AND (TP.Category_Num = @vintCatPrevSeason)

ON

II.I_GUID = I.I_GUID

ON

I.UID = xT.UID AND

I.AUTHCODE...

BTW I do agree with the lack of interaction actually brings me down a bit, I only telecommute 2 days a week. Wife does as well but on different ones...

If the file grows to the maximum it will not grow anymore as stated. And if the file is full of data such that it fills you will get an...

Sorry a placement issue, I didn't see Agencies was joined to DataUpload and placed it under DataDownload which caused this error.

SELECT

MD.DatasetId AS ID,

MD.DataCurrencyDate AS CurrencyDate,

MD.DataFormatType AS DataFormat,...

All items are valid. I will say as far as advantages

For you

1) You can focus on the work with fewer distractions.

2) It can reduce personal tensions when dealing with some...

Have you tried the built in charts of RS? Dundas also has to be installed on the server I do believe to work. But the main question is what type...

This should do the trick, first GROUP BY with all the output elements will give you the same net effect as DISTINCT, so drop DISTINCT and replace with the appropriate...

This should be right as I am using a having clause which can support the MAX funtion as well the grouping will remove the need for distinct. My additional thoughts...

Going back,

1 did you get any errors

2 did it just keep running

3 did you just gt no results

?

Do you get any errors? And which Group By are you specifically referring to?

My personal thought on this has been that many of these objects exist do to improper management of data and in many cases because it was created it has to...

It would all depend on your circumstances. If you need often then I would create a table with a bunch of names then pull from it using TOP n and...