Re: T-SQL
Roy Harvey (SQL Server MVP) wrote:
A stored procedure runs on one connection, but it can reference
multiple databases on the same instance of SQL Server. If you
describe what you actually need to do someone may be able to suggest
an approach.
Thans for your reply. I wished to creat a report. Some data of the
report is confidential data. It is in another database requiring
different username and password. I am given all necessary usernames and
passwords. I would want to write the report that will combine these
data and regular data. Is this possibility?
Roy Harvey
Beacon Falls, CT
.
Relevant Pages
- Re: MS Access Reports and VB.NET Program
... think that I want to ship a 30mb .NET framework to each of my clients? ... Barns & Noble has some books that could help you learn .NET. ... It is Access TIMES eCommerce TIMES Sql Server. ... that you actually posted how to execute the report using a macro. ...
(microsoft.public.dotnet.languages.vb) - Re: MS Access Reports and VB.NET Program
... It's not always about you Aaron. ... Barns & Noble has some books that could help you learn .NET. ... It is Access TIMES eCommerce TIMES Sql Server. ... that you actually posted how to execute the report using a macro. ...
(microsoft.public.dotnet.languages.vb) - Re: Converting app to ASP?
... If they used a report writer the reports would take a few seconds to process but they pass the report on to the clients and not all of their clients may have Access but would have Excel. ... On the other hand if those developers are really talented developers then they might be able to offset some of those increased costs. ... We see weekly posts in the SQL server newsgroups that when people move their data from an access backend to that of SQL server, ... often the greatest value in any application built is all the business requirements and gathering and building something that the employees need. ...
(comp.databases.ms-access) - Re: Converting app to ASP?
... If they used a report writer the reports would take a few seconds to process but they pass the report on to the clients and not all of their clients may have Access but would have Excel. ... developers are really talented developers then they might be able to offset some of those increased costs. ... I noticed in the past that a key user of the application has less than 500K memory so perhaps delay is from the memory, ... We see weekly posts in the SQL server newsgroups that when people move their data from an access backend to that of SQL server, ...
(comp.databases.ms-access) - Re: PRIMARY filegroup is full - no its not!
... Consider using sp_helpfile to report the sizes. ... Columnist, SQL Server Professional ... "Dan Guzman" wrote in message ... > large file size after I expand the file using "ALTER DATABASE DataLoad ...
(microsoft.public.sqlserver.server) |
|
