Viewing 15 posts - 4,816 through 4,830 (of 9,722 total)
Andrew Collins (1/25/2012)
The reason i started this thread was beacuse i wanted to find out if...
January 25, 2012 at 11:39 am
GilaMonster (1/25/2012)
Brandie Tarvin (1/25/2012)
January 25, 2012 at 10:35 am
SQLKnowItAll (1/25/2012)
Brandie Tarvin (1/25/2012)
mean that replication is an acceptable DRS.
For my own understanding... I assume you mean database DR, as I can see this being an acceptable solution for site...
January 25, 2012 at 10:10 am
Andrew Collins (1/25/2012)
it will initially be used as a development BI reporting accessing data from live, when dev is complete we will change to enterprise
Andrew,
I hate to break it to...
January 25, 2012 at 10:10 am
Robert Murphy UK1 (1/25/2012)
*** Oh and so long as you are replicating the data there for development purposes and not a disaster recovery solution 😎
Can I just add, for anyone...
January 25, 2012 at 9:40 am
Reading further, it looks like you want to take the first Cancel of several as a match.
Which makes me curious. How are multiple cancels for one issue making it into...
January 25, 2012 at 9:37 am
DougG (1/23/2012)
Thanks for the response.Let me see if I can clear it up a bit:
TranSeqMatching TranSeq1Unmatched
25
34
43
52
67
76
89
98
1011
1110
12Unmatched
Already with this you've violated your theory constraints. Your comment "When there is a matching...
January 25, 2012 at 9:34 am
Here's the R2 link: http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx
Microsoft is making really hard to find the SQL 2008 regular stuff, but here's what I grabbed off Google. It's a download document, so be...
January 25, 2012 at 8:20 am
If the table needs to remain in Access (not recommended, btw), then you should be able to use OPENROWSET or some other similar T-SQL command to find the data you...
January 25, 2012 at 8:13 am
Andrew Collins (1/25/2012)
January 25, 2012 at 8:10 am
GilaMonster (1/25/2012)
jcrawf02 (1/24/2012)
GilaMonster (1/24/2012)
SQL Kiwi (1/24/2012)
GilaMonster (1/24/2012)
Oooh, a palindrome! Nice.
It's also the first five binary digits of 10001001 - a number I seem to recall has special significance to you...
January 25, 2012 at 6:36 am
Ah, good ol' Litespeed. Was this is a script generated by the Litespeed console?
What exactly are you trying to accomplish with the OUTPUT variable?
January 25, 2012 at 6:24 am
It doesn't actually sound like you're using Database Replication (which is an actual feature). If I'm reading this right, you're just using a job to do a data grab. Correct?
January 25, 2012 at 6:22 am
Ditto to Jeff Moden's version. It is probably the best, and most highly recommended, splitter code I've seen.
And it works.
January 25, 2012 at 6:20 am
Viewing 15 posts - 4,816 through 4,830 (of 9,722 total)