Visit here: They have free trial periods so you can test before purchasing. By the way this is the Camtasa site

http://www.techsmith.com/

You might want to read "Guru's Guide to Transact SQL by Ken Henderson ... page 36 Google it and Google books will allow you to search for...

Phillip

Thanks

Phikkip Horan

needed to split across 3 excel worksheets due to the row limitation .xls as the import wizard did not recognise .xlsx (excel 2007 file extension

If anyone knows of...

Can you post the table definitions and some sample data as per the link in my signature block so that someone can properly assist you?

PS

Another option for you is to install the Developer version of SQL 2005. The last time I looked it was available on AMAZON.COM for a price of $48.89 (U.S....

Here is the install path on my machine (Note I also have SQL 2000 installed). What you are looking for is: ssmsee.exe

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ssmsee.exe"

For EXCEL 2003:

Limits:

Reference Excel Help File

Worksheet size 65,536 rows by 256 columns

Column width 255 characters

Sheets in a workbook Limited by available memory (default is 3 sheets)

EXCEL 2007...

Yet in your DATEPART you are using "quarter". What is in the @Nums table variable?

This little bit of code does not return an...

Use Books On Line (BOL) entriy for System Views:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/13bccc2f-ed3c-4b58-abd0-ca8bf34a66b8.htm

This in turn will allow you to view what is contained in sys.tables and sys.objects

And finally read about sys.all_columns at:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/40e04fe9-0b64-4799-84c0-57f128b2bdc2.htm

After all...

My apologies to anyone who read this post before I edited same.

Enjoy your experience as a Scout leader, devote as much care, energy and thought to that as you do...

Raghu

Agreed your question did excellently perform the task of teaching. Spent a lot of time with BOL and Technet,+ MSDN and perhaps learned more than what I wanted to...

Grant

Good luck in that position. I spent...

Philip

This site has a large number of forum postings concerning the transfer of Excel data to SQL and its attendant problems . I would respectfully request that when you...

The standard answer is "That depends". I believe the default value for a remote query timeout is 600 seconds.. heck that is enough time to take a coffee...