This is the simplest way

😎

[User]-|---0<[UserRole]>0---|-[Role]

Thomas Abraham (5/8/2014)

---

If you look at a QWERTY keyboard, you'll see this is a splendid example of the well known "off by one" error....

Favourites are 21-24-21 and 24-24, basically monitor count > 1 will do though.

😎

To get you started

😎

Sample data

USE tempdb;

GO

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'TBL_STOREDPROC_001' AND TABLE_SCHEMA = N'dbo')

DROP TABLE dbo.TBL_STOREDPROC_001;

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES...

danielfountain (5/8/2014)

---

Hi all,

I am using a cursor (i know - but this is actually something that is a procedural loop).

So effectively i have a table of names of stored procedures....

Thanks for the question, made me go have a look when I couldn't see the correct answer listed, hoping it might have changed:-D

😎

azmiman (5/8/2014)

---

Eirikur Eiriksson (5/8/2014)

---

First, few questions:

1. Will you ever have to list more than one type in the same result set?

2. Will you be adding new types?

3....

First, few questions:

1. Will you ever have to list more than one type in the same result set?

2. Will you be adding new types?

3. Is there a...

Do you mean: retrieve for each patient, identified by the patno, all records which have...

Neither does it match the information contained within the requirements.

😎

rhythmk (5/7/2014)

---

Can you please elaborate with more clarity as I am confused with...

Something along these lines could do

😎

DECLARE @PATIENT TABLE

(

patnt_no INT NOT NULL

,patnt_refno INT...

When you run it in BIDS, it is compiled before the execution, which is the step missing. I'll look into this when I can and will let you know.

😎

If I remember correctly, you'll have an upgrade grace period, you could install a new instance on the/a box, run the two in parallel for that period while migrating the...

I normally prefer to script the creation of all constraints and use something like this procedure to drop them when needed

😎

CREATE PROCEDURE [dbo].[DROP_SCHEMA_CONSTRAINTS]

(

@TABLE_SCHEMANVARCHAR(128)

)

AS

/*

DECLARE @TABLE_SCHEMANVARCHAR(128) = N'myschema'

EXEC dbo.DROP_SCHEMA_CONSTRAINTS @TABLE_SCHEMA

*/

DECLARE @SQL_STRNVARCHAR(MAX) =...