Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Elroacho

  1. Elroacho

    Max from union

    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...
  2. Elroacho

    Singleton error

    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...
  3. Elroacho

    Thumbnail list

    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...
  4. Elroacho

    Thumbnail list

    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.
  5. Elroacho

    Extended characters in edit control

    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...
  6. Elroacho

    A view from two tables

    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 |...
  7. Elroacho

    Running an sql script from VS2005 (C#)

    Bump. I need help. Can anyone answer?
  8. Elroacho

    Running an sql script from VS2005 (C#)

    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()...
  9. Elroacho

    Deploying SQL Express database

    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...
  10. Elroacho

    Answer to please help

    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...
  11. Elroacho

    Please help

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

    Please help

    bump
  13. Elroacho

    Please help

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

    Please help

    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...
  15. Elroacho

    Nested Counting

    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...
See more

Part and Inventory Search

Back
Top