Viewing 12 posts - 61 through 72 (of 72 total)
Before you start writing this code you should check out the Data, Import External Data menu item. This will allow you to create a query or connect to an existing SQL Server...
September 13, 2004 at 6:29 am
Another option for this situation is to create a User Defined Function (UDF) to do the initial calculations and then refer to the UDF results in the final calculations
September 3, 2004 at 9:59 am
Check out the presentation by Andy Novick at http://www.novicksoftware.com/Presentations/UserDefinedFunctions/User-Defined-Functions-presentation.htm
He also wrote a very good book about UDFs.
August 30, 2004 at 6:19 am
Thanks, but I just found the following in another newsgroup:
/****** Object: User Defined Function dbo.DaysInMonth Script Date: 03/17/04 11:47:31 AM ******/
CREATE FUNCTION DaysInMonth
(@day INT, @yr INT, @mon INT)
March 17, 2004 at 11:14 am
March 15, 2004 at 8:20 am
That seems so cumbersome. This means that if the formula for subtotal1 changes, then I have to change the formula for grandtotal also. Why is something that was so easy...
March 9, 2004 at 11:47 am
Yes, it is a brand new computer with W2K sp4, SQL2k sp3 and all of the security patches etc.
March 5, 2004 at 3:09 am
The data is dumped in this format from the corporate financial mainframe system. I am creating a datawarehouse for reporting purposes and trying to decide how much effort we should put into...
February 26, 2004 at 4:08 pm
Steve, thanks for the quick answer, how come you prefer the option that does not use dynamic sql? I used dynamic sql alot in MS Access and would like to...
February 26, 2004 at 4:03 pm
Sorry that I did not make myself clear. What I would like to be able to see, is the descriptions for all of the tables when the Table folder is...
February 20, 2004 at 12:07 pm
Thanks for the tip, but that was not the problem. I discovered that for some unknown reason the .tql files were compressed and therefore did not show up in the...
February 20, 2004 at 7:59 am
You can connect your Access database to the SQL Server, create a query based on the SQL tables or views, then convert the query to a Make Table query, run...
February 17, 2004 at 7:10 pm