Viewing 15 posts - 286 through 300 (of 400 total)
You gals and guys are awesome! Thank you so much for the great mentoring and advice.
Here is what I have done with one of the other reports. I...
March 8, 2011 at 2:40 pm
Craig!
He was peeking over my shoulder as I was reading your comment, and was like "What's CREATE PROC, some sort of tool". After I laughed I shared with him...
March 7, 2011 at 2:18 pm
1. I'll do them one better and leave them in the frozen cold one morning while they are all on their way into the office! *evil grin*
2. I actually...
March 7, 2011 at 2:16 pm
Gail! Thank you so much for this clarification! I was starting to wonder if I wasn't getting bad information from some of the sources regarding FK Indexing (as...
March 7, 2011 at 1:39 pm
Ah - I see. He's also needing the same date for another admission, even though the discharge is then a different date, but still part of that group of...
March 7, 2011 at 11:12 am
That's probably not a bad way to go (may even produce a better execution plan).
Just FYI - I was able to get the result you were looking for, and I...
March 7, 2011 at 10:26 am
OK - give this a try, and let me know if it gets you closer to your desired result (I have it on my end, and it looks pretty sound)....
March 7, 2011 at 9:41 am
OK - so it's not matching admission and discharge dates, but matching admission dates (where the discharge date happened, and then another admission happened on the same date).
My bad -...
March 7, 2011 at 9:12 am
In your example, your timedate stamp is consistent. I'm guessing that this is not going to be the case with your live data. Is the issue then just needing...
March 7, 2011 at 8:47 am
select * from PS_TestForOnline
WHERE admission_date = discharge_date
March 7, 2011 at 8:10 am
Yeah, but when I prescribe that my developers not do SELECT * from their factories, it won't be hazardous to their health (unless they make me really angry by not...
March 4, 2011 at 12:50 pm
With SSIS, you generally do not want to do updates inside of the dataflow, but one well accepted technique is to create an additional table in the same database of...
March 4, 2011 at 12:34 pm
Couple of things:
1. With the SSMS crashing on the GoDaddy end, try deleting your shell folder underneath your profile for SSMS (C:\Documents and Settings\<user profile>\Application Data\Microsoft\Microsoft SQL Server\90\Tools ....
March 3, 2011 at 11:25 pm
Have you scripted out the table yet with the data? I would start there to see what the DDL looks like.
March 3, 2011 at 11:04 pm
Viewing 15 posts - 286 through 300 (of 400 total)