Instead of using CROSS JOIN you could instead use: INNER JOIN ON 1=1
or even: select columns from table1, table2
Is there any difference in the output between these three,...

Just tried:

select EntityID, secondcol, thirdcol
from dbo.Entity
order by 1+2

Doesn't order by thirdcol - gives a syntax error. So the number (1) is an alias for...

Thanks for your replies.

Yes I think I tried to bite more than I was able to chew. So I will study for exam 70-461 first, and maybe 70-462, and then...

The same thing happens on SQL 2005, so I suspect it is universal to all versions.

Any ideas as to the cause?

Thanks for the replies so far.

laurie: SQL does handle multiple value like that - you can see this if you comment out the ORDER BY clause. (you'll get: StartGBPEURUSD )

Chris...

I understand, and I'll have...

LutzM (2/23/2012)

---

You could also move the WHERE clause into the view definition (assuming the 10 minute interval is a fixed value).

If the time interval is a variable, I would consider...

Thanks Eugene, that's a bit tidier.

I am talking to the client about removing the DISTINCT requirement. This will allow the fast view over the 10-minute timescale, but triples the time...

Try running a SQL Profiler on the server, with all login objects selected, to see whether SQL Server sees any attempt to log on.

Check the security event log too.

OK so you're getting a blank results page, so you need to work out where it is...

forerolui (1/29/2010)

---

Hey

I just don’t get it. I run the script in a Database that has tables with indexes but after the script ends no results are showing.

Can anyone help...

Hmm well it looks like these servers may have been compromised by a virus or similar:

When I try to add a new publication to the publishing server (server A), I...