Having performance issues, Saravan? Can you go into some more detail please?

LOL you used to work there...

Please post the result of the PRINT...

Stephen Hirsch (1/18/2010)

---

Here's a better way:

SELECT 'IN A NOT B' location, a, b, c, d, ...

FROM tablea

EXCEPT

SELECT 'IN A NOT B' location, a, b, c, d, ...

FROM tableb

UNION ALL

SELECT 'IN...

Biz (1/17/2010)

---

The sample data as per your request is:

INSERT INTO [SF].[dbo].[PackageData] ([Package Grp No] ,[Account] ,[SrID],[Update Accept_Offer__c] ,[Offer_Letter_Name__c],[New Stage] ,[Package Item No] ,[Opportunity Name],[Opportunity Stage],[Course Start Date],[Opportunity ID],[Group: ID],[PackageID])...

You're welcome, Larry, good result.

Can I recommend that for future reference, you read...

Yeah but...kinda.

This time round, you know exactly why you would put it there, and why you will (almost) always get more results in your final output than you specified...

This bit...

SELECT Email1,Email2,Email3, Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM outputresume3

WHERE ((contains (originalresume, '"j2ee" and "java"'))

AND (currentdateout BETWEEN '2000-01-01' AND '2010-01-06'))

change it to

SELECT...

SELECT u.Email, 'Submitted by' AS UserRole

FROM Bold_FeatureRequest FR

INNER JOIN Users U on FR.UserId = U.UserId

WHERE FR.FeatureId = @featureId

UNION ALL

SELECT u.Email, 'Commented on by' AS UserRole

FROM Bold_FeatureRequestComment FRC...

SELECT MyString, ASCII(MyString)

FROM (

SELECT '000' AS MyString UNION ALL

SELECT '101' UNION ALL

SELECT '200' UNION ALL

SELECT '201' UNION ALL

SELECT '300' UNION ALL

SELECT '901' UNION ALL

SELECT ' aAA' UNION ALL

SELECT 'AAB'...

Hello

The UPDATE and the SET apply to the same table.

Ideally the first table listed after FROM is also the target of the update.

In your case, you've aliased the target...

Please set up your data as a series of INSERT statements, this will help users to begin work on your problem.

Cheers

ChrisM

Guilty of cantankerism as charged - but hey,...

Have you contacted the vendor?

Grant Fritchey (1/14/2010)

---

Chris Morris-439714 (1/14/2010)

---

Greg Edwards-268690 (1/13/2010)

---

Grant Fritchey (1/13/2010)

---

Yep. I agree. As...