Viewing 15 posts - 541 through 555 (of 575 total)
So there is nothing wrong with the query you wrote, its more a case when there is a new city added into the table that the query or stored procedure...
February 17, 2004 at 8:33 pm
Lets start off by doing the query below and tell me if we are on the right track.
SELECT From_City, To_City, SUM(COST) AS 'Cost'
FROM Rate
GROUP...
February 17, 2004 at 6:11 pm
The first thing that comes to mind is to GROUP BY the CITY and SUM the costs!
However, give me some more details of the table so that I can start...
February 17, 2004 at 4:55 pm
I agree with mccork!
Before embarking on Partioned Views, how bout ascertaining the query plans of your stored procedures to see whether Indexes...
February 16, 2004 at 11:17 pm
How bout some more info! Is this on 1 transaction, lots of transactions, is this happening on just 1 subscriber or multiple subscribers?
February 12, 2004 at 4:59 pm
If RDB v6.1 does not have a replication feature then you can't do it! I can't believe how stupid some companys are to have such crap RDBMS such as RDB v6.1!...
February 12, 2004 at 4:54 pm
What are you truing to find out? The Day as in Monday, Tuesday etc or the Number 1 to 31.
February 11, 2004 at 5:42 pm
SELECT A.Column1, A.Column2, B.*
FROM Table A INNER JOIN Table B ON A.PrimaryKey = B.PrimaryKey
WHERE B.Column LIKE 'X%'
February 11, 2004 at 5:25 pm
Try this
If Update(Date1)
BEGIN
UPDATE Table SET Flag = 'Y'
FROM Table A INNER JOIN Inserted I ON A.PrimaryKey = I.PrimaryKey
END
February 11, 2004 at 5:22 pm
You can replicate data anywhere as long as the DataTypes are the same on both Publisher and Subscriber!
February 11, 2004 at 4:44 pm
Go here! You will find ample info on SQL Server Replication!
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replover_694n.asp
February 11, 2004 at 4:42 pm
GA,
If your requirement is to Replicate an ORACLE Database to a SQL Server Database then doesn't this have to be done from the ORACLE side? Surely ORACLE like most serious...
February 11, 2004 at 4:32 pm
What are those 4 jobs? What do they do?
February 10, 2004 at 8:45 pm
From BOL
The syntax may not be supported in a future version of SQL Server. Any statements using the Transact-SQL outer joins should be changed to use the SQL-92 syntax.
February 10, 2004 at 5:38 pm
syspropertiesContains extended properties that can be defined on various objects in a database. The extended properties are a new SQL... |
February 10, 2004 at 5:35 pm
Viewing 15 posts - 541 through 555 (of 575 total)