Is the disk full?

Is there enough space for the database to extend to cope with the volume of data your inserting?

At a guess

CREATE TABLE #temp (rank int IDENTITY(1,1), username varchar(20))

INSERT INTO #temp

SELECT username FROM

WHERE quizid = @quizid

ORDER BY score DESC, datentime ASC

SELECT rank from #temp...

See this

http://www.perfectxml.com/articles/xml/importxmlsql.asp

it has some code to get the file into a string for sp_xml_preparedocument providing you have permission to use xp_cmdshell

Well retrieving redundant data for one

Depending on how many different 'views' there were and how many columns per 'view' it is possible to...

You can change a column used in a foreign-key as long as the primary key exists.

You can change/delete a primary key as long no foreign-keys point to it.

Therefore, e.g.

[Table1]

ID int...

To follow your example of 'run, runner, running' there are three occurances of run and the search will only find words starting with run. So we can put a space...

You cannot union as your two queries return different number of expressions. Also if you want the rank as well then you will also get 'duplicates'.

You need to decide what...

IIRC the last time I did this

Create a new record in the 'primary' table(s) with the same details except with the new patrol_no

Update patrol_no on all other tables that reference 'primary'...

or, without a cursor

SELECT @sql = COALESCE(@sql+',','UPDATE '+@tablename+' SET ')+

COLUMN_NAME+'=LTRIM(RTRIM('+COLUMN_NAME+'))'

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = @tablename

AND DATA_TYPE LIKE '%char'

edited

p.s. maybe some performance gain by only LTRIM...

If it is only 3 columns (bet it is not though )

CREATE TABLE #temp (Col1 int,col2 int,Col3 int,Key1 int,Key2 int,Key3 int)

INSERT INTO #temp...

Nice solutions Vladen

you can't pass a parameter into the...

The limit of 1000 is fixed in the ADSDSOObject it cannot be altered

However, what you could do is do several queries which return < 1000 rows at a time, eg

'<;(&(objectCategory=user)(givenName=a*));cn;subtree'">LDAP://server/DC=xxxxxxx,DC=xx,DC=xx>;(&(objectCategory=user)(givenName=a*));cn;subtree'

will...

are you being a sore loser again

Only bruised ego

maybe David's in his "burrow"...?!?!

Nah! Treating you with the contempt you deserve

oooops! forgot to initialise the variable

need to add

SET @count = 0

before sp_executesql