Viewing 15 posts - 4,246 through 4,260 (of 5,685 total)
Elliott Whitlow (1/25/2011)
With triggers we can either write the data to the other DB directly or use something like service broker to queue it up.
Side comment: Service...
January 25, 2011 at 12:42 pm
That's the kind of situation that tends to get me in trouble with my mouth.
"Let's see, would you like that in Wild Assed Guess time formatting, or Goldbricking for Giggles...
January 25, 2011 at 12:11 pm
CTEs are one-shot subquery definitions, only good for the next 'real' statement in the process.
They're more a way to organize subqueries into more intelligible code rather than creating unique structures...
January 25, 2011 at 11:59 am
To SQL Server? Not really, not once you've opened the server's "door", so to speak.
Any chance you could post the query and execution plans for the windows and non-windows...
January 25, 2011 at 11:48 am
GilaMonster (1/25/2011)
Craig Farrell (1/25/2011)
I've got it pretty good at the moment...
Wish I could say the same, as I'm sure my near-constant rants (whining) has implied. Starting to think about alternatives,...
January 25, 2011 at 11:42 am
duncfair (1/25/2011)
Steve,SSRS isn't an option because the decision to use a 3rd party reporting tool isn't negotiable at this time.
Thanks
Welp, I'm afraid not knowing much, if anything, about Logi, we're...
January 25, 2011 at 11:23 am
GilaMonster (1/25/2011)
ALZDBA (1/25/2011)
Sheer luxury :Wow:at least if you compare it to most of us :blink:
Yup. Wish I was in that position.
I've got it pretty good at the moment but that...
January 25, 2011 at 11:20 am
Then you are relatively up a creek unless you bind in an MS Access front end for reporting, Crystal Reports (I think you can pay them some royalties to include...
January 25, 2011 at 11:03 am
Just a quick addon to Phil's suggestion which is inline with what you're attempting, a quick and dirty alternative:
Use this in an execute SQL task and feed the result set...
January 25, 2011 at 10:58 am
MB-400824 (1/25/2011)
January 25, 2011 at 10:19 am
Do NOT go from 15,2 to 21, 10. You will most likely lose data.
Why?
15,2: 1234567890123.45
21,10: 12345678901.234567901
Note where the decimal ends up in precision.
You want 23,10, if...
January 25, 2011 at 10:07 am
Brian McGee-355525 (1/25/2011)
I removed QuoteSplit as it is redundant, and I added an A4, to give me more than 10000 rows available to the tally table. That's it really,...
January 25, 2011 at 9:44 am
Million Row Testbed:
INSERT INTO DeFielder (FileTypeID, FileData)
SELECT
1,
CASE WHEN t.N%2 = 0 THEN '"' + CONVERT( VARCHAR(150), NEWID()) + ',' + CONVERT( VARCHAR(150), NEWID()) + '"' ELSE CONVERT( VARCHAR(15), t.N)...
January 24, 2011 at 8:56 pm
Sometimes I wonder if other authors out there feel the same way. Do writers assume their code will be rewritten by someone before it is used. Digital rights and...
January 24, 2011 at 8:56 pm
Viewing 15 posts - 4,246 through 4,260 (of 5,685 total)