Viewing 15 posts - 826 through 840 (of 992 total)
Are you running enterprise SQL?
If so, look up "Distributed Partitioned Views" in SQL Server books online. Then you would just set up a table for each 2 hour period and...
October 5, 2005 at 12:25 am
SELECT A.ServiceID, A.[Description], B.ServiceID, B.KeyWord
FROM @TableA A
INNER JOIN @TableB B ON( A.[Description] LIKE B.KeyWord
AND DIFFERENCE( A.[Description], B.KeyWord) = 4)
Wouldn't you want a '%' tacked on...
October 5, 2005 at 12:20 am
Functions return data "in line" - they can be used as though they were a table in a query, or can return a single scalar value (eg sin(angle) where sin()...
October 5, 2005 at 12:15 am
Goto the sybase site and in the top right corner do a search on
odbc windows download
The 5th link - http://downloads.sybase.com/swd/detail.do?relid=4455&ebf=EBFI0368&baseprod=20&client=search
is probably what you want - you'll need to create...
October 1, 2005 at 8:42 pm
Please don't cross post - use this thread.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=225355
October 1, 2005 at 8:37 pm
What are you using to do the import / export? DTS (Data Transformation Services)? It is often called "Import & Export Data" in the start menu.
You can use DTS to...
October 1, 2005 at 8:36 pm
Yes char fields will cause you grief - as someone above said, storing
'wxyz' in a char(10) field will always give you back a 10 character string such as
'wxyz______'. The...
September 29, 2005 at 4:15 pm
Don't the subscribers have queued updates or immediate updates - can you have non-updates? I'm ignorant of lots of practical experience in the area unfortunately - particularly with trans repl. ...
September 29, 2005 at 4:09 pm
Hmmm - well then I am not sure if transactional replication with immediate updating subscribers would work as server B's updates would be sent to server A if B was the...
September 29, 2005 at 8:44 am
Still odd that SQL didn't see fit to use your index, unless the first column had a lot of duplicate data perhaps?
I wonder what would have happened if you switched...
September 29, 2005 at 2:22 am
And trying to turn them back into what looks like a normal resultset to feed into a something as simple as a 2D spreadsheet or something like Crystal reports is...
September 29, 2005 at 2:09 am
In our doc management system we offer both FTP-based storage (files are effectively part of a file system though) or BLOB-based storage. I personally prefer the BLOB based storage as...
September 29, 2005 at 2:01 am
Perhaps try a different client-side driver to connect to Oracle from SQL? Are you using the Oracle provided driver or the MS provided driver - switch to the other; maybe...
September 29, 2005 at 1:55 am
Do you want the data to also go from server B to server A if the data is directly inserted into server B's table?
September 29, 2005 at 1:53 am
Deleted or overwritten?
Sounds like perhaps you have identity columns that aren't being handled by replication properly. If you do have identity cols that are not managed properly, you will end...
September 29, 2005 at 1:51 am
Viewing 15 posts - 826 through 840 (of 992 total)