Viewing 15 posts - 5,086 through 5,100 (of 9,715 total)
SQLRNNR (11/16/2011)
Brandie Tarvin (11/16/2011)
L' Eomot Inversé (11/16/2011)
Ninja's_RGR'us (11/16/2011)
http://www.sqlservercentral.com/Forums/Topic1206736-391-1.aspx
GilaMonster (11/16/2011)
ashuthinks (11/16/2011)
please let me know my usage is at...
November 16, 2011 at 9:36 am
Do you have the authority and control to completely rewrite this process?
If so, I urge you to to move the updates, inserts and deletes to a completely different ETL process...
November 16, 2011 at 9:33 am
Dev (11/16/2011)
ashuthinks (11/16/2011)
@gila yes sir...i knew that if i don't use NOLOCK i will definitely get a deadlock so for successful
execution i need to use NOLOCK
You are...
November 16, 2011 at 9:30 am
L' Eomot Inversé (11/16/2011)
Ninja's_RGR'us (11/16/2011)
http://www.sqlservercentral.com/Forums/Topic1206736-391-1.aspx
GilaMonster (11/16/2011)
ashuthinks (11/16/2011)
i.m just using this stored procedure for reporting purpose..please let me know my usage is at right or not?
Since...
November 16, 2011 at 9:28 am
You're welcome. Did you figure out what the issue was yet? I'd love to hear the details if you have them.
November 16, 2011 at 5:01 am
But this is The Thread. Nothing on The Thread is supposed to make sense!
@=)
November 16, 2011 at 4:59 am
Ninja's_RGR'us (11/16/2011)
Koen Verbeeck (11/15/2011)
Ninja's_RGR'us (11/15/2011)
jcrawf02 (11/15/2011)
Hey, I like the condensed version of The Thread...
Same here.
No offense if I forgot anything else. I didn't reread the whole 2 weeks either...
November 16, 2011 at 4:52 am
Jim Murphy (11/15/2011)
Stefan Krzywicki (11/15/2011)
Brandie Tarvin (11/11/2011)
EEEK! I just sold another story. Happy happy.Now I have to write more.
Awesome! Congratulations. (Sorry, I'm catching up on the thread, but this...
November 15, 2011 at 12:14 pm
Try turning the Unit Separators into filler columns.
I knew it was going to lose the column data. I thought I'd mentioned it, but I apologize if I didn't.
November 15, 2011 at 12:02 pm
Sorry, I don't know Hex, so I can't translate {1F} into a character I would understand.
I will suggest changing your connection manager from a Delimited to a Ragged Right (you'll...
November 15, 2011 at 8:47 am
Ninja's_RGR'us (11/15/2011)
and if you can't laugh at yourself... well we can :-P.
Hee.
November 15, 2011 at 8:00 am
The file is marked as delimited. What type of delimiter are you using?
And do you have multiple files that this issue is showing on or just this one?
November 15, 2011 at 7:54 am
Gianluca Sartori (11/15/2011)
Steve, you trigger doesn't work. Both Jeff and Gail passed you, consider rewriting! 😛
Is that why my posts keep disappearing? He pointed the ROLLBACK TRANSACTION at the wrong...
November 15, 2011 at 7:46 am
SQLRNNR (11/15/2011)
Ninja's_RGR'us (11/15/2011)
Brandie Tarvin (11/15/2011)
Ninja's_RGR'us (11/15/2011)
Brandie Tarvin (11/11/2011)
EEEK! I just sold another story. Happy happy.Now I have to write more.
EDIT: Nevermind. I see you were quoting them for Grant....
November 15, 2011 at 7:44 am
Those are fantastic links, Paul. Thanks (even though I'm not OP).
November 15, 2011 at 7:42 am
Viewing 15 posts - 5,086 through 5,100 (of 9,715 total)