tag:blogger.com,1999:blog-8930349235661427759.post8931311291787970603..comments2024-03-28T09:17:24.304+01:00Comments on Keep It Simple and Fast: Argument data type nvarchar is invalid for argument 2 of dateadd function.André van de Graafhttp://www.blogger.com/profile/07230010757193182052noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8930349235661427759.post-76353098514255374102014-03-06T16:57:50.614+01:002014-03-06T16:57:50.614+01:00Just as I was about to lose the rest of my recedin...Just as I was about to lose the rest of my receding hairline I found this with the answer. Thanks for posting. Peterhttps://www.blogger.com/profile/14368709278758244142noreply@blogger.comtag:blogger.com,1999:blog-8930349235661427759.post-27855855893709422252013-09-20T20:38:34.538+02:002013-09-20T20:38:34.538+02:00I used this for converting phone numbers to (###) ...I used this for converting phone numbers to (###) ###-#### but needed to use bigint in order to avoid overflow.<br /><br />format(cast(p.PhoneNumber as bigint), '(###) ###-####') as PhoneNumberAnonymoushttps://www.blogger.com/profile/13439735500127880939noreply@blogger.comtag:blogger.com,1999:blog-8930349235661427759.post-44925294661537451712013-06-30T20:26:53.176+02:002013-06-30T20:26:53.176+02:00This comment has been removed by the author.Hakanhttps://www.blogger.com/profile/12806975712295710359noreply@blogger.comtag:blogger.com,1999:blog-8930349235661427759.post-70756808720343191092013-06-30T20:13:51.336+02:002013-06-30T20:13:51.336+02:00thank's a lot for shared.thank's a lot for shared.Hakanhttps://www.blogger.com/profile/12806975712295710359noreply@blogger.comtag:blogger.com,1999:blog-8930349235661427759.post-16323671818320627562012-03-18T05:00:43.449+01:002012-03-18T05:00:43.449+01:00Thanks a lot - just saved me some valuable time!Thanks a lot - just saved me some valuable time!Anders Vhttps://www.blogger.com/profile/09550372780784699077noreply@blogger.com