Viewing 12 posts - 271 through 282 (of 282 total)
OK nevermind I am the ultra noob...
I didn't realize I was logged into the server with a different account vs. the account that actual starts SQL server.
Once I did that I saw...
September 14, 2006 at 11:44 am
Well thanks for the posts guys. I got more information finally from my supervisor and he showed me a different direction basically with nested If statements and a temp table.
The...
September 11, 2006 at 7:59 am
OK got it figured out...basically there was a problem on the exchange end that I didn't know about.
When Outlook 2003 was installed on the server, the mailbox was also created...
July 27, 2006 at 11:39 am
Thanks for the link....I will start there...
So that second book you recommended is it for beginners ? At the moment I am not that skilled but want to learn...I will...
February 19, 2006 at 9:49 am
I will have to look into that SSIS and read up on it...thanks for the info
July 11, 2005 at 9:49 am
Thanks guys for the plentiful replies, I will take a closer look at the tomorrow when I am at work.
Thanks again,
Leeland
July 6, 2005 at 5:50 pm
Well I finally got it to work with the help of a co-worker...here is the code
previous_discharge_date = (SELECT MAX(ISNULL(referral_ref.dischargedate, '')) as previous_discharge_date
FROM
referral as referral_ref
WHERE
referral_ref.dischargedate <>'2078-12-31 00:00:00'
AND referral.memid...
April 22, 2005 at 7:57 am
so basically create a view that would pull the two fields in from the same table ?
like this
select referral.authid, referral.memid, max(referral.dischargedate) as max_date
from referral
group by referral.memid
then in my other...
April 20, 2005 at 11:12 am
Well I am sure there is a good reason that this isn't working
SELECT ISNULL(MAX(referral.dischargedate), '')
FROM
referral
HAVING
ISNULL(MAX(referral.dischargedate), '') < (SELECT ISNULL(MAX(referral_reference.dischargedate), '')
FROM referral as referral_reference
JOIN referral (NOLOCK) on...
April 20, 2005 at 10:51 am
Noel,
This puts me in the right direction...all the fields I am going to be working with come out of the same table...REFERRAL...only the memid comes from the member table.
so discharge...
April 20, 2005 at 9:33 am
SQLBill,
Thank you for the replies...I did get it to work finally within crystal. I finally found the option that allows you to convert datetime fields to just date.
Me being...
November 19, 2004 at 8:37 am
Is there a way to get it to stay as a date or datetime data type ?
The reason I ask is because I need that field in a crystal report...
November 18, 2004 at 8:49 am
Viewing 12 posts - 271 through 282 (of 282 total)