You are correct - the problem was that you cannot have an alias on both ventven tables in the from clause - one of them must be unaliased.  OR, you...

perhaps it is not the statement itself, but the connection settings set by the JDBC driver that mean that the statement cannot use an index - things such as ANSI_NULLS,...

Plz don't cross post - I think this was part of yesterday's forums emails?  Can't find the link at the moment though

If you have a LOT of data to summarise, then you would be better off having some simple dates table structed as

MONTH   START     ...

Are you sure you are not running MSDE?  It has a DB size limit of 2GB

By the way, developer does NOT have a limit - it is supposed to be...

I think you should recopy the database - if you have somhow mysteriously lost primary keys, you have probably lost other things as well and are lucky it is not...

Carry on the rest of the discussion here in the cross post..

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=240605

If you wish to cross post, please be aware that the daily email lists new messages in all...

I can see how the definition appears recursive, but it would be implemented and function as an interative process.

For example, you can calculate the sum of a series as

for i...

Since your team comes from a file-based database background, I imagine you and they are using C# code as it is still procedural - you read in a bunch of...

It's a much better approach than using recursion as it is the most direct approach to do it.  TSQL, even using recursion, would still have to do the string concatenation... ...

How did you "copy" it?  Using DTS, database backup, detach/attach?

Keep us up to date with how it goes - would be interesting to see the pros and cons of such an approach in "the real world"

Run

cliconfg.exe in c:\windows\system32.

It will list the aliases that you have set up for SQL Server client connections - I am not sure if this is user specific or machine specific...

You are right - in your link, under the heading

Table 2. Comparison of MSDE with SQL Server Express

it clearly says 4GB for express vs 2GB for MSDE.  Good to know...

What a good article

I hadn't seen that one before - I guess it is probably the best (although it looks a bit tedious...