You searched for the word(s): userid:183850

More Search Options

RSS Available

• Re: Update a rows in one table for each row in other table

  It worked! Thanks a lot!

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by MikeMinsk on 8/16/2006

• Re: Update a rows in one table for each row in other table

  Iori_Jay: Try this one : UPDATE tblUserGroups SET UserGroup_UserCount = UsersCount FROM tblUsersGroups t join (SELECT User_GroupId, count(User_GroupId) as UsersCount FROM tblUsers WHERE DeletedFlag = 0 GROUP BY User_GroupId) As tmp ON t.User_GroupId=tmp.User_GroupId Thank you very much, I will try it very soon!

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by MikeMinsk on 8/16/2006

• Update a rows in one table for each row in other table

  Hello all, i am a newbie in SQL and i want to ask for your help in order to do the following update statement. I have a table tblUsers which holds all the users, one of the fields in their GroupId. In the UserGroup table i have a field "UsersCount" and in that field i want to keep the number of the users in that group. Basically i want everytime i am saving a user to recalculate the users in all usergroups. I am trying to have something like: SELECT User_GroupId , count ( User_GroupId ) as UsersCount

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by MikeMinsk on 8/15/2006

• Re: SQL 2005 and SQL Express 2005

  Motley: Yes. Thank you very much Motley: Yes, nothing else to do probably. You might have some issues with users/permissions to work out though. Is there any documentation on that? Motley: Yes. Just install the SQL 2005 Express? I don't want to do something wrong and ruin the SQL 2005 installation, that's why i am double checking :)

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by MikeMinsk on 7/11/2006

• SQL 2005 and SQL Express 2005

  Hi all, I am sure it has been asked before, but i can't find the answer anywhere in the forum... I developed an application with SQL 2005 and .Net 2005 and i wanted to know how (if it is possible) to use that database in the SQL Express 2005 (for small customers). I have the database (tables, views and stored procedures) as it is done on the SQL 2005. If i will just attach the database in SQL Express 2005 it will work or should i do something else too? Thanks a lot. (Is it possible to install both

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by MikeMinsk on 7/11/2006

• ΑΠ:Re: ΑΠ:Re: Calling update and insert in one stored procedure

  Thank you very much for your help!

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by MikeMinsk on 1/26/2006

• ΑΠ:Re: Calling update and insert in one stored procedure

  This is very helpful, thanks! If it exists, then how can i get the max value of the id column? Thanks again.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by MikeMinsk on 1/25/2006

• Calling update and insert in one stored procedure

  Hello, Basically i want to have a stored procedute which will do an insert statement if the record is not in the table and update if it exists. The Id is not autonumber, so if the record doesn't exists the sp should return the last id+1 to use it for the new record. Is there any example i can see, or somebody can help me with that? Thanks a lot.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by MikeMinsk on 1/25/2006

• Add row in datagrid from other controls

  Hello all, I am using the VS.2003. I would like to add a row in a datagrid, the data will come from other controls. I am having 2 textboxes (name, surname), 1 dropdownlist (sex) and a datagrid. I want to enter some values into these controls and when i am pressing a button (add) to insert them into datagrid row (the columns are also: name, surname and sex). The other issue is that i should add the ability of editing the values in the datagrid by pressing "Edit" button (it exists in each datagrid

  Posted to Data Presentation Controls (Forum) by MikeMinsk on 12/13/2005

• ΑΠ:Re: SQL and MSDE question

  ok, i have collect many info about MSDE and i think that it will work just fine :) thanks

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by MikeMinsk on 11/16/2005