>>>>> Can you recommend any magazines, or any online sources that you use? TIA.
>>>
>>>Some of my favorites:
>>>SQL Server magazine
>>>Inside SQL Server 7 - Kalen Delany
>>>Joe Celko's SQL For Smarties
>>>SQL Server 7.0 Performance Tuning Technical Reference - Deluca et. al
>>>
>>>-Mike
>>
>>Thanks.
>
>In addition, I also recommend the Database Professional's Library series from Osborne.
>
>SQL Server 7 - The Complete Reference
>SQL Server 7 - Developer's Guide
>SQL Server 7 - Administration
>
>Coming from VFP, you probably already know more SQL syntax than you think. It is all relavent in SQL. The difference being that SQL Server will be more strict about certain things.
>
>For example, in VFP the following runs:
>
>select max(field1), field2, field3 from mytable group by field2
>
>It throws an in SQL Server because all non-aggregate fields must be included in the GROUP BY clause. SQL Server is also a tyrant when it comes to using keywords. In VFP, you can sometimes get away with it; never in SQL Server.
>
>Cheers!

Thanks for all your help.