Can I make a plea for returning the questions in the SQL Server 2000 forums to the daily newsletter?  Yes, I know we should be thinking about converting, and yes,...

I'm not sure what version of Crystal you're using, but if I recall correctly for version XI, I had to set up the Crystal environment to show certain object types...

Never has the newsletter heading

Users That Need Help

been more appropriate.

Thanks to everyone who responded. The 'max' path suggested by Mike was the one that occurred to me before I posted, but the fog of derived tables descended (to...

very interesting , thank you for your tips, i will try to do my operation using variable table, but now i have the next question, i know that variable...

Ged,

If you run the command

select * from information_schema.views 

as Ian suggested, you'll see the table_name value is what the view was renamed to using Enterprise Manager, and the...

I'm sure Microsoft wouldn't have gone to all the trouble of writing this logic if it weren't useful to someone, but I would love to know under what circumstances it...

Remi,

Thanks.  I understood what Jeff was trying to convey, but I never would have decoded the acronym.

Patrice

RBAR?

Mattie

Bugsy,

I think what Sreejith is saying is to schedule the job to create a DTSrun statement that you can then copy in to your statement, and then you would just delete the...

I wish I had some insight into the original posting, but my question actually relates to one of the responses.  Specifically,

Can you post the 2 sets of execution...

So does the statement

EXECUTE Northwind.dbo.sp_who should have worked and printed Surprise.

make this

Important If any user-created stored procedure has the same name as a system stored procedure, the user-created stored...

Obviously, Steve can't go on vacation anymore.

Tom,

I'm not sure I agree with the concept that the amount of typing should control how code is written.  After twenty years of programming, I've realized that you generally pay dearly...

 ReadyStatus = ( ReadyStatus = False )

So should this be documented, or rewritten?

Mattie