Viewing 15 posts - 661 through 675 (of 859 total)
ok know how im attacking it. have to boot up my other machine to get every thing coded preaty and tested.
April 6, 2012 at 7:11 am
in general. sub selects have to be executed first or for each row depending on the case and then joined to the outer query. a join is executed...
April 5, 2012 at 10:18 pm
piotrka (4/5/2012)
April 5, 2012 at 10:11 pm
Jeff Moden (4/5/2012)
April 5, 2012 at 6:15 pm
I would take a slightly different approach
--DECLARE @FromAge -- get this from your app
--DECLARE @ToAge -- get this from your app to i like...
April 5, 2012 at 5:51 pm
CREATE TABLE #Tbl_PATIENT_ADM (
ADT_SOURCE VARCHAR(30),
PATIENT_NUM VARCHAR(20),
PATIENT_NURSESTATION VARCHAR(10),
REGISTER_DTIME DATETIME
)
INSERT INTO #Tbl_PATIENT_ADM
SELECT 'Register','54689','260', '12/30/11 9:37'
UNION
SELECT 'OutPatToInPat', '54689', '6S', '12/30/11 22:34'
...
April 5, 2012 at 5:34 pm
Lynn Pettis (4/5/2012)
Lowell (4/5/2012)
Welsh Corgi (4/5/2012)
Hey yeah your right, thanks.
Whatever happened to your Dog Avatar? I liked it. What model is that Gas:-) Mask? I did not see that one...
April 5, 2012 at 4:49 pm
Jeff Moden (4/5/2012)
sharky (4/4/2012)
April 5, 2012 at 4:43 pm
SQLRNNR (4/5/2012)
The Dixie Flatline (4/5/2012)
SQLRNNR (4/5/2012)
Brandie Tarvin (4/5/2012)
Lynn Pettis (4/5/2012)
Oh well, no bomb. Back to work.Was it Twinkies?
Strawberry flavored with a touch more fiber than normal.
Save some for supplies...
April 5, 2012 at 4:39 pm
mohammed moinudheen (4/5/2012)
We found it. This account was a member of two other groups which had DBO on the database.
glad you found the user.
April 5, 2012 at 12:13 pm
Sean Lange (4/5/2012)
Eugene Elutin (4/5/2012)
Sean Lange (4/4/2012)
You have to either use a datetime variable or put your string representation inside single quotes.
select * from TICKET where createDate > '4/1/2012'
Is it...
April 5, 2012 at 8:14 am
mohammed moinudheen (4/4/2012)
and to the OP if he had not considered SQL Server authentication.)
No, not yet.
with sql authentication you dont have the nasty problem of elevated access levels inherited from...
April 5, 2012 at 8:06 am
there are 3 ways to do this. the best depends on what exactly you are trying to get from server 2.
1. add server 2 as a linked server on...
April 5, 2012 at 7:44 am
SQLRNNR (4/4/2012)
Lynn Pettis (4/4/2012)
SQLRNNR (4/4/2012)
GilaMonster (4/4/2012)
Who feels like doing the impossible? http://www.sqlservercentral.com/Forums/Topic1278455-391-1.aspxA lot of attitude on that one.
Well, apparently we can't accept the restrictions he has to work under on...
April 4, 2012 at 10:19 pm
ColdCoffee (4/4/2012)
Aw no!!! Dont concatenate values into a single column. Normalize and seperate them out as columns which will save u time and money!
+1. you are seeing why normalizing...
April 4, 2012 at 6:28 pm
Viewing 15 posts - 661 through 675 (of 859 total)