Description:
Microsoft SQL Server newsgroup.
|
|
|
UsingCaseStatementInUpdate
|
| |
I am using SQL server 2005. I have a work table I need to update with phone numbers and a call status based on a value from the people_phones table. Some of the people will not have a number for each type or docall. Are using case statements the best way to do this? Thanks UPDATE persons SET per.day_phone... more »
|
|
|
Select Query Problem
|
| |
hi all The table have lots of duplicate rows except for the last column skills The skills has diffrent values some rows 'Middle East' and the other rows 'Resident Engineer', 'planner' etc When the user enters the name and the skills set, he wants to see thouse who has all the skills set Table sample... more »
|
|
|
Detect linked server down
|
| |
Hi there, I am using 2 x SQL2000 for an intranet application (classic ASP). Some of the data is coming from a linked server (thats the second SQL2000). Very occasionally we lose our internet connection, which means our linked server isn't accessible. I need to create a stored procedure that does an update on both servers... more »
|
|
|
Log Shipping
|
| |
Jay, Not sure exactly what you meant; however, these are the respective timezones: select GETDATE() --Origin server (PST) --2009-11-23 20:13:08.913 --Destination server (CST) --2009-11-23 22:15:27.120 Reason why Iam asking is because the Log shipping is not working. Even though the respective jobs in both servers are running fine, when I look in... more »
|
|
|
Inconsistent SQL Results
|
| |
I use an INSERT statement in my code and it works successfully the vast majority of the time. However, some of the time it generates the error "Conversion failed when converting the varchar value '11/23/2009' to data type int". The statement that generated the error listed above is: INSERT EntityData (Entity_id, Group_id, Attr_id, Data)... more »
|
|
|
Query executed by the user
|
| |
Hi Guys, Is it possible to find each user account who has performed query operations against a DB? I did manage to find something for SQL 2005 which does give me the query that is executed and the time..This does not list the user account.. SELECT deqs.last_execution_time AS [Time], dest.text AS [Query]... more »
|
|
|
2 WITH statements
|
| |
Doing this in SQL 2005. How do you connect 2 WITH statements. I'm trying to use (;) or (,) and neither is working. What am I doig wrong. I'm just tyring to get the second WITH table to show up. Thanks from a newbie ****************************** ****************************** ******* WITH MtdCount(TraderID, MTD)... more »
|
|
|
moving large amounts of data from one db to another
|
| |
I have a table that has millions of rows of data in it, which then references another table with millions of referenced (matching by foreign key constraints)... I need to move this data from database A to a new database B, is there any way to do this and preserve the identity columns and their referential integrity?) Thanks!... more »
|
|
|
Advice for 1-Tier architecture
|
| |
Can I get an advantage of the fact that my application is running on the same computer as SQL Server 2005 express? Is there faster way to connect to the data base than TCP/IP sockets? I need to operate as fast as possible. Any advice on configuration?
|
|
|
|
