Viewing 15 posts - 466 through 480 (of 3,232 total)
Chris Morris-439714 (5/21/2010)
John Rowan (5/20/2010)
I have 5 kids under the age of 10I reckon we should all club together and buy John a telly.
Tellly?
May 21, 2010 at 8:24 am
Chris Morris-439714 (5/20/2010)
John Rowan (5/20/2010)
sing4you (5/20/2010)
Not pregnant 😀Congrats! I'm happy for you too.
Oh John...I always thought you were one of us good guys...
I have 5 kids under the age...
May 20, 2010 at 11:30 am
sing4you (5/20/2010)
Not pregnant 😀
Congrats! I'm happy for you too.
May 20, 2010 at 9:46 am
Chris Morris-439714 (5/19/2010)
Pregnant
Contrats Chris! I'm happy for you.
May 19, 2010 at 11:15 am
Thanks Nice and Paul. Creating that view for them really gave me some flexibility for future design decisions. I was at a company where the developers and analysts...
May 19, 2010 at 11:12 am
This still leaves you with a poorly coded trigger. I would recommend fixing the trigger code as well. This is a common, but unfortunate, mistake in trigger coding....
May 18, 2010 at 12:22 pm
We had some folks that were pushing pretty hard for this type of design at a company that I used to work for. I had the final design say-so...
May 18, 2010 at 10:20 am
Your query looks fine to me. Are you sure it is comming from this query? Is there maybe another query near this one that could be causing the...
May 17, 2010 at 4:37 pm
@Chardates is a table variable that will only be used at the time of the query to find the invalid dates. It will not need to be maintained.
Is this...
May 17, 2010 at 3:44 pm
rjv_rnjn (5/17/2010)
I would suggest trying this (on a separate set of data first)
update TestTable set myDate = convert(varchar(20), getdate()-3,101)where myDate <= '01/01/1753'
This will not work. Your <= comparison...
May 17, 2010 at 3:36 pm
I would build out a dates table with character dates and then JOIN that back to your table to find date value that are out of range. You can...
May 17, 2010 at 3:23 pm
The error you are getting is due to the CONVERT statement. The conversion results in an invalid date, hence the error.
The best way to prevent this is...
May 17, 2010 at 3:04 pm
This is a widely debated topic. Here's a good link to reference. There's a link within that thread to a good article on the topic, but the thread...
May 17, 2010 at 2:39 pm
You could use a Lookup Transformation for this. Set the Lookup Transformation so that the lookup sucess (green arrow) does not go anywhere after the lookup and the failure...
May 17, 2010 at 10:12 am
Viewing 15 posts - 466 through 480 (of 3,232 total)