ghanshyam.kundu (7/11/2011)

---

u can use while loop instead of cursors, as cursors are always costlier.

use a temporary table get all the values to temporary table process one by one using variable.

...

Did you try a Google search? It seems like there are quite some articles out there....

Something like this?

;with cte as

(

select *,

historyid - row_number() over(partition by letterNo order by historyid) row

from #Test

),

order_grps as

(

select row, row_number() over(order by min(historyid))-1 as row2 from cte group by...

Would you please be a little more specific?

I brought it down to 1.20 E-31 by using 1073.64324602427796965698515822583333 for the loan_pmt (don't ask where I got that number from 🙂 ).

I think the major issue is the lost...

Can you provide a short test scenario (table def for the import table and the target tables including a few rows in each table) so we have something to work...

It depends.

Is all the business logic implemented inside SQL Server (using stored procedures, views, functions and the like)?

If so, you could analyze the object definitions:

SELECT DISTINCT so.name, so.[object_id], so.type

FROM...

@Jeffery:

Do you have any source available for that statement?

Have a look at this link[/url]. there seems to be a significant performance...

Jeffrey Williams-493691 (7/9/2011)

---

In addition to all of the advice given so far - you really need to look at how you are using those functions. Scalar functions are notoriously...

Here's what I would do:

Step 1: fix the data type used in / returned by the functions involved (e.g. [fnsFormatAkcesit] will never exceed 17 byte, therefore the data type for...

I just tried to connect from Excel 2007 to a view in SQL 2005. It worked without any issues.

Maybe the connection you're using to from Excel doesn't have permission to...

If I would have to stop on a highway (or Autobahn as we call it over here) other than because of a traffic jam, I'd immediately run and jump behind...

As you noticed, SQLServerCentral (or SSC) is slightly different than most of the other db forums. It's more a community, not just a forum. Therefore, we prefer to clarify an...

Where exactly do you get stuck?

The concept I would use is to call a stored procedure with the parameter Comp_Name, KPI_name, date and value. You'd need to make sure Comp_Name...