while you are running on 2005, your database seems to be set for compatibility 80.

row_number function is compatibility 90 and above

you'll want to try my code featuring row_number at the bottom of the example i pasted.

let me know if that works for you.

George the display of the chars depends on the presentation application; what program is viewing the data as squares

SSMS in gridview mode replaces vbCrLf(CHAR(13) + CHAR(10) )with a single space.

SSMS...

here's how i would do it, not sure if it is what you want:

in the example you gave, there was only one possible solution for Width : 1.5 Height :...

bugop (11/9/2009)

---

What is the difference between these two database roles?. and which one has the full control of the database. As i understand it dbo, is the owner of the...

Thanks Gail; for proof of concept i changed one of my databases, and here's a screenshot of the results: it's found in the Application...

sometimes using the UPDATE FROM syntax can keep you from fatfingering the correlated subquery like that; i know i did that same error to an invoices table a long time...

need a clarification: your procedure had two spelling errors in it, as well as a syntax error for the cursor declaration;

select [MemberID], [TransactionType], ClosingBalance

from temp_SchemeDetails

group by [MemberID], [TransactionType]

Msg 8120, Level...

As Paul mentioned, you could add this kind of business logic in a procedure, a trigger or even using udf functions as a constraint...but...

wouldn't that logic prevent any member from...

why so complex a logic for your PK? maybe I'm missing the reason because of the way you abstracted it to pseudocode.

why won't a plain old tried and true identity...

recovery time, as well as backup complexity play a big roll.

for example, to restore to a specific point in time, you need a FULL backup, and all the logs between...

Tara looks like no, can t drop...only with db_owner rights;

here's the code i tried, line by line, and it fails when i tried to dropt eh database as the test...

this is an important piece:

when you say

can you show us the SQL? is it a cursor going thru 45...

you need to make sure every part you concat together are cast as varchar(max); otherwise you hit an 8000 limit(or lower limit if your smallest var is smaller)

when you...

details, details, details.

your making it hard on us! you've posted over a hundred times, so I can pretty much assume you've seen requests to provide CREATE TABLE and INSERT INTO...