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) =...

marcelo.negrisoli (5/7/2014)

---

Hi,

I wrote a script task that´s build a SSIS Package dynamically with a Script Task.

When I open this dynamically created package, the Script Task shows with error and "the...

NOLOCK turns the database into a...

Sean Lange (5/7/2014)

---

Eirikur Eiriksson (5/7/2014)

---

george sibbald (5/7/2014)

---

river1 (5/7/2014)

---

Hi,

I would like to know in with date did a SQL Server 2005 instance was installed on a server.

Can I know This using...

computer24hr (5/7/2014)

---

Password, it should be unique to each user name.

The password is stored as nvarchar(10) it's text.

I thought the SP, what do you think?

Relatively low amount of...

computer24hr (5/7/2014)

---

hey,

I have a table of users including: UserName, Password (comuted col), FirstName, LastName, Address and other details....

I have to keep 10 Recent passwords , so I created another table...

What about dropping and recreating the constraints?

😎

BOL even slower than my memory when...