Evening Guys,

(1) Are there negative effects of having multiple stored procs wrapped in an outer/master proc?

(2) Will the inner procs that are executed all be run as one...

Shifting gears to the code itself, it's pretty much a both a resource and performance nightmare.  It makes one full pass of either the CI or an NCI for...

Deadlocks would be one of the main ones, I would think.

This query or one just like it seems to come up a lot.  But I still don't know if there's enough demand for, say, a full article on it.  It's...

I asked because many people are happy with code as long as it ultimately does what they need it to do, i.e. "the code's good enough for me."  In that...

What are you asking why instead of posting a link to...

Hi,

I get the object id, it stopped working when I updated the management studio, i think it is not the code, but rather a new thing...

Btw, why are you using such an inefficient method, checking the column values one by one?

Please do some research and look up the E you rules for triangulation. This means that you have to convert from currency A to Euros, then from Euros to currency...

Is it possible that OPERATION is a view (or synonym) and not a table?

Did you run the SELECT by itself to make sure you get results from that?

SELECT c.name 
FROM sys.tables t 
JOIN sys.columns c ON t.object_id = c.object_id
WHERE t.name...

I think this is a form of Gaps and Islands (term coined by Itzik Ben-Gan?  maybe?).  It's rather traditional in G&I to use the name "grp", so I stuck with...

Yes, only 1 OUTPUT clause.  My best suggestion is to use CASE for every column.  You can generate the CASE statements from the table definition so you don't have to...

Just now noticed the Postgre sql qualification.  I answered for SQL Server; code may or may not work on Postgre.

For (1):

SELECT GUEST.GUESTID 
FROM GUEST
WHERE GUEST.GUESTNAME='John %' /*space added because don't want name 'Johnathan' or 'Johnny'*/ AND
    EXISTS(SELECT 1 FROM BOOKING WHERE BOOKING.GUESTID=GUEST.GUESTID AND...