Viewing 15 posts - 7,201 through 7,215 (of 9,725 total)
Glad I could help. Please let us know if you have any additional questions.
October 18, 2010 at 5:50 am
I assume this is in SSIS? You're using the Script Transformation Editor?
What exactly does your input and output data look like (examples, please)? Are you pulling from SQL Server or...
October 18, 2010 at 5:35 am
Aha. There are similarities in this code for what I did as an article today. Using spaces to alter character case. In this situation, though, I'd advise looking at the...
October 18, 2010 at 5:25 am
sqldba_icon (10/15/2010)
hmm.. i don't completely agree."Unless the text is over 8,000 bytes at which point it behaves like an NTEXT and stores the text value in the LOB".
You don't completely...
October 18, 2010 at 5:22 am
You need to follow both Gail's and Jeff's advice. You can embed a REPLACE inside of a CONVERT to fix the hypen problem, then switch that column to datetime or...
October 18, 2010 at 5:16 am
Sounds like you need to use some ANSI searches to find those. What's your collation set as, BTW?
October 18, 2010 at 5:13 am
I know nothing about Avast, but if you want a separate named instance on your server for the Avast DB, that's perfectly okay.
Yes, you need the install disks or...
October 18, 2010 at 5:09 am
WayneS (10/16/2010)
"I've got this task, needs to be done in an insert trigger".
So, I give the code for doing so.
"Now, can you incorporated it into my...
October 18, 2010 at 4:47 am
My company offered Office through this program. A couple of months ago, though, we were informed that anyone who'd bought the software through this program would no longer be covered...
October 18, 2010 at 4:26 am
I've looked at your file and I notice you have a First Pass and a Second Pass. Can you explain these better please?
Because when I sort that file by GUID,...
October 18, 2010 at 4:11 am
I don't see an attached Excel file.
EDIT: Nevermind. I thought you meant attached to current posts. Not your previously attached file.
October 18, 2010 at 4:05 am
Gail,
Isn't your project's "deadline" sometime next week?
October 15, 2010 at 12:34 pm
WHOO!
I'm #50 (overall) for about the next few minutes before I drive down to Orlando for the weekend for SQL Saturday 49 and lose my standing to the weekend posting...
October 15, 2010 at 12:34 pm
GSquared (10/15/2010)
And my evil master plan for conquering the world by working for a small marketing company is going exactly as I have forseen it!! 🙂
Wow. You have lousy...
October 15, 2010 at 12:24 pm
And this one gives me 1 above that fifty mark. HA!
Now, nobody else can post. I need to retain my ranking. @=)
October 15, 2010 at 12:18 pm
Viewing 15 posts - 7,201 through 7,215 (of 9,725 total)