SEO

#1 (**permalink**) 02-29-2008, 06:42 PM

This is a very general quastion.....

I regularily take data extracts from a SQL server database drop them in
excel and run a macro on the data.

The macro does nothing more complicated than loops, addition,
subtraction and remeber the changing value of a declared variable.
It works perfectly, but is constrained by the number of rows in excel.

I want to investigate the possibilty doing the calculations in the SQL
tables. (All the data is contained within one table).

What is the best way to approach this problem.
i.e. can I get my excel macro to link to the Table and if not, what
other solutions are avialable to me.

Regards,
Ciarán

#2 (**permalink**) 02-29-2008, 06:42 PM

T-SQL is essentially a standard 3rd generation language (with some
limitations, obviously), so if you can do it in Excel, you can probably
do it in a T-SQL procedure, all in one place without having to transfer
and re-load the data.

JG

#3 (**permalink**) 02-29-2008, 06:43 PM

Thank you

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

General Question about doing calculations in SQL