manohar (4/24/2009)

---

Hi Lynn..

Will it be extra overhead if I create indexes on temporary tables..??

As that procedure will be frequently used ..... Temporary table will be created and deleted,. Indexes will...

Jeff Moden (4/24/2009)

---

Lynn Pettis (4/24/2009)

---

Jeff, Do you have access to SQL Server 2008? At the SSWUGvConference I heard the the ORDER BY "may be" honored again in the UPDATE...

Jeff, Do you have access to SQL Server 2008? At the SSWUGvConference I heard the the ORDER BY "may be" honored again in the UPDATE statement. I don't...

As this is done inside a stored procedure, I'd drop using a table variable and use a temporary table instead. If there are a large number of records in...

Be sure to post your final solution. It may help others with a similar issue/problem.

Bob Hovious (4/23/2009)

---

I can think of a poster child. I'll bet Lynn can too.

Bob, how about: SQL 2008, the sequel?...

I'd look at setting up a test DB here at work on our development server if everything could be put into a consolidated zip file. The server I have...

Click on the post # of the post. You can get a url like: http://www.sqlservercentral.com/Forums/FindPost702820.aspx. That one happens to be to you post asking how to it.

I'm also looking for the test data as well.

Is there a specific post where I can find the SQL to setup a test suite?

What Lowell is talking about is using the view to update the underlying table. You can learn more about updateable views in Books Online. If your view meets...

Goldie Graber (4/22/2009)

---

Lynn Pettis (4/21/2009)

---

That is the problem. For the "quirky update" to work you need...

No setup code, just my code. I am including the code for both user-defined functions as well.

/****** Object: UserDefinedFunction [dbo].[ufn_Tally2] Script Date: 04/22/2009 08:02:45 ******/

SET...

Here is the sample data.

INSERT INTO dbo.BackgroundViews

SELECT '1/8/09 9:18:01',46636,17,15,8,'222.127.161.230'

UNION ALL

SELECT '1/8/09 9:18:02',46636,17,15,8,'82.109.68.165'

UNION ALL

SELECT '1/8/09 9:18:03',46636,17,15,8,'136.229.5.44'

UNION ALL

SELECT '1/8/09 9:18:04',46636,17,15,8,'62.2.187.21'

UNION ALL

SELECT '1/8/09 9:18:05',46636,17,15,8,'86.96.227.88'

UNION ALL

SELECT '1/8/09 9:18:06',23452,17,15,8,'86.96.228.86'

UNION ALL

SELECT '1/8/09 9:19:07',23452,17,15,8,'86.96.228.86'

UNION ALL

SELECT '1/8/09 9:18:08',46636,17,15,8,'202.79.203.51'

UNION...

real (4/21/2009)

---

It's something like this

Declare @price decimal(10,2)

SET @price = price_01 FROM prices

SET @rebate = rebate_01 FROM rebates

SET @shipping = shipping_01 FROM Shipping

With "hundred" of formulas.

.

.

.

As you can see, only the...