Search results for query: *

Hi, I have the following query which works on SQL Server SELECT MAX(MaxValue) MaxOverAll FROM(SELECT MAX(HISTORY.WHENHISTORY) MaxValue FROM HISTORY WHERE (HISTORY.READCODE = 'ZPSA10' OR HISTORY.READCODE = '137S.00') UNION ALL SELECT...

Hi, I had the following Select statement embedded as one of the rows of a bigger query: (SELECT DISTINCT CLASSIFICATION.READCODE FROM CLASSIFICATION WHERE CLASSIFICATION.PATIENTID = ANYBODYPAT.PATIENTID AND CLASSIFICATION.READCODE = 'C10.00' AND CLASSIFICATION.ROWINACTIVE = 0) As DIA...

Hi, I am attempting creating a site with samples of images. Each image has a thumbnail that I would like to contain in a list on the right of the screen but which uses a scroll bar so I can control the size of the page reagrdless of the number of thumbs. When a user clicks on a thumb, a large...

Hi, I am a bit of a newbie to dreamweaver and I need help. I am trying to create a selection list with thumbnails and a vertical scrollbar. Any ideas? Thanks in advance. Kevin.

Hi, I am writing a windows CE application for Pocket PC 2002/3. I have a wide string containing extended characters which I read from a text file. If if output the string to another text file I get the following... FSV AUTÓMODELLEZÕ EGYESÜLET Which is fine. However if I try and output...

Hi I am trying to create a view from two tables. Table 1 Sales Cust_ID | Name | Genre | Sales Person | Last Order | ------------------------------------------------------------------------------------- A123 | John | Fiction | Bill |...

Bump. I need help. Can anyone answer?

Hi, I am trying to figure out a way of running an sql script into an sqlexpress server. I have been looking at the sqlcmd tool, attemping to use this in a spawned process. example... System.Diagnostics.Process proc = new System.Diagnostics.Process()...

I have two applications and one database. One application sits on a server with the database. This application runs each night and updates the database. The other application is installed on a number of PCs connected to the server. This application only reads from the database. I have all...

Hi, I have been using Microsoft SQL Server Management Studio Express. This was working fine with the database untill I created a data source connection in Visual Studio. Doing this seemd to change the connection string that was required. This was fine for the VS application I am developing, I...

Cheers, I will give that a go. Any other suggestions plase shout out! YNWA, Kevin.

bump

Sorry, but can anyone offer any help here? Cheers, Kevin

Hi, I have a project that has two applications and a database on a SQL Server. A client application is to sit on networked PC and the other server app with the database will sit on a server. (note: the two apps do not talk to each other and use the database independently). All was well and I...

Ok, I tried this SELECT distinct ANYBODYPAT.NHINO NHINO, ANYBODYPAT.PATIENTID PATIENTID, ANYBODYPAT.ETHCODE ETHCODE, ANYBODYPAT.GENCODE GENCODE, ANYBODYPAT.DOB DOB, CLASSIFICATION.READCODE READCODE, ANYBODYPAT.ISCAREPLUS ISCAREPLUS, ANYBODYPAT.SERPROVCODE...

Thank for that, I will give it a go and let you know the result. Cheers. Kevin.

Hi all, I have the following SQL statement that works fine... SELECT distinct ANYBODYPAT.NHINO NHINO, ANYBODYPAT.USERID USERID, ANYBODYPAT.ETHCODE ETHCODE, ANYBODYPAT.GENCODE GENCODE, ANYBODYPAT.DOB DOB, CLASSIFICATION.READCODE READCODE, ANYBODYPAT.ISCAREPLUS...

You may enquire why I did not post the question in forum756, the InterBase forum. The reason is, it was 1am in the morning and I forgot there was a specific forum for Interbase. I'm not sure how/if you can move a thread. Cheers, Kevin.

I should point out that this is an interbase database with all it's SQL restrictions. I tried to apply the suggested solution but got a BLR. Cheers, Kevin.

Thanks for the reponse I can't seem to get that to work and it's probably becase I am trying to simplify the problem to much so here it the real deal... The SQL: SELECT distinct ANYBODYPAT.NHINO NHINO, ANYBODYPAT.USERID USERID, ANYBODYPAT.ETHCODE ETHCODE, ANYBODYPAT.GENCODE...