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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.