SELECT * FROM table1

WHERE

(DATEPART(quarter, @date) = 1 AND YEAR(table1_date) - 1 =  YEAR(@date) AND DATEPART(quarter, @date) = 4)

OR

DATEPART(quarter, @date) <> 1 AND YEAR(table1_date) =  YEAR(@date) AND DATEPART(quarter,...

You don't need the Location_1 in group by. Because it is the column name in your table this is screwing up your query

Why do you want to use DTS for this? Can you link the servers and the run an insert statement on the destination server. (I am assuming you have this...

I think you should be able to get it done in just few minutes.

The table create statement shouldn't take you more then a...

What you may want to do is create a table myTable1 with identical structure as yours plus one additional field with IDENTITY attribute. Then simply insert into this table all...

I said that it looks like the DTS does not provide the values for this column. In this case the default would work. If the NULL is forced down on...

I don't understand this fascination with cursors. I have seen people using them in cases where a much simpler plain SQL code will do.

If one has a proper database design there...

Looks like your DTS is not providing the values for this column. What you can probably do (if you have the rights to) is to setup default on that column...

Do you have a firewall on that box the MSDE sits on?

I think you may need to open UDP 1434 to access the SQL Server via EM.

Try this

SELECT DATEADD(day, DATEDIFF(day, 0, getdate()), 0)

You can make it into UDF

About the utility:

Good idea, horrible implementation. Looks like early prototype not a beta version.

Very disapointed. I used SQL Compare (GREAT TOOL) from the same company but this ulility looks like written...

Unfortunatelly I have to disagree with your comments about APC being late warning their customers. They have been sending the warning emails for months now. I have received at least...

The problem of using CHAR type in this case is that then the concatenated string will look like this ( taking Everett's example):

9 /13/2004 - note the space after 9

And although the...

In my opinion using the DATEADD function is the cleanest way to achive what you need. You do not have to create a messy logic to deal with changing months...