Recent content by tobermory20

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

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

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

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 %')

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 %')

Rcloutie, That was it sweet... thanks you

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

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

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

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')

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

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

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); }

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

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