Thank you very much for the response Dinakar. We have decided to solve this using a DTS package.

The question does not talk about whether it is a 2-way replication. By default, it will be a one-way replication and u cant update a subscriber directly.

Even if the table does not exist, you won't be getting a syntax error. Ofcourse you will get an error that the object does not exist, which is not a...

U have got it the other way. If u use desc, it returns 3 records and if u don't use desc, it returns a single record (since it orders in...

The question talks about a table called "People" whereas the Query refers to a table called "foo".

I did see the output of those options. But, I just want to know how they can help me in deciding in the performance of a Query. since, the values...

Hi Chris,

Thanks for the explanation. I do agree with you. I was trying with the sorted column in the select list and that changed the result.

As the others have said above, the query given is incorrect. Since table2 is a single-columned table, it can't have columns a and b.

The answer given for this question is incorrect.

If the second query is,

select myOrd.Order_No, myiT.Item_No, myOrd.Unique_ID as 'Unique_ID', myit.unique_id

FROM myOrders myOrd

JOIN myItems myiT

ON myOrd.Order_No = myiT.Order_No

Order BY UNIQUE_ID desc

then,...

Thanks Marshall for the info. It really is a very useful article.

If you created the subscriber using T-SQL, then in the following query, you would specify the "SubscriberName" to be Server2 and the SubscriptionName should be specified as "DatabaseB"

EXECUTE sp_addsubscription ...

Allen's Query can be simplified as follows:

DECLARE @date1 DATETIME

DECLARE @date2 DATETIME

SELECT @date1 = '2004-05-11 00:00:00'

SELECT @date2 = '2004-05-09 11:45:00'

SELECT CAST((DATEDIFF(mi, @date2, @date1) / 60) AS VARCHAR(5)) + ':' + CAST((DATEDIFF(mi,...

I don't think that there is any other solution. In the solution that I gave, you can increase the size to be 8000 and change the datatype to varchar.

regards,

Beulah Kingsly

I don't have a solution with a single query. But if you are using SQL 2000, you can make use of a Scalar user defined function to concatenate the remarks column...

Assuming the table name to be CurrencyRates and the given dates as @StartDate and @EndDate, the Query would be  

SELECT

     [Currency Rate Code],

     COUNT(*)

FROM

     CurrencyRates

WHERE

     [Rate Year] BETWEEN YEAR(@StartDate) AND YEAR(@EndDate)

AND

     [Rate...