Viewing 15 posts - 3,646 through 3,660 (of 5,685 total)
HIPAA, under most circumstances, hit me harder then SOX. SOX mostly forced change control into existence for the cowboy shops. It's been taken to rediculous extremes on occassion,...
March 18, 2011 at 4:13 am
Jeff Moden (3/17/2011)
David Burrows (3/17/2011)
Koen Verbeeck (3/17/2011)
Jeff, stop interfering in SSIS threads. 😛 😀
Ahhh!!! Be nice to Jeff, he can't help it if he is stuck in a T-SQL sandbox...
March 18, 2011 at 4:10 am
leon.booij (3/18/2011)
I want to convert a varchar column to a numeric(9,2) columnbut the vachar column has also negative values
ColumnA
1.450,40
142,07
83,71-
So, you're expecting to see:
1.450,40
142,07
-83,71
?
That's not going...
March 18, 2011 at 4:07 am
Eric, Rahuzz above is on the money for your solution here. Let us know if you run into problems with that solution. If you do, please post the...
March 18, 2011 at 4:06 am
Ian is correct that it's tough to decipher your issue from this end with the description, however...
Your code needs to confirm there is a second underscore in the string before...
March 18, 2011 at 4:04 am
Hey JJ,
Sorry it's late and I'm glad you found your solution.
What we were trying to get out of you was something like this, which if you'd read the article end...
March 18, 2011 at 3:59 am
The cure is because an xml specific column will index itself internally, and I don't have all the rules handy.
Can you doublecheck your laptop and the server engine you're running...
March 18, 2011 at 3:56 am
Ahhh, sorry San, I misread it on the first pass. Have to bear with me, it's ~3AM here, after a day in America celebrated by much alcoholic intake. 😀
I've...
March 18, 2011 at 3:52 am
Leon, what you wrote in SQL and what you see makes sense to me.
What do you WANT to see for those items?
March 18, 2011 at 3:46 am
Just to add to Jim's recommendation, google is your friend here.
T-SQL tutorial in google will resolve a number of possibilities.
Two quick ones (I don't know their worth, but anything will...
March 18, 2011 at 3:36 am
Jim McLeod (3/17/2011)
george sibbald (3/17/2011)
rollback -dbcc shrinkfile with the emptyfile option, followed by alter database command to remove the file.
That would work (and was my first thought too), but I...
March 18, 2011 at 3:33 am
alexus8888 (3/18/2011)
March 18, 2011 at 3:29 am
San, this doesn't make sense from this side. If you're selecting email_1, email_2 ... that sounds like different columns, yet you state it's one column.
can you right-click, script the...
March 18, 2011 at 3:26 am
Rem70Rem (3/17/2011)
What are the steps to rollback if needed?
Generate a new filegroup, move *everything* into the new filegroup. Rebuild the original Primary as desired, move everything back, and remove...
March 17, 2011 at 4:17 pm
george sibbald (3/17/2011)
don't quite understand why myself, but as disk technology moves forward old truths can become outdated.
I still would not recommend it as a default approach to file layout,...
March 17, 2011 at 4:12 pm
Viewing 15 posts - 3,646 through 3,660 (of 5,685 total)