Viewing 15 posts - 2,431 through 2,445 (of 2,452 total)
Hi Andrew
I am assuming that you are using Access to view a SQL database via linked tables and that on the SQL server you have created a linked server to...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 4, 2009 at 6:44 am
Hi...update
solved the problem by using the variable in OPENQUERY against the linked server.
this issue only appeared to manifest against large source tables (>1M rows)....still dont know why, but the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 24, 2009 at 12:02 pm
Hi
We are trying a similar project..SQL2005 (Std), SSRS and WSS3 SP1 on Windows2008 (32-bit)...so far unsuccessfully.
Here is a link that you might find useful:
and the Word doc is here:
http://blogs.msdn.com/sharepoint/attachment/4194088.ashx
If...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 8, 2008 at 11:33 pm
Hi Jerry
Thanks for your thoughts.....and yes we have been reading and searching:)
SQL 2005 SSRS also has a SharePoint Integration Mode ......you also need to download the reporting services add in...will...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 7, 2008 at 10:53 am
Jason...you can get the same result using your timestamp
SELECT tm.Business_unit_id, tm.Download_Type, tm.transmit_status_code,TM.Transmit_Timestamp
FROM Transmit_Manifest TM
INNER JOIN
(SELECT MAX(Transmit_timestamp) AS MaxTimeStamp
FROM Transmit_Manifest
Where download_type = 'A'
GROUP BY Business_unit_id ) MAXTIME
ON TM.Transmit_Timestamp=MAXTIME.MaxTimeStamp
gah
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 6, 2008 at 9:16 am
SELECT tm.Business_unit_id, tm.Download_Type, tm.transmit_status_code,TM.Transmit_Timestamp
FROM Transmit_Manifest TM
INNER JOIN
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 6, 2008 at 2:59 am
Thank you Gail.
I thought as much, but needed some clarification.
Will probably create them now anyway as they will assist other users in understanding the schemas.
Graham
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 4, 2008 at 12:19 pm
Hi Richard
I was interested to read your post because we are considering building a solution that sounds similar to yours.
I have a system developed using sql 2005. It allows users...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 1, 2008 at 10:45 am
make sure that any 3rd party ODBC drivers you intend to use are 64-bit.
You can install 32bit drivers on Win64 (odbcad32.exe)..but SQL64 will not be able to use them.
regards gah
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 1, 2008 at 5:44 am
Thank you very much Marios...that has clarified it.
regards gah
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2008 at 4:39 am
Thanks for the reply Marios
- enable AWE to max memory of 4 GB, to enable the data buffer of your SQL instance to 'see' 4 GB of memory and leave...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2008 at 12:43 am
Apologies if I should have created a new topic....
Having read thro this thread and a multitude of others on here and elsewhere, I must confess to still being confused....
We need...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 30, 2008 at 12:59 pm
Thanks for the info, it is appreciated.
regards gah
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 29, 2008 at 4:50 pm
jgrubb (10/29/2008)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 29, 2008 at 11:56 am
Hi
I havent tested the code but the comments posted against the artice say
"usp_GetIndexKeys should have been usp_GetIndexColumns"...that script is there in the post.
gah
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 26, 2008 at 6:02 am
Viewing 15 posts - 2,431 through 2,445 (of 2,452 total)