Viewing 15 posts - 4,801 through 4,815 (of 9,712 total)
Whenever you have an aggregate of any type in a UNION statement, verify that the datatype for that aggregate is the same in all sections of the UNION.
0 AS [ADV_EFT]...
January 25, 2012 at 12:28 pm
Jeff, I just saw this. Are you sure the issue isn't your connection? I see it set to Local. What happens if you set it to an actual server name?...
January 25, 2012 at 12:21 pm
Layman's explanation. Think of an Excel spreadsheet. Just one page. Now imagine it's filled with your banking information. The first 5-7 columns are your customer names and addresses, the next...
January 25, 2012 at 12:18 pm
I would be tempted to look at the code that enters the transactions and see if there is anything there that can be cribbed into your solution. But aside from...
January 25, 2012 at 11:54 am
jcrawf02 (1/25/2012)
Steve Jones - SSC Editor (1/25/2012)
SQL Kiwi (1/24/2012)
Steve Jones - SSC Editor (1/24/2012)
But you can ski?
I tried snowboarding once (in a supervised inside environment[/url]) and that was enough to...
January 25, 2012 at 11:40 am
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
Viewing 15 posts - 4,801 through 4,815 (of 9,712 total)