Matt,

:blush:

My apologies - I misremembered how LIKE works and should have checked it in code rather than just looking at its return type in BOL.

So sorry about that: LIKE does...

Not a clue. Have you considered posting this question in the MS Access forum too?

Barry,

I see. I hadn't looked closely enough at the nested cursors to see the need for a ranking function on that particular table yet.

But if the key...

:laugh: LOL :laugh:

No.

Since your question was posted in the CLR forum, I assume you are looking for a .NET-based solution to the problem.

A quick Google search revealed this link:

http://www.codeproject.com/KB/recipes/rc4csharp.aspx

...which may be of...

joepacelli (2/21/2010)

---

We are migrating data from an Informix database and in it there is RTF text. We are using SSIS to move the data to SQL Server staging database. Then...

There is nothing nice or elegant about forcing System.Windows.Forms into Sql Server!!!

Regardless of the requirement to convert RTF text, this is a dumb and dangerous plan.

SQL Server provides many sensible...

OMG - no!

Never use this as a work-around, it is dangerous and completely avoidable.

Never load an assembly into SQL Server with the UNSAFE permission set if you can avoid it...

wim.buyens (2/8/2010)

---

Is there a way to add lock for multithreading without the need to put the assembly with UNSAFE permissions on the server? Or can we make the aggregate...

Why does the schema of such a huge table have to change? Please explain the logic behind this as it seems highly unlikely to be sensible. What are...

bhushanvinay (2/12/2010)

---

Yes Thats right, That is not the complete story, Just saw on the internet that the Table Which is Partitioned should never be altered, there is the datapage corruption...

bhushanvinay (2/21/2010)

---

I would do some thing like this for dates always

yyy-mm-dd this seems to work for me

like when you pass in the data make sure you passin in the...

bhushanvinay (2/21/2010)

---

Seriously you need a book.

Search google for disable foreign key sql server find out more about it.

disable the foreign key

delete your data.

then re-enable it back if you...

bhushanvinay (2/21/2010)

---

Foreign keys it realy depends, When you delete data from the primary table then there is a huge overhed of making sure that the data is not available in...

Yes, sortable. 🙂

Slight change to make the ORDER BY easier to read:

DECLARE @data

TABLE (

[date] ...