Rob

If you don't have any indexes on your table then you can't have a fill factor.  I would recommend starting off by creating a clustered index at the very least.  You...

Shaimaa

I'd be surprised if it's the speed of your connection that's causing the failure.  When you get the failure message, double-click on the failed agent in Enterprise Manager and you...

Should work... Try this:

SELECT show_name FROM My_Table WHERE show_name LIKE 'My hunter%'

This will verify whether you have the correct data in your table.

John

Make sure you have indexes properly defined on the two tables you are selecting from.  Best candidates are those columns used in joins and WHERE clauses.  Maybe a covering index...

Jim

Yes - you did specify "based on a date".  So you can do it like this:

SELECT TOP 1 EmpName, EmpDateTime, EmpData

FROM Employees

WHERE EmpID = @EmpID

ORDER BY EmpDateTime DESC

John

Jim

You haven't given us much to go on!  Assuming you're not bothered which record you retrieve, something like this:

SELECT TOP 1 EmpName, EmpDateTime, EmpData

FROM Employees

WHERE EmpID = @EmpID

John

Have you read about parameter sniffing?

John

Hemant

I've run the query with your data and got 21 rows, as expected.  I suspect that what you have done is not to have cleared out the temp table before...

You should not be surprised that changing the parameters results in a different executions plan since the number of rows returned is likely to be different and so the most...

Anil

If Andrew's suggestion doesn't work in your environment, try breaking down your insert into smaller batches.  That way, the first batch can be replicating on to the subscriber while the...

Hemant

Please post the output of this query:

SELECT CustomerCode, InvoiceDate, InvoiceAmount

FROM tblCustomerInvoice 

ORDER BY CustomerCode ASC, InvoiceDateTime DESC

John

Asim

Have you tried

GROUP BY YEAR(LossDate)

and

GROUP BY MONTH(From_Date)?

John

OK - if you want the operating system only to use 1GB of RAM (instead of the default of 2GB), which I presume you do since you've set SQL Server...

Harris

I imagine that if you include the characters "password" in your password, then the setup program will construe that as not being a strong password.

John

Pivoting data in SQL Server 2000 can be done, but it's clumsy and cumbsersome.  Search this site - there are plenty of answers to this sort of problem.

What I'd do...