Can you give me a little more information about what this particular query is trying to do? You may not need to use UNION, but perhaps different JOINs.

Can you make up some sample data for me? I'll recreate this structure on my server and test it.

Try using != (not equal) instead of NOT LIKE. LIKE is a little more 'fuzzy' than an explicit equal, which is why you did not get the data you were looking for.

Also, one other thing that might...

Try this:


SELECT
hourStamp,
NULL AS ActualVisits,
SUM(CASE WHEN datestamp < GETDATE() THEN 1 ELSE 0 END) / @numberofdays as HourAverage,
SUM(CASE WHEN dateStamp BETWEEN...

If you are using SQL 2005, here's another option. (originally posted in http://www.daniweb.com/forums/post639423-7.html)

Suppose you have a table with the following structure:


id - int...

Sorry I didn't get this uploaded the other night, the kids have been sick.

Suppose you have a table with the following structure:


id - int PrimaryKey
name - varchar(50)
description -...

The script is on a different computer. I'll post it when I get home.

What version of MSSQL are you using? If 2005, then I have a query you can modify that will remove duplicate entries.

Are you using a cursor?

If so, you could always create a counter variable and increment it each time through the loop. Is this done through an application, or the query window? If it's done in a...

In the Restore Database window, on the Options screen, check the first option 'Overwrite the existing database'.

BTW, are you restoring from a .bak file? Or the .mdf? If you are restoring from...

Not sure if this is what you are looking for:


DECLARE tempCursor CURSOR FOR SELECT col3 FROM table1 WHERE col2 = @col2
OPEN tempCursor
DECLARE @value As int --or whatever your datatype is
...