priscillamuis
Last Activity: Mar 2 '10, 03:50 PM
Joined: Feb 25 '10
Location:
-
priscillamuis replied to How can I get 2 rows as first reply when databse has more rows with same keywords?in SQL ServerSorry, let me rephrase: I want to find the rows with the keyword in it, eg 10 rows with red in database. But I want to display 2 rows at a time without losing the whole list e.g red blue and red yellow. The other red green, red magenta, red white etc) The query should divide the list into 2 rows of 160char en let the list just loop on until I'm back on top again. -
priscillamuis replied to How can I get 2 rows as first reply when databse has more rows with same keywords?in SQL ServerI've already tried this. It works but it display's the row count. I don't want the row count.
I want to see/ view the information that's in the rows.
How do I do that?Leave a comment:
-
priscillamuis replied to How can I get 2 rows as first reply when databse has more rows with same keywords?in SQL ServerOoh, ok. But I don't know how many rows will be found? Every search will be different. If I don't know the number of rows, what syntax do I use?
SELECT TOP '%' * from autodatabase?Leave a comment:
-
priscillamuis replied to How can I get 2 rows as first reply when databse has more rows with same keywords?in SQL ServerDo you also think I should use BEGIN LOOP en END LOOP?
I SELECT RTRIM(name)+',' +RTRIM(street)+ ' t:'+RTRIM(telno ) AS search
FROM autodatabase BEGIN LOOP
WHERE name LIKE 'TOPkeyword%'
ORDER BY name ASC
I also don't know if I should use @@ROWCOUNT =2 to use as command to break the data after 2 lines, but to go on with the list I don't know if I should use CONTINUE and stop the script with END LOOP.
...Leave a comment:
-
priscillamuis started a topic How can I get 2 rows as first reply when databse has more rows with same keywords?in SQL ServerHow can I get 2 rows as first reply when databse has more rows with same keywords?
Hi, my database has 4 colums: name, adres phone and fax
I'm running this query:
SELECT DISTINCT '$sender',MSG = substring ((SELECT RTRIM(name)+',' +RTRIM(street)+ ' t:'+RTRIM(telno )+' f:'+RTRIM(faxno )+' - ' FROM autodatabase WHERE
name LIKE '$keyword%' FOR XML path(''), ELEMENTS),0 ,500) FROM
autodatabase
I want the first reply to be the first 2 rows of what has been found.
I get all...
No activity results to display
Leave a comment: