Programming SQL

Help on UPDATE from a novice
Hello: I have two tables: Table_A: ID Name_A Name_B Update_DT Table_B ID Name_B Update_DT Table_A.Name_A is a foreign key into Table_B.ID I want to udpate Table_A.Name_B on the matching Table_B.Name_B I tried the following SQL that fails: UPDATE TABLE_A SET Name_B = TABLE_B.Name_B, Update_D... 18 Mar 2010 14:22

SQL Server 2005 DB Roles
I am looking for SQL Server 2005 script, that will output all database roles (db_datareader, db_datawriter,.etc) and application roles for all user accounts and databases on the database server. Please help me complete this task. Thank You, ... 17 Mar 2010 18:44

How to use scalar functions?
I have this scalar function: create function [Headlines].[HeadlineCount]() returns int as declare @Rows as int select @Rows = count(*) from [Headlines].[Headlines] return @Rows Wierd question: How do you use it now? ... 17 Mar 2010 17:26

modeling a contract and effective dates
I have seen this posted somewhere but i can't find it. The following table is an attempt to model a contract and its effective dates. I don't want them to overlap but they do not have to be contiguous. Have i covered all the points of data integrity? I feel like i am missing something with regard to the Previ... 17 Mar 2010 12:31

Nested query with combined key
Hi I am working on an existing database that has three tables, no option to change the database structure, but have to work on it. CREATE TABLE Building ( b_id INT PRIMARY KEY, b_name char(50)); CREATE TABLE Door( d_id INT PRIMARY KEY, d_name char(30), d_key char(10), d_BuildingID int refer... 17 Mar 2010 12:31

Where to find AdventureWorks database samples
Does anybody know where I can find the sample Adventureworks database? I need the most recent one for sql server 2008 sp1. ... 17 Mar 2010 11:23

Stored Procedure BIT type Optional Parameter Question
I am creating a stored procedure that will have a BIT type parameter that will be optional. If that parameter is not included then it should return all values (1 and 0). I've put together the SP below but I am wondering if there is a cleaner way to handle this situation. CREATE PROCEDURE [dbo].[GetItems] @... 16 Mar 2010 22:07

Is there a Third Party Fuzzy Lookup Control For SSIS
I am creating an SSIS package to remove duplicates from (currently) the persons table. We have approx. 50 clients, each wanting to set their own paramenters for what they consider a viable match. So, example Overall match: 60% Manual Review Field Match (The following MUST add up to 100%) Prefix: 2% ... 16 Mar 2010 13:58

how to truncate to 2 decimal places
Via a calculation, how do you truncate to 2 decimal places ? ..678952 should be .67 I have seen where people have suggested Round(.678952 , 2 , 1) But I got an error message when i tried that.... ... 17 Mar 2010 09:07

Returning status/error codes and messages from stored procedures
I have a stored procedure that inserts a row into a table. When someone tries to insert a row and violates a unique constraint, should I only return 2601 and force the client to figure out what the problem was? or should I return a 1 row resultset with the 2601 and a formatted string explaining what went wrong?... 16 Mar 2010 11:25