Viewing 15 posts - 6,496 through 6,510 (of 14,953 total)
These scenarios don't sound like disasters to me. They sound like challenges that would be fun at best and interesting at worst.
Games have a goal (or multiple goals), barriers,...
October 18, 2010 at 11:37 am
Where you have "[VALUE]" in your Select statement, put "round([VALUE], 3) as RoundedValue". Change the rounding digit as needed (I picked 3 arbitrarily), and change the column alias to...
October 18, 2010 at 11:21 am
By "IT SHOULD HAVE A HEADER", do you mean a row at the top that just says, "IT" (or whatever)? Does it also get column headers?
There are easy ways...
October 18, 2010 at 11:17 am
The complexity will depend on the magnitude of the changes.
October 18, 2010 at 11:14 am
I did that in SQL 2000, so it's not new.
It's a performance killer, but it's not a new one.
This kind of thing is one of the valid reasons to use...
October 18, 2010 at 11:13 am
Copy-and-paste the When...Then statements into Management Studio.
Ctrl+H (Search-and-Replace) for "when", replace with "union all select".
Ctrl+H (Search-and-Replace) for "then", replace with ",".
Delete the first "union all", leaving the whole thing starting...
October 18, 2010 at 11:11 am
To add to SQL Bill's point, nobody is going to put "Junior DBA, 10 years" on their resume, even if that was their job title that whole time.
October 18, 2010 at 11:07 am
jaffrey (10/16/2010)
October 18, 2010 at 11:04 am
Key/Value is how I've done that.
Using the SQLVariant datatype might help, or might not, but is worth looking at. But really, converting a few values from varchar to int...
October 18, 2010 at 10:54 am
As an addendum, don't use SSMS's GUI to redesign tables. It often has to create a temp table with the new structure, insert all the data into that, drop...
October 18, 2010 at 10:50 am
Nvarchar can go up to 4,000 explicitly, or to "max" (as long as you're on SQL 2005 or later), which allows for a LOT of characters.
So long as your varchar...
October 18, 2010 at 10:47 am
What's the purpose of the split? Can one "pre" have more than one "post" for a given "item", or vice versa?
October 18, 2010 at 10:41 am
Can you rename the existing column, create a new column of the type and size you want, populate from the old (renamed) column to the new column, and then validate...
October 18, 2010 at 10:39 am
You might be able to do something with a DDL trigger, but I'm not sure. Check that out as a possibility.
Why not just use password policies? That's the...
October 18, 2010 at 10:37 am
Viewing 15 posts - 6,496 through 6,510 (of 14,953 total)