Viewing 10 posts - 121 through 130 (of 130 total)
nigelc (6/27/2011)case DATEPART( month, GETDATE() ) when 12 then DATEPART( year, GETDATE() )-1 else DATEPART( yyyy, GETDATE() ) end
Are you trying to get the current month and year,...
June 28, 2011 at 6:28 am
The bad syntax in your expression looks to be a misplaced :
In an SSIS expression If/Then Else statement, the Then clause follows the ? and the Else clause follows the...
June 22, 2011 at 10:26 am
You could probably drop and recreate the FK constraint with the new name.
Also take a look at http://www.sqlservercentral.com/scripts/Miscellaneous/30924/ which renames all FK constraints; but should give you some ideas for...
June 22, 2011 at 9:17 am
Good article -- I've made everyone of those mistakes many times. 🙂
I also agree that a missing parens is another common typo/error.
June 14, 2011 at 6:02 am
Excellent info! Thank you sturner and GilaMonster. I didn't realize the part about bit-index myth stemming back to SQL 2000 Enterprise Manager.
June 13, 2011 at 1:47 pm
Thank you! Thank you!! I looked at that a hundred times. I guess I just needed another pair of eyes.
May 7, 2008 at 7:26 am
FYI:
The problem seems to have been a bad UPS that the SAN for the SQL Server was attached to. Once the UPS was fixed (battery replaced), we've not had...
May 7, 2008 at 7:09 am
Many thanks Peter; that does the trick.
March 6, 2008 at 12:59 pm
The Derived Column data flow transformation seems to do the trick for me.
I use something like: ISNULL(BenefitId) ? 0 : BenefitId to replace the null in the BenefitId field in...
March 6, 2008 at 12:58 pm
Both databases are attached and live. I can exit & restart management studio, I can refresh the object browser in MS and refresh the table list, but DB2 still...
January 2, 2008 at 8:55 am
Viewing 10 posts - 121 through 130 (of 130 total)