GSquared (1/11/2010)

---

This seriously looks like homework. Is it?

The way I'd do this is build a CTE that uses the Rank() function to rank the titles by price within each...

so its in concurrency problems , yes ?

Ian Scarlett (10/29/2009)

---

Without understanding your data and your business, that's very difficult to answer, so I'll go back to my original point.

I presume a licence is granted to a given...

Ian Scarlett (10/29/2009)

---

The error message says it all...

I think there's something wrong with your data model... you can arrive at Licence from 2 directions. With this model, there's nothing...

i dont execute special code,it get error when i want to set update and insert rule to Cascading for second relation..

the error is :

'Services' table saved successfully

'Licences' table

- Unable to...

as u can see in image licence table has 2 relations with Service Table and Employee Table..

i cant set cascading for this 2 relation,SQL just allow for one of...

when i select as below ,all thing is correct :

SELECT Record.Date,Record.[Time],Record.Tone,Record.Telephone

From Record

Order By Record.Date DESC,Record.[Time] DESC

I mean putting DESC for every part of order by !

Jeff Moden (8/10/2009)

---

Heh... no problem, Paul. The OP's question of "you use with instead while loop,why?" reminded me of the very first time I saw such a thing except...

Paul White (8/9/2009)

---

Try this then. I took the liberty of creating some example data.

USE tempdb;

SET NOCOUNT ON;

GO

IF OBJECT_ID(N'tempdb.dbo.Record', N'U') IS NOT NULL DROP TABLE dbo.Record;

IF OBJECT_ID(N'tempdb.dbo.#Temp', N'U')...

no,it was just as an example..i mean just i have some result with same columns but in seprate resultset(because each one belong to another select ) and i wanna mix...

i checked it :

Tools=>Options=>Query Result=>Default Destination for results set to result to grids (by defaulte its Set to this )

:O(

any suggesstion ?

when i check this:

tools->option->Query Result->SqlServer

theres 2 item:

1.#result to grid

here maximum characters retrieved for xml data set to 2MB

2.#result to text

here,maximum number of characters displayed in each column set to 256

so,when...

result in QA.

again i think here may be some limitation with select statement result..because every thing is usual..

if i select for xml auto,elements every thing is ok because each record...

i think it refers to select result length,because every thing is as like as mine ...

is there any thing about select result length?

theres not anything special:

i have a table named Region,with following fields :

Id int Identity(1,1)

Code varchar(10)

Title nvarchar(20)

as you know:when select for xml,all result set return as one record,so i think theres...