Viewing 15 posts - 91 through 105 (of 152 total)
I'd have to say, with all due respect to the various posters before me, that being a Senior DBA is not a matter of whether you use the GUI or...
October 27, 2010 at 3:37 pm
So long as we can stay away from the sensationalist approach to all of this and hold a rational discussion then I'm fine.
But this does put me in mind of...
October 13, 2010 at 3:46 pm
As far as I understood is that the situation was somewhat different to the headline and Ed Bott's article on ZDNet (which is one of the rebuttal articles linked on...
October 13, 2010 at 12:58 am
Of course with SQL 2008 you can change the two inline sub-selects to CTEs for pure readability.
That would also get the effect of almost creating two tables, as various other...
October 12, 2010 at 12:55 am
Chuck Norris does not act.
We all try to act like Chuck.
September 22, 2010 at 5:07 pm
I think that this revolves around the concept that His Chuckness can do anything... even the impossible.
I would guess that the original poster is having issues with SQL on a...
September 22, 2010 at 5:03 pm
Hmm - According to the documentation here http://msdn.microsoft.com/en-us/library/ms345137(SQL.90).aspx that should have worked.
Just checking. Which version of SQL are you using?
September 15, 2010 at 4:22 pm
Nice use of REPLACE... shoulda thought of that!
September 14, 2010 at 4:39 pm
Nakul Vachhrajani (9/14/2010)
DECLARE @MyTable TABLE (MyNumericVal VARCHAR(100))
INSERT INTO @MyTable VALUES ('50.10-'),
...
September 14, 2010 at 1:38 am
For what its worth ... Hopefully it adds some flexibility
DECLARE @l_CharVal VARCHAR(20)
SET @l_CharVal = ' 50.12- '
SELECT
CASE
WHEN...
September 14, 2010 at 1:25 am
edit: ignore me, I need to read the whole thread - not just the 1st page!
September 13, 2010 at 10:43 pm
I'll second Gail on this!
RedGate tools fill a neat gap in the Visual Studio / SSMS world.
September 13, 2010 at 6:26 pm
Try taking a look at the PATH and ROOT options in the FOR XML clause.
You should be able to do this in a single select statement rather than 3...
September 13, 2010 at 6:16 pm
There are a couple of ways you can do this.
1. BCP the data out of one system into the other
2. Use Microsoft's import tool (which will let you work across...
September 13, 2010 at 5:45 pm
I'm generally in favour of this idea, especially for the small to mid size businesses that don't necessarily need a full time dba or systems admin. And yes, you will...
September 2, 2010 at 9:50 pm
Viewing 15 posts - 91 through 105 (of 152 total)