Viewing 15 posts - 8,326 through 8,340 (of 8,760 total)
vasugunda (5/7/2014)
i just want retrieve patient information from 1st discharge date to 6 months later date.
Do you mean: retrieve for each patient, identified by the patno, all records which have...
May 8, 2014 at 1:02 am
rhythmk (5/7/2014)
However if you match none of your resultset matches with OP's resultset 🙂
Neither does it match the information contained within the requirements.
😎
May 8, 2014 at 12:42 am
rhythmk (5/7/2014)
vasugunda (5/7/2014)
Hi everyone..i just want retrieve patient information from 1st discharge date to 6 months later date .
Can you please elaborate with more clarity as I am confused with...
May 7, 2014 at 11:41 pm
Something along these lines could do
😎
DECLARE @PATIENT TABLE
(
patnt_no INT NOT NULL
,patnt_refno INT...
May 7, 2014 at 10:10 pm
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.
😎
May 7, 2014 at 3:14 pm
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...
May 7, 2014 at 2:51 pm
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) =...
May 7, 2014 at 2:44 pm
marcelo.negrisoli (5/7/2014)
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...
May 7, 2014 at 2:32 pm
Sean Lange (5/7/2014)
I never use either of them and they tend to cause lots of issues for people who don't fully understand what they do.
NOLOCK turns the database into a...
May 7, 2014 at 2:23 pm
Sean Lange (5/7/2014)
Eirikur Eiriksson (5/7/2014)
george sibbald (5/7/2014)
river1 (5/7/2014)
I would like to know in with date did a SQL Server 2005 instance was installed on a server.
Can I know This using...
May 7, 2014 at 2:04 pm
computer24hr (5/7/2014)
The password is stored as nvarchar(10) it's text.
I thought the SP, what do you think?
Relatively low amount of...
May 7, 2014 at 1:01 pm
computer24hr (5/7/2014)
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...
May 7, 2014 at 12:25 pm
What about dropping and recreating the constraints?
😎
May 7, 2014 at 11:02 am
Sean Lange (5/7/2014)
Eirikur Eiriksson (5/7/2014)
My memory playing tricks on me:-PThanks Sean!
😎
I lost my memory long ago...thank {insert your supreme being here} for BOL. 😀
BOL even slower than my memory when...
May 7, 2014 at 10:57 am
Viewing 15 posts - 8,326 through 8,340 (of 8,760 total)