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]) ...

i tried this proc to add a serial number and updating one field, but just thinking how can i update the other three fields..

Please give ur thoughts.

ALTER PROCEDURE [dbo].[Update_S]

-- Add...

Sorry I know this is not the best way to put data, but couldnt find a better way.

this is the data i have and I want to find out the...

CREATE TABLE [PackageData] (

[Package Grp No] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL ,

[Package Item No] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL ,

[Opportunity Name] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL ,

[Opportunity Stage] [nvarchar] (255)...

Hi Jeff,

The condition for the query is :

if the account and package group is same, then if any opportunity in the package group stage >=8

then

set the accept_offer__c=true

for...

Hi Jeff,

You mean more clarity on my doubt? or data?

thanks

B

I am adding the spec I have got , i think that may help to get an idea:

- The script will identify the Account that belong to only one package...

Hi Jeff,

I am having similar issue again, but this time,

I need to upate the fileds according to two different fileds occurance.

I have feilds called accounts, package.

If the accounts and package...

Hi Jeff,

Thats working... Was thinking to sort it dynamically and then do this.

But this is really easy..

Thanks

Merry Xmas..

Hi Guys,

I am still modifying this, though it is giving the serial number, I need to get the order of the serial number by the [course start date].

So trying to...

Hi Jeff,

Thank you so much.

The document is excellent, it gave me a good insight of many things and solved my issue.

I took the following bit from document :

--===== Declare the...

Hi,

Thank you for your response, I am using SQL2000 and so I cant user Row number().

I will explain again, The table structure I have is:

CREATE TABLE [dbo].[PKg](

[ID] [int] IDENTITY(1,1) NOT...

Thanks mate, I spent two days to figure it out, and the log on user was not in the sql group..

it worked for me.

thanks again

Hi Guys,

I am having the same issue,

I can create a linked server in my local machine with the server name, but I cant connect to object explorer and i...

Audit login means, with event viewer ?? OR any other scripting?

Could you explain a bit more?