Programming SQL

Migrating from MS Access
Hi I have this query, which I need to make work in MS SQL Server select job.[CAM File],FIRST([material]), FIRST(job.[description]), FIRST(job.[programmer]) from job where job.[CAM file] <> '' group by job.[cam file] order by 3 The "first" is my problem. I can translate most of into select job.[CAM Fil... 9 Jun 2010 15:21

Updating using groupby
I have two tables and I want to update one with values from the other. I have a membership table that holds the MemberID and Email and a Registration table that holds a RegistrationID, Email, and a blank field for the Memberid. What I would like to do is to match the email addresses in both tables. When there ... 9 Jun 2010 15:21

Scope Variables and SSIS Sequence Containers
Is it possible to use variables that are specific to a sequence container only ? Variables are available in the Control Flow and Data Flow Task areas but I don't see any variables which are available with scope limited to Sequence containers. I am using SSIS 2005. Thank you, ... 11 Jun 2010 00:34

sys.conversation_endpoints not purged
I desperately need help with service broker. I have created a simple application (code below), which uses a message queue to send messages from the initiator to the target. No response is required (I need a fire and forget strategy here). Although both sides of the conversation call END CONVERSATION, the tabl... 9 Jun 2010 10:52

Soundex Problem
Hi Mike, Would it be possible to email the codes to goldeye61(a)yahoo.com?.....greatly appreciate the help! "Mike C#" wrote: "Geoff Schaller" <geoffx(a)softwareobjectivesx.com.au> wrote in message news:4782cc23$1(a)dnews.tpgi.com.au... Matija, I am not sure I really understand. Ultimately ... 9 Jun 2010 05:21

Help in update
Dear All sql 2000 i have following table create table main_tab (Myid int, Status char(1)) Create table Sec_tab (Myid int, Report char(1)) i have following sample data in main_tab insert into main_tab (myid) values (1) insert into main_tab (myid) values (2) insert into main_tab (myid) values (3) ... 9 Jun 2010 07:32

SSRS doesnt like Guid param datatypes
using SSRS 2008 R2, I'm trying to pass in a parameter that's a guid data type. all other parameters and data types seem to work OK except for Guids. this is how its added: ParameterValue value = new ParameterValue(); value.Name = "InLc_Id"; value.Value = "fa13edcf-c518-48b0-96aa-4d398cc0221d"; reportParamete... 10 Jun 2010 00:13

how to join dynamic SQL results with another query
Hi Everybody, I'm using dynamic SQL to execute a pivot query for a sales report since the column names will change by month. The very last statement is "EXECUTE sp_executesql @query", where @query is my pivot query string. How do I join these results with another query so as to get one resulting dataset? Fo... 17 Jun 2010 14:33

DB2 on SS
I have a large collection of DB2 scripts. Do we have available some SSMS trickery to import these into a SQL Server database that will represent the DB2 schema ? Or will I have to resort to installing DB2 ? ... 8 Jun 2010 17:15

Available well experienced consultants for your positions
Hi, Hope you doing well. Please let me know if you have any positions open for well experienced candidates in Oracle DBA , Oracle Apps DBA, Java/J2EE Developer, QA Engineer, SAP BIBW & SQL server developer Candidates Immediately. *** FOR A CONTRACT BASIS*** Flexible to work at any place in US. Please let ... 8 Jun 2010 16:04