So what is it you are actually trying to accomplish?

metalray (10/10/2008)

---

DECLARE @ColumnE As varchar(50)

DECLARE product_cursor CURSOR FOR

SELECT F2 FROM dbo.Products

FOR UPDATE OF F2

OPEN product_cursor

FETCH NEXT FROM product_cursor INTO @ColumnE

WHILE @@FETCH_STATUS...

Just make sure to remember to specify the parameter as an output parameter when you call it too. T/SQL is a little anoying that way.

I think the problem might be that the primary key is a CLUSTERED index. Since a clustered index and partitioning both relate to how the data is physically stored,...

I think the function is just hidden row by row processing, the CTE will work, you just need to join it to itself. Assuming st_no is some identifier that...

Honestly i've always avoided using SP_DEPENDS because of it's unreliability. I suppose you could try to do ALTER PROCEDURE commands of the inner stored procs then ALTER PROCEDURE commands...

Actually the subquery will probably be more logically correct. I don't know if it is possible for there to be more than one OrderDetail record for the same order...

To me it doesn't make sense to be using VARCHAR(MAX) except for items that you know won't fit into a regular VARCHAR() or are large values that won't be queried...

I've been a database professional for over 15 years now, at a variety of companies both as an in house developer and in a contractor/consultant role. The problem I've...

What the article describes as exact duplicates are definately wastefull, as they will slow your inserts and updates without being able to give you any benefit whatsoever.

The overlapping indexes will...

Probably the one advantage that MySQL does have is its modular database engine, so that if all you are using it for is a quick read only database for reporting...

Maybe I'm straying off topic a bit, but my oppinion is that it's really about reliability and robustness per price per performance. If it was just about price per...

Thanks for the information everyone. I've typically found Books Online to be good with academic knowledge but not very good on insight as to how or when to use...

OK, I guess I misunderstood. I see now what you are saying, you're right, even if I edit the one named Create Stored Procedure (New Menu) it doesn't use...

I think we might be making mountains out of molehills. I don't know what your parameters are to dbo.get_mkt_rate, but can't you just call it in a subquery, with...

The easiest way is in Management Studio, to select View > Template Explorer from the menu bar. (or press Ctrl + Alt + T) From there, pick the...