tcaldw

If memory serves me correctly with Access all necessary data is transmitted to a scratch file on the client, and then the query executes using the scratch file as its...

na.netjob - you provided some, just some answer to Jeff Moden's question, but NOT enough to allow someone to really help you.

Unanswered is how do you want those...

Think you should read Jeff Moden's latest article

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

By Jeff Moden, 2008/08/19

at http://www.sqlservercentral.com/articles/T-SQL/63681/

It is a great article on what it...

These two easily fit on my home desktop (Dell Inspiron -530 OS XP Professional with Sp-3 2 GB Ram 230 GB disc) and allow me to do just about...

Do not know if this is exactly your problem, but read the following posts

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3487915&SiteID=17

Seems as if many others are having a some what similar problem.

Last time I looked Developer Edition is available from Amazon ... depending upon your selected mode of shipping price will be approximately $50.. (USD)...

Took the time to look as I...

When examing the excel file, the 1st 150 rows (beside the column heading) is empty, but the 150 rows is inserted after row 150. So I got 300 rows...

Do not see a question....

Please read the article whose link is in my signature block and then re-post

Larson please post after reading the article whose link is in my signature block... It is meant to have you provide enough data so those here can best help you

Sergiv a nice solution. I puzzled for over an hour how NOT to use a...

Might I suggest looking at Books On Line (BOL) subject:

ADO and SQL Server

Managing Long Data Types.

Rather a good discussion / howto guide, includes creating a sample table based...

Gova sorry but I am having difficulty completely understanding your question

Expected result is to have data for each group when it is started.

Example '01/01/2008' and '01/04/2008' are same data...

Update Dbo.Table1 UPDATE dbo.location SET local_Phone = '91'+local_phone

I believe this would give you the results you require

SELECT Rowkey, Min(RowDate), Version, Capacity FROM Mytable GROUP BY Rowkey,Version,Capacity

For rowkey 23 it will return

RowkeyDate ...

Would suggest that you review

sys.system_columns, sys.columns and sys.all_columns in BOL and you should be able to write some T-SQL to extract the information you are seeking

or

use INFORMATION_SCHEMA.COLUMNS for example:

Using the...