working excellently now

but in the where clause why just

WHERE p.Deleted = 0

i posted sample data

Michael Earl (11/5/2008)

---

If you also had a table with a primary key of PageID, the composite key on the table with both would make a lot of sense and be...

Hi SSCrazy

I have another table like this

BuildId

BuildName

BuildURL

So in that case it makes sense to have a composite key?

I will try to do that.

I will see if I have permissions to browse the folder.

Thanks

Regards

johann

yes i would like to move backups off and on the server.

I have remote access, however I cannot map to a drive on the server, because of security reasons

yes I can connect an instace of SQL Server on my local machine to the remote database.

However if I create a Job on their database (remote), I still cannot get...

well i have a control panel, however I cannot access the servers physically.

I am not paying so much monthly, its not a really big site, that is why I accepted...

Its very hard to do that, since I do not have access to the hosting machine, and if I do create a job, i will not be able to retreive...

Hi Journeyman

I just want to retreive for example from record 20 to record 30. I was using this kind of stored proc before

WITH PagesRN AS

(

SELECTDISTINCT...

Hey, sorry for the late reply

Thanks for all your suggestions, will work on that in the near future.

Thanks for your help guys

Johann

serinor.e090266 (9/3/2008)

---

First of all, why are you trying to transmit all the records in the table to your client?.

The client must review all the information, or only some pages.

In our...

solved guys

added collate SQL_Latin1_General_CP1_CI_AS in the where clause

Thanks

ok got it!

ORDER BYCASE PageID

WHEN 0 THEN 1

ELSE 0

END,

StatusID,

PageID

Thanks guys

ok I got to this

ORDER BYCASE PageID

WHEN 0 THEN 0

ELSE 1

END,

StatusId,

PageID

However the PageID 0 is displaying first before the other PageID's. I want it to display last