One possible way to perform this would be to have another table with all possible dates in it, and join to this table.

ie....

Select B.Date, A.name, A.location from

events A inner join Dates...

This is an extended stored proc, so the errors reported and passed are out of our hands.....

There is possibility using the new try catch in SQL 2005......what db server are you...

I have worked with Sql Server in some of the highest concurrency enviroments in the nation. Some of them have been financial systems, some E-commerce, some order placement, some even...

This looks like the typical scenario involving a set of filtered publication/subscriber replications, either Bi-Directional Transactional or Merge. What exactly is your question?

It would have to be because somewhere in the joins, your causing the rows to be duplicated. Without knowing the data, and structure, I couldn't say for sure, but that...

The most definitive answer for this is easy.

1. Create your clustered index on your best guess column, using common sense and recommendations. And other indexes on whatever other columns...

Here ya go:

SELECT

CASE

WHEN

LEN(LTRIM(RTRIM(dbo.

The results you want are easily generated by three seperate distinct statements.

Select Distinct A From Table

Select Distinct B From Table

Select Distinct C From Table

Unless there is some relation between A, B, and...

Select

D.DeptName, E.Name

From

department D

Left

Outer...

No, that is not a function of bcp....

This really depends on what your definition of "successful" is.

If it is "Stored Proc Worked." then you already get that by the error handling. You'll get an error if it...

At a prior site I worked at, we had a similar task to perform. What we did, was to create a control table on both sides of the replication, having...

Or you could use this:

SELECT

Dateadd(qq,-1,(DATEADD(ms,-3,