TSQL Archives | Joshua Doodnauth

Joshua Doodnauth

TSQL

Development Programming SQL

SCOPE_IDENTITY not returning value

Very simple problem, about an hour of my time wasted. So I thought to save others. SCOPE_IDENTITY not returning value I have a stored procedure…

<img alt='Joshua Doodnauth' data-srcset='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=140&d=mm&r=g 2x' height=70 width=70 decoding=async data-src='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=70&d=mm&r=g' class='avatar avatar-70 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=='><noscript><img alt='Joshua Doodnauth' src='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=70&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=140&d=mm&r=g 2x' class='avatar avatar-70 photo' height=70 width=70 decoding=async>

Joshua DoodnauthNovember 22, 2011

Access to SQL Server

How-to Programming SQL

Moving Access to SQL Server – Pivots

While moving some MS Access Queries to a SQL Server View, I realized that SQL Server handles pivots quite differently than Access. Unfortunately in SQL…

<img alt='Joshua Doodnauth' data-srcset='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=140&d=mm&r=g 2x' height=70 width=70 decoding=async data-src='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=70&d=mm&r=g' class='avatar avatar-70 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=='><noscript><img alt='Joshua Doodnauth' src='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=70&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=140&d=mm&r=g 2x' class='avatar avatar-70 photo' height=70 width=70 decoding=async>

Joshua DoodnauthApril 6, 2011

Access to SQL Server

Development Programming SQL

Using IIf in TSQL

Using IIF in Access I am currently moving a client from an Access DB to MS SQL Server 2008, and came up to a problem…

<img alt='Joshua Doodnauth' data-srcset='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=140&d=mm&r=g 2x' height=70 width=70 decoding=async data-src='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=70&d=mm&r=g' class='avatar avatar-70 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=='><noscript><img alt='Joshua Doodnauth' src='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=70&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/29870f350673943fff44f6a326d347a0?s=140&d=mm&r=g 2x' class='avatar avatar-70 photo' height=70 width=70 decoding=async>

Joshua DoodnauthMarch 9, 2011