okay remi - you beat me to it - I was going to suggest converting the date first so that he could then use any date as filter (instead of...

Bryan - here're a couple more things you could check out...

1) Settings - Control Panel - Administrative tools - Services - Under SQLAgent properties - check "Recovery" tab for settings...

Beth - you may be looking for something like this...

SELECT cyear, client, SUM(fees)
FROM tt1 A
WHERE client IN
(SELECT TOP 20 client FROM tt1 B WHERE A.cyear = B.cyear
GROUP BY cyear,...

Erik - there is a join in your query....in the where clause....

..WHERE Year(orderdate)= 1997 AND od.orderid = o.orderid...

However, joins with this syntax are all but obsolete...read up in BOL on...

Eric - did you "drop by" BOL with this question -

Here's an explanation of what the "Grouping" function does...

"Grouping is an aggregate function...

Hey - I'm quite happy admitting I'm human and prone to err - it's these dratted users who seem to think that everything should be smooth sailing from day one...

If all the relationships have been created - you could go to the "Diagrams" folder in your database (EM) - right click - "New Database Diagrams" - follow the wizard...

Manish - yes, you can drop a view - not create it. The only way I know where you can create a view inside a stored procedure is to do...

Manish - you cannot create a view (or a trigger) within a stored procedure...you would be better off creating your view in your database and selecting from it in your...

Just modify Carl's query slightly to:

select table_name, column_name from INFORMATION_SCHEMA.COLUMNS

order by table_name, ordinal_position

How very modest Chris...and here I was thinking you "know it all"!!!

At any rate, my latin is limited to "carpe diem" so here's something...

Not at all...I've been laughing so much that I haven't had the time to sharpen my claws...

PAX everyone! The weekend beckons so let's part on a compromising note...I extend to...

alright guys - y'all asked for it! I'm no blonde but on behalf of all of them who're legally so...

What do you call a man with half a brain?

...

Yelena - never did get around to reading Galsworthy - hadn't heard of Japrisot - thanks for the tips on reading and movies..(how did you know I'm a movie buff...

farrell - "working out world problems in a bar..." sounds like quite the thing to do....got any worked out ?!

'kay - am quitting for...