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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tobermory20
  • Order by date
  1. tobermory20

    Looking for ways to compare

    mrdenny, Thanks for the reply. Here's my situation, I have two different Servers I am trying to access tstmd and tstsql both have a database I want to use. So do I need something like select * from table1 join server.database2.dbo.table2 as table2 on table1.col1 = table2.col3
  2. tobermory20

    Looking for ways to compare

    Hello, I am struggling with trying to compare two different database tables in different database. in theory it seems managable, but I can seem to make it work. where is what I did in Access but need to translate for MS SQL Server SELECT Table2.server FROM Table2 LEFT JOIN Table1 ON...
  3. tobermory20

    how to exclude data

    I am still struggling with excluding multiple instances of userids... here is my code SELECT userid , last_name + ', ' + first_name AS Name FROM dbo.organizationalPerson WHERE (full_name LIKE '%txtLastName%') ORDER BY last_name + ', ' + first_name with this code I return 2...
  4. tobermory20

    How to exclude data from query

    Found what I was looking for the answer should be: SELECT DISTINCT SUBSTRING(userid, 1, 5), last_name, first_name FROM organizationalPerson WHERE (full_name LIKE '% texLastName %')
  5. tobermory20

    how to exclude data

    Okay so I was a little premature on the celebration. this is what I really was looking for: SELECT DISTINCT SUBSTRING(userid, 1, 5) AS Expr2, last_name + ', ' + first_name AS Expr1 FROM dbo.organizationalPerson WHERE (full_name LIKE '% texLastName %')
  6. tobermory20

    how to exclude data

    Rcloutie, That was it sweet... thanks you
  7. tobermory20

    How to exclude data from query

    Hello, I have a statement simular to this: SELECT userid, last_name, first_name FROM organizationalPerson WHERE (full_name LIKE '% txtLastName %') ORDER BY last_name, first_name My results are vary in feedback depending on the variable txtLastName. Here is my issue, I get...
  8. tobermory20

    how to exclude data

    Hello, I have a statement simular to this: SELECT userid, last_name + ', ' + first_name AS Expr1 FROM dbo.organizationalPerson WHERE (full_name LIKE '% txtLastName %') ORDER BY last_name, first_name My results are vary in feedback depending on the variable txtLastName. Here...
  9. tobermory20

    Need to combine a Delete stmt and Select stmt

    at last this works, I am deleteing information about a record named Help Subsystem this info is in two different tables, so all info related to Type_Number = '4' in one table that is related to all info in the Help Subsystem... so I am aligning information up so to delete DELETE FROM...
  10. tobermory20

    Need to combine a Delete stmt and Select stmt

    I should have cleaned my code better, but yes I would like to acheive this code to work simular to this... DELETE FROM HL_Data WHERE (Type_Number = '4') AND (Type_ID = '5') AND (SELECT Software_Number, Software_Name FROM HL_Software WHERE Software_Name = 'Help Subsystem')
  11. tobermory20

    Need to combine a Delete stmt and Select stmt

    Hello, I want to delete information from one table why using another table... Here it was the code looks like now... delete from hl_data where type_number=4 and (select software_name from hl_software where software_name='" & lsSoftwareName & "') " Here is what I wrote... but I am getting...
  12. tobermory20

    Error message: no overloading in a List

    after hacking around with this portion of code public class Ellipse { public int X; public int Y; public int Height = 25; public int Width = 25; //Notice that there is no return value on this method - it is the constructor. This allows you to call new Ellipse(x,y,w,h) public...
  13. tobermory20

    Error message: no overloading in a List

    Hey thanks for pointing that out, I saw what i did wrong... But I am getting this error now, how can correct this... Cannot access a nonstatic member of outer type Form1 via nested type Form1.Ellipse public void Draw(Graphics g) { g.DrawEllipse(new Pen(Color.Black, 2), x, y, w, h); }
  14. tobermory20

    Error message: no overloading in a List

    JurkMonkey this is what I meant. //This adds a new ellipse at the clicked point. lstEllipses.Add(new Ellipse(e.X, e.Y)); and actually it should be four arguments w and h, but the compiler is griping about overloading...
  15. tobermory20

    Error message: no overloading in a List

    I am having an issue with adding two elements to a list at the same time does anyone know how to make this happen or an alternative for it. I keep getting an error message about no overloading here is an example the JunkMonkey had helped with... public List<Ellipse> lstEllipses = new...
  16. tobermory20

    how to keep muliple ellipse's on a grid.

    Thanks for the input JurkMonkey, that sounds like a better idea then trying to hassle with arrays. And it would save a few lines of code, with the way this is starting to grow... Thanks, T.
  17. tobermory20

    how to keep muliple ellipse's on a grid.

    After hacking around a bit with this, I am thinking the best way is a 2-D array to hold all the points as the mouse clicks the intersections. Does anyone know if there is a better way to store data points other than an array? T.
  18. tobermory20

    how to keep muliple ellipse's on a grid.

    Hello, I have a small scale 5x5 grid. When you click on an intersection like x=25 & y=25 I have set to draw an ellipse and fill it in red or black depending on positive or negative entries. That was easy enough. But when I click on the next intersect like x=25 & y=60, the first filled in...
  19. tobermory20

    Simple output statement question

    Thanks JurkMonkey, that did the trick...
  20. tobermory20

    Simple output statement question

    I have created a form, I let the Form Load take care of loading all the data. Now I have added mouse click event, I for starters just wanted to output some text when I created a simple Form1_MouseClick(object sender, MouseEventArgs e) in a form. Now I want to just output something like "You...

Part and Inventory Search

Back
Top