Thanks Andy for your input.

I tried a third way... put the program files and data files in a folder that does not contain spaces... and it worked!

Sincerely,

Billy

thanks Jay for your response.

Yes, the full outer join is necessary for those employees that may not have order records in the one of the time frame.

Your sql statement looks...

Instead of: tableprop.[value]

try: cast(tableprop.value as varchar(8000))

Are you running this query from Enterprise Manager? If you run it in SQL Analyzer, the cols that return as binary will give you...

Here are some kbs that related to maintenance plans:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288577

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q326485

http://support.microsoft.com/default.aspx?scid=kb;EN-US;303292

HTH

Billy

thanks mromm for the idea!

cheers!

Billy

thanks mromm.

Creating a proc (eg. usp_insert_product) using @@identity works if you only have one product (as in the example I raised).

However, what if you are inserting more than one product...

If I create a trigger on the product table to insert a record into invoice header table, then how do I insert a record in the invoice detail table? ...

Thanks for everyone's responses..

ewilson: I think you mean "datepart" returns an integer.

all: *sigh* if only there was some other more elegant way of getting just the current date instead of...

thanks..

however I am looking for something that will remove the seconds (as well as the hours and minutes) from getdate()...

for example, if I assign getdate() to a variable, it will...

Thanks everyone for their responses.

Steve: sorry, I wasn't too clear on the table locking issue. According to BOL regarding table variables: "Transactions involving table variables last only for the...

whooops...

instead of...

ORDER BY COUNT([y.UserID]) DESC

try...

ORDER BY COUNT(y.[UserID]) DESC

(notice where the first [ was ...)

Billy

SELECT y.name, COUNT(y.UserID) AS UserCount

FROM TUserLogs x inner join tsubscribers y on x.userid = y.userid

GROUP BY y.name

ORDER BY COUNT([y.UserID]) DESC

SELECT y.name, COUNT(UserID) AS UserCount

FROM TUserLogs x inner join tsubscribers y on x.userid = y.userid

GROUP BY y.name

ORDER BY COUNT([UserID]) DESC

You can do all of that via Enterprise Manager (EM):

1) within EM, right-click the table to bring up properties; it will show you which file group the table is stored...

Thanks!

does anyone know what kind of an index it is when indid=0 in the sysindex table?

I checked BOL and there was nothing. I know when indid=1, it is a...