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...

That is the problem. For the "quirky update" to work you need a clustered index on...

The only change to my code that I could suggest is 1) make sure you have declared the clustered index properly, and 2) change the index hint from 0 to...

Awesome! ...

Lynn Pettis (4/20/2009)

---

Here is another attempt at solving your problem:

CREATE TABLE #CheckIn

(

CheckInID INT IDENTITY(1,1)

,UserID INT

,Comment VARCHAR(50)

)

-- insert some...

Triggers, yes,...