I agree - there...

ondrej.bouda (4/27/2010)

---

I wonder if the TOP specification has any special impact (as claimed) on the query execution - I tried to omit it (replacing it with WHERE PG.rn BETWEEN lowRn...

Please read Wayne's excellent article, referenced in Gianluca's post for a pretty full comparison.

Well you certainly could do it that way - but it seems very inefficient to split, convert, and then concatenate again.

Much faster to do it all in one step, in...

aaa-322853 (4/25/2010)

---

I am attempting to provide some guidelines to the report writers for one of my clients. They do have their own Sandbox db area but as they have read...

I agree with Mr Coffee - it's not entirely clear what is being asked, but this is my guess:

SELECT StartDate, InvoiceDate

FROM @Table

WHERE @Date >

...

Upgrade to SQL Server 2008 - Upgrade Assistance and Tools

Books Online:

How to: Upgrade a SQL Server Failover Cluster Instance (Setup)

Match #3 on a Google search for "upgrade cluster to 2008".

One common solution is to full-text index a computed column.

The following example happens to search for exact matches, but it can be easily modified to incorporate inflectional forms.

-- Test table

CREATE...

Hmmm...hic hic doesn't mean anything to me either. Is it laughter?

Thank Paul, very very ...

But why do you use

MAXPRICE = MAX(D.Price) OVER (PARTITION BY...

http://www.microsoft.com/sqlserver/2008/en/us/why-upgrade.aspx

Why the issue occurs:

http://blogs.msdn.com/sqlserverfaq/archive/2008/07/31/upgrade-of-sql-server-2000-instance-to-sql-server-2005-fails-with-error-similar-to-enforce-password-policy.aspx

To 'solve' it, just stop enforcing the password policy using

ALTER LOGIN (Transact-SQL)

Alternatively, consider using stronger passwords, that do meet the policy requirements 😉

Is there an award for writing the world's worst procedure?

If so, this is a real contender:

http://www.sqlservercentral.com/Forums/Topic910833-392-1.aspx

I just don't know where to start with a reply.

That's not very different - I'm surprised you couldn't work it out for yourself :Whistling:

SELECT DV.DetailKey,

DV.MAXDATE,

...

Another way:

SELECT my_group = ROW_NUMBER() OVER (ORDER BY DS.row_begin_date),

DS.row_begin_date,

iTVF.row_begin_date

FROM dbo.DIARY_STATUSES...