In that case the above code should work, just change MaxPrice.Price+1000 to

MaxPrice.Price + (0.1*MaxPrice.Price). Test it and let me know if this works for you.

Not Sure if this is what you are looking at. replace the temp table with your actual table.

Here is a sample code

[Code]

CREATE TABLE #Inv

(

Name VARCHAR(10),

Item VARCHAR(10),

EffectiveDate DATETIME,

Price int

)

INSERT INTO #Inv

SELECT

'ABC',...

Can you be more specific.

Is the next record always an increment by one month and increment of 1000 price of the previous record. What will be the input parameters...

Thanks 6000 seems too many now.

The application has been around for long now (>5 yrs). More than 1,000 Views are all based on this security model.

Yes we have...

That is my problem. I have 6000 users in the "users" table and also an entry for each user in sysusers table. This was the practice in my organization (even...

Thanks everyone for your response.

Jason is spot on. We ave a .NET application that uses a common login for group authentication. Then the sps are called passing the username...

The where Clause is filtering TargetSafetyQty that are Zero's or nulls.

E.g of a code snippet that might help u understand this better

[Code]

CREATE TABLE #Temp

(

ID INT IDENTITY(1,1) NOT NULL,

...

To trouble shoot yoor problem try importing the data in SQL table for comments as varchar(max) instead and test if it imports correctly.

I am glad it worked 🙂

Create two variables v1 and v2 and populate the values using SQL task.

There is an option in derived column (add as a new column). You can choose the values...

Use Derived Column transformation.

Csv Input --> derived column transformation --> OLEDB destination

good question. Got the answer from the title

But If you want to use OpenXML Method this is the correct query syntax

exec sp_xml_preparedocument @idoc output, @xml

select *

from openxml(@idoc, 'CD', 2)

with (

title varchar(25) './TITLE',

artist varchar(25) './ARTIST',

country varchar(25) './COUNTRY',

company...

Hi,

Lot of the people in the forums recommend using nodes method instead of OpenXML. Read Books online to know the differences.

You can parse the XML through nodes method

[Code]

declare @xml xml

set...

Works for me now. Thanks a lot.

I tried parsing it as nvarchar instead of varchar, but somehow missed to spot N while passing the parameters.