Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:183850
More Search Options
RSS Available
Matching Posts
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
Page 1 of 38 (377 items) 1
2
3
4
5
Next >
...
Last »
ASP.NET:
Merry Christmas
TechNet Edge:
FPE Customer Story
Silverlight:
Being a writer, and having an editor. A Short Rant.
Channel 9:
Channel 9 Live at PDC09: Dr Brian Brooks (3M)
Channel 9:
C9 Lectures: Dr. Erik Meijer - Functional Programming Fundamentals Chapter 13 of 13
Silverlight:
Information for Silverlight HVP Developers…
WindowsClient:
Custom Content Loaders in Silverlight 4.0
WindowsClient:
MVVM Links\Info
TechNet Edge:
Check out how Dolly Parton uses IE8 and Web slices!!!
Silverlight:
A Silverlight HVP Update
Channel 9:
Channel 9 Live at PDC09: This Week on Channel 9 - PDC09 Daily Show Edition Day 1
Channel 9:
Maria Klawe: Scholar, Scientist and Microsoft Board Member
Channel 10:
Play the Bing Sherlock Holmes Game
Channel 9:
Channel 9 Live at PDC09: Loic Le Meur
Channel 10:
How to Delete Jump List Items
Channel 10:
Roll Back to Classic Network Indicator in Win7
Channel 9:
Jafar Husain: Silverlight Toolkit and Rx, Part 2
Channel 9:
Ping 42: Is Microsoft cool? Photo DNA, Win7 tool, 10k MIX contest
Channel 9:
Jafar Husain: Silverlight Toolkit and Rx, Part 1
Channel 9:
Francesco Logozzo - Static Checking with Code Contracts for .NET
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online