Viewing 15 posts - 7,561 through 7,575 (of 9,720 total)
Wayne,
Not a solution so much as a troubleshooting tip.
Right before your Insert, but after the dynamically generated table & stuff, insert a Script Task to pop up a MsgBox with...
September 13, 2010 at 7:52 am
Okay, wait. I just caught up with something you said about "implicit transactions."
No, there actually was a BEING TRANSACTION and COMMIT TRANSACTION wrapped around the "lots of code" part of...
September 13, 2010 at 5:38 am
Sorry it took so long to get back to this thread.
There is code within the TRY that should be creating transactions. But you're saying that the runtime error is happening...
September 13, 2010 at 5:26 am
To code or not to code, that is the question!
W.O.T.D. = Question!
September 13, 2010 at 4:55 am
Yeah, well, I felt the need to step in and post the Mom response. Maybe that'll help. Maybe not. But seriously, that was just plain rude.
On another note, I'm seriously...
September 13, 2010 at 4:51 am
Lennie (9/12/2010)
GilaMonster (9/12/2010)
When you create a BIT column in a table, you must decide what the 1 and 0 mean, if...
September 13, 2010 at 4:47 am
jcrawf02 (9/10/2010)
wow, that's like recursive geek-ity. If you'd tossed in a hitchiker's guide reference, I think you'd be a god...
WITH Geekity (Author, Title, MovieRef, MyTime)
AS
(SELECT Author, Title, MovieRef, DBCC TimeWarp('The...
September 10, 2010 at 12:26 pm
Oh, wait. I have to post so I can hit the 2500 point mark. @=) POST!
September 10, 2010 at 11:19 am
CirquedeSQLeil (9/10/2010)
Oh, and for the recordI have 188.0 posts per day to reach 20k by the threads 2nd anniversary
Never gonna make it, Dude. Less you post to this forum group,...
September 10, 2010 at 11:18 am
Steve Jones - Editor (9/10/2010)
September 10, 2010 at 10:30 am
CirquedeSQLeil (9/10/2010)
Alvin Ramard (9/10/2010)
WayneS (9/10/2010)
Brandie Tarvin (9/10/2010)
Alvin Ramard (9/10/2010)
Brandie Tarvin (9/10/2010)
WayneS (9/10/2010)
Brandie Tarvin (9/9/2010)
...One of the other boards I frequent ....A traitor!:w00t:
Non-SQL Board, silly. @=Pbbt
NoSQL? 😛
Careful, you. I have...
September 10, 2010 at 10:29 am
Stefan Krzywicki (9/10/2010)
CirquedeSQLeil (9/10/2010)
Alvin Ramard (9/10/2010)
Steve Jones - Editor (9/10/2010)
Holy Smoke - Be prepared to laugh out loud http://is.gd/f4cHh (Facebook)
Steve, not enough warning!!!!! I really had a hard time...
September 10, 2010 at 10:28 am
Chris Morris-439714 (9/10/2010)
Brandie, what's @=Pbbt?
It's like a raspberry, sticking one's tongue out, making the phbbt noise, and probably drenching everyone in the vicinity in the process.
You're the second person...
September 10, 2010 at 8:22 am
Alvin Ramard (9/10/2010)
Brandie Tarvin (9/10/2010)
WayneS (9/10/2010)
Brandie Tarvin (9/9/2010)
...One of the other boards I frequent ....A traitor!:w00t:
Non-SQL Board, silly. @=Pbbt
NoSQL? 😛
Careful, you. I have the DBCC Timewarp remote and I'm...
September 10, 2010 at 8:11 am
Grant Fritchey (9/10/2010)
GilaMonster (9/10/2010)
Jeff Moden (9/10/2010)
I don't have the time to read many books but that was a good one.Title? Author?
Here you go. First in a trilogy. Ancient stuff.
Ancient, maybe,...
September 10, 2010 at 8:10 am
Viewing 15 posts - 7,561 through 7,575 (of 9,720 total)