Programming SQL

SQL locking in an UPDATE...FROM statement
Hi all, In an UPDATE...FROM statement, how do I instruct SQL server to specifically lock only rows where the PK matches AND the value to be updated is different. It looks like it puts an update lock on TblOne whether the values differ or match. For example: UPDATE TblOne SET TblOne.Value = TblTwo.Value ... 30 Jul 2008 10:15

What are the limits to scaling Sql Server Database using Distributed Views?
Hello; I am designing a large Sql Server 2008 Database system that would include Distributed Views. The system would consist of a growing list of Linked Sql Servers, where each server has it's own database, but all databases use the same schema. I would like to employ a Distributed View so I can query all Ser... 24 Jul 2008 11:53

How to avoid using a cursor
I have my sproc all coded and working, however, my boss does not like that it uses a cursor. What I need to do is to read a table (joined with several other tables) and for each record perform multiple checks (by referring to other tables) and then if (multiple) certain conditions are not met output a table rec... 24 Jul 2008 19:06

Store Procedure to copy certain data to another DB
I'm very new at SP. I can do some simple things but this is beyond my skills and it would really help me out. Here is the scenario. I have two DBs on the same SQL 2005 server. I need to move data from one DB with a certain date to another DB. DB1 = Moxy60 (The Stored Procedure will come from this DB) DB2 = Cro... 24 Jul 2008 11:52

Dumping results to excel
Hi, I'd like to write sql code that takes the results of some queries and dump them into excel. I'm told you can use bcp to do that...but I also want to format the results - all without leaving sql. So for example I'd like to make the column headers bold, etc. I'm told bcp probably can't do that. Is there a wa... 28 Jul 2008 06:55

Question about views
I am trying to gather some recommendations to improve the performance of our Sage CRM System. One issue I am looking at currently is the views the supplier has implemented to build filtered lists for the e-newsletter system. Basically the view joins together 4 to 5 tables depending on the view, most of which ar... 24 Jul 2008 13:56

would someone else try this?
I am getting an error i don't understand. I would like for someone else to try and repeat it if possible. I am on Sql2005sp2. The goal is to take a string and split it based on a delimiter. The following is the split function. You may recognize the form. I found it from this NG but i don't remember where. ... 24 Jul 2008 14:58

sql server 2005
Get Login and Password for first time after install... - trint 30-Sep-07 02:01:31 Tony, I tried that and got another error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings... 24 Jul 2008 08:47

sql server 2005
Get Login and Password for first time after install... - trint 30-Sep-07 02:01:31 Tony, I tried that and got another error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings... 24 Jul 2008 08:47

Making Join
Hi Guys I have the table Like this ID ID TYPE Staging_Table_Columns JOINING_FIELDS STAGING_TABLE_NAME ------------------------------------------------------------------------------------------------------------------- 5 5 D Customer_First_Name~Customer_Last_Name Cust_id~zip SQL_2... 24 Jul 2008 07:45