Viewing 15 posts - 46 through 60 (of 61 total)
Ok, did that and it took the initial message out now I have this error
Msg 8156, Level 16, State 1, Line 1
The column 'cxa_adr_key' was specified multiple times for 'A'.
April 7, 2009 at 11:37 am
Sorry everyone I figured this out, It was the conversion of the date time but I have it working.
January 20, 2009 at 7:12 pm
Thank you all, Worked out great, thank you again
April 16, 2008 at 11:09 am
excellent, thank you for the advise, I will try that, I didn't want to create a temp table and then drop it, we will only be running this file a...
January 1, 2008 at 1:26 pm
I think I have it, It has to be a Right Outer Join on CO_customer table in order for it to work.
SELECT SUBSTRING(co_customer.cst_id, 4, 6)...
October 29, 2007 at 10:35 am
Ok, let me go back to original question. Here is what I need
I need to find all customers who have a license to print the license date if it...
October 29, 2007 at 10:28 am
Here is the result I am getting, I had the original part of is not null in there
Conversion failed when converting datetime from character string
October 29, 2007 at 10:09 am
it's a view that's created on 4 tables in the database
October 9, 2007 at 2:18 pm
Yeah, I have already tried that one. It doesn't show the 5th record but rather combines the user to the Parent, I need to have the fifth record...
October 9, 2007 at 2:04 pm
I am not seeing where the math is at. That looks like it will give me a value of X80 , etc but how do I take that number and...
August 3, 2007 at 12:23 pm
Tried it I am still just pulling the 2006 dates. any thoughts
July 27, 2007 at 12:29 pm
Thank you very much Lynn and Michael. It worked perfectly. Kudo's to both
July 18, 2007 at 2:12 pm
Yes, thank you for that, I usually forget about the indexing stuff and we are in a extreme crunch on these reports. I really appreciate the input. Great communication on...
July 2, 2007 at 12:38 pm
well I got further, I didn't need a datediff, just needed the following
......
Where crt_expiration_date - getdate() < 30
that did the trick
June 30, 2007 at 4:55 pm
Viewing 15 posts - 46 through 60 (of 61 total)