Viewing 15 posts - 2,926 through 2,940 (of 3,221 total)
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...
August 25, 2008 at 6:51 pm
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...
August 25, 2008 at 11:14 am
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...
August 24, 2008 at 3:20 pm
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...
August 23, 2008 at 3:56 pm
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.
August 23, 2008 at 3:37 pm
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...
August 21, 2008 at 3:03 pm
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...
August 21, 2008 at 3:00 pm
Do not see a question....
Please read the article whose link is in my signature block and then re-post
August 21, 2008 at 2:37 pm
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
August 21, 2008 at 2:34 pm
timbw
It is based on the sum of totalPurchased
Sergiv
HAVING
COUNT(T2.row_id) >= 3
Sergiv a nice solution. I puzzled for over an hour how NOT to use a...
August 20, 2008 at 7:41 am
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...
August 19, 2008 at 12:25 pm
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...
August 17, 2008 at 8:59 am
Update Dbo.Table1 UPDATE dbo.location SET local_Phone = '91'+local_phone
August 16, 2008 at 3:27 pm
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 ...
August 16, 2008 at 3:17 pm
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...
August 15, 2008 at 6:46 am
Viewing 15 posts - 2,926 through 2,940 (of 3,221 total)