the pseudo code doesn't cut it for this one, i think. We'd need to see the actual statement you are executing, that is raising the error, so we can really...

Horrible example, Celko; all it proves is the row used to to update the parent table is not guaranteed unless you make sure the joins form a 1:1; That's SQL...

adding the same WHERE statement for the ORDERPK to each of the CTE's might speed things up also; you be filtering to jsut the rows for the order in...

you've got a few things killing you, without the actual execution plan , these are jsut guesses:

the WHERE statement on ORDERS is not SARG-able.

instead of doing WHERE DATEADD(dd, 0, DATEDIFF(dd,...

the beautiful part about the "proprietary" update format is the ease in which you can test to see which records are matching/ would be affected.

simply inserting "--SELECT *", and highlighting...

teh same escape method: two single quotes in a row:

For instance

Update table1

set title = 'Daddy''s Daycare'

something like this works...the important part is that two single quotes in a row is the escape sequence, so it can be contained within single quotes:

select * from yourtable where...

easy fix: once you aliased #example, you have to use that alias everywhere:

update ex -- the table that will be updated's alias.

set Status = 1

from...

yeah, it doesn't add buttons to the titlebar of a form; it just sintercepts specific keystroke command sand calls the windows API's to fiddle with the widnow size.

i found that...

you got me curious with this, and i found SecondShell

http://www.secondshell.com/

clicking ALT and mousedrag makes any window stretch in the direction of the alt+drag, and there are programmable hotkey sequences...

david.alcock (1/11/2011)

---

But you could place certain procs, not all, into a schema and assign the permissions to a role at schema level cant you?

Yes it may be painful...

i think if you create a role, you can GRANT EXECUTE TO YOURROLE, but that grants execute on all functions as well.

CREATE ROLE [ReallyReadOnly]

GRANT EXECUTE TO...

nope, it's free distributable:

The Report Viewer Control is a free control provided by Microsoft to display reports on a web page or windows form. To add the Report Viewer...

well, my two cents:

I have no problem using it for production or anywhere else. It exists in 2005,2008/R2 and Denali/V11 as well... so anything I incorporate using that would...

your data in a format anyone can use in SSMS to look at the problem properly:

SELECT '1' AS VehicleID,'Honda' AS CarName,'Smith' AS VendorName,'20' AS Quantity,'25000' AS Price UNION ALL

SELECT '1','Honda','Ross','30','20000'...