Search results for query: *

...called User_Status. Is there a way I can use the values in the Lookup Table and not have to hard code them in to the query like this? Select t1.*, (select count(Training_ID)from Train_TrainingsTaken t2 where t2.Status = 'Approved') As StudentApproved, (select count(Training_ID)from...

Thanks guys I see how it works now : ). I have only used Correlated Subqueries in where clause mainly using IN. Didn't know it works in the Select like that. thanks

haha no this is not homework. I know how to join tables that is no problem, I dont want all the info from the second table and I dont want to have to use 2 queries to get the info. Select info from table1 where.. select count(StudentID) From table2 where StudientID = 1 I want all the data...

Here is my table structure: StudentID First Last 1 John Doe 2 Jane Doe ClassID StudentID Instructor Time 1 1 fsd 11:00 2 1 asf 12:00 3 2 jkl 12:00 I...

I have 2 databases "A" and "b" they are both on the same server. They are seperate applications except I would like for database b to be able to access the user record in database a. Database b has some userid values that match the database a users table which has all the names and user info...

thanks for your help vbkris. I have 1 last problem, I see how it works in the code you displayed. My problem is I have an unknown lvl in the tree. The user is able to add more lvls so I wouldn't be able to dim parent, child, lvl because it could be parent, child, lvl, lvl2, lvl3.... There...

What do I need in order to use crystal reports in my web apps? Do i have to have a server version of crystal? When I compile my we app does a link to the report work without asking the user to download the report? I have not been able to link to a report on my local using the debugger why...

I am tring to get all the information into a treeview so it is not actually displayed as I put it above with the "-".

I have a page that needs to have a treeview that is populated from a database. Below is a little bit of code that i have been playing with. I would like the data in the hashtables to look like this if it were to work correctly. Parent1 - Child 1 - Lvl 1 Parent2 - Child 2 - Lvl 2...

When I start windows it comes to the page that says windows xp pro and has a bar that keeps going accross. It never gets past that point, the hard drive light stops blinking also. Safemode will load just fine adn I have tried to do a rollback there but it did not work. I have also tried to...

Is it possible to have a search box on my site without having to use a database? Where can I find some information on this? THANKS!

What causes this error? Here is an example that will cuase it. I have a listbox and when someone clicks on a entry in the listbox I tried to do: string x; x = listbox1.SelectedValue.ToString(); I am tring to understand the general rule on this because I come across it alot. Thanks for any...

In VB you can select a dropdown the top left then the one on the right will display all the available event handlers for that object. I really like C# syntax but those dropdowns at the top are almost useless in c#?.. Is there a way to get the same functionality there as you get in vb? How do...

SELECT AVG(field1 + field2) as theAverage FROM table WHERE .... UPDATE Table SET Field = theAverage where .... Why doesn't this work?

Hey guys, I have a dt in c# and all I am tring to do is read the records out of it.?? label1 = dt.Rows[0].Table.Column["field"]; something like that .. How do I get the value of "field" to display in the label? Thanks Wes

Here is basically what I have: @in_1 @in_2 if exists(Select x as value from table) BEGIN Here I want to be able to say @in_1 = value but it doesn't work? says invalid column name? I also tried using the variable in place of value in the select but that didnt work either. END...

Here is my structure: wwwroot/site - in this folder I have .CSS files, an Images folder ect. wwwroot/site/paSystem - in this folder I have a .NET module I am working on. If I run the debugger for wwwroot/site/newSystem it browses to http://localhost:4829/paSystem/file.aspx so the debugger...

Thanks guys that will work perfectly : D

I have a stored proc and what I would like to do is run a select query then based on the recordcount insert or edit. SELECT * FROM Table if recordcount = 1 UPDATE Table set x = 1 WHERE... else INSERT INTO Table ()VALUES() THANKS Wes

Have you tried www.codeproject.com