You're taking my examples a little too literally, they generally don't apply to my world either.

I was simply explaining that there are many circumstances out there, not just for the...

Dave Ballantyne (10/20/2009)

---

Personally , i think its pretty shoddy design that you are trying...

Thanks Grass.. I know there are a number of ways to "fix" this, one of which would be to check the objects exist and manually raise errors if they don't....

That would take us to the CATCH statement rather than the code in your IF block.

(tested it just to be sure)

Also, it DOES execute the inner SP hence my conundrum....

I'm already capturing the error in the outer SP (even though I don't want to), so checking @@Error after the EXEC will be pretty much the same won't it?

The inner...

Oh, you mean it won't work once it goes past a single day booking 🙂

Could you give this a try?

-- Get duplicate bookings

-- nb. If at least one duplicate...

My code should cater for time as well, but I have to admit I haven't tested it.

i.e. 17:00-18:00 on the 13/08/2009 is not between 10:00 13/08/2009 - 16:00 13/08/2009 even...

I'm just curious (and a tad concerned) but is this for a live app or a uni project or something?

Because honestly, I have no idea why you'd take the approach...

I know this has been solved but there's always more than one way to skin a cat and I need to keep my SQL skills up to date.

So here's my...

Using this test data:

INSERT INTO TAB

SELECT 'ABC',24,'M'

INSERT INTO TAB

SELECT 'ABC',24,'M'

INSERT INTO TAB

SELECT 'DEF',24,'M'

INSERT INTO TAB

SELECT 'DEF',24,'F'

INSERT INTO TAB

SELECT 'GHI',26,'F'

INSERT INTO TAB

SELECT 'GHI',26,'F'

INSERT INTO TAB

SELECT 'GHI',26,'F'

INSERT INTO TAB

SELECT 'GHI',26,'F'

INSERT INTO TAB

SELECT...

Wasn't TAB in Barry's also an intermediate table?

I could probably write it to use just one table.. but it'd be messy and got a day job..

OK Assuming your rows are unique only when all three rows match (this includes gender), this should work..

DECLARE @testing TABLE

(

FirstColvarChar(5),

SecondColINT,

ThirdColChar(1)

)

INSERT INTO @testing

SELECT 'ABC',24,'M'

INSERT INTO

vish (6/19/2008)

---

Hi All,

Let me give my problem description in detail.

I use SQL server 2000.

I have a table 'TAB' with 3 coulumns 'Name','Age','Sex'

and there is no primary key.

I have multiple duplicate...

Nice. I should really look into the system tables at some point..

Probably no different to calling sp_SapceUsed in your own cursor though?

Anyway I was just challenging myself to see if I...