We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
UPDATE MyTable SET CCExpDate = RIGHT('00' + Left(CCExpDate,2),2) + Right('00' + Cast((Cast(Right(year(getdate()),2) as smallint) + 2) As Varchar),2) WHERE (Cast(Left(CCExpDate,2) as smallint) <= (Month(GetDate())-1) AND Cast(Right(CCExpDate,2) as smallint) <= Cast(Right(Year(GetDate()),2) as Smallint) OR Cast(Right(CCExpDate,2) as smallint) < Cast(Right(Year(GetDate()),2) as Smallint) ) AND CCNo like '387845635%'
|Passing value to a stored procedure||8||110|
|SQL Query with Sum and Detail rows||2||62|
|Are triggers slow?||7||22|
|Why is this SQL bringing back extra rows? (parsing XML data)||4||32|