I think your DDL and sample data script is not correct. Its returning errors. I think you should check it.

Grass (4/12/2012)

---

Hi Vinu:

I checked entity_id,and user_id are retruning multiple records in a table. So, what field do I need in my statement as a distinct.Are these entity_id

,user_id ones? or something...

capn.hector (4/12/2012)

---

vinu512 (4/12/2012)

---

dwain.c (4/11/2012)

---

Being the contrarion that I am, I'll offer another solution.

DECLARE @t TABLE (id INT, test VARCHAR(10), status VARCHAR(10))

INSERT INTO @t (id, test, status)

SELECT 1, 'test1', 'Passed' UNION...

Edit: All this has to be done by connecting to the database and not to Integration Services in the connection window.

Follow the steps to add job:

1. Right click on jobs in SQL server agent and select "new job".

2.Fill in a name for the job and click "Steps" at the left...

Oops!!! my bad then....Sorry.

Didn't know much about mining structures.

It was just a wild guess.

This is how you call a job inside a trigger:

CREATE TRIGGER <TriggerName>

ON <TableName>

AFTER INSERT, UPDATE, DELETE

AS

EXEC msdb..sp_start_job

@job_name...

Please post your DDL and sample data.

Without that, from what I understand, you should create the po no field as an identity. So, every time a new order is placed...

You should check your table for duplicates because one of your sub queries is returning multiple records from the table based on your parameters. This could happen if you have...

This might be another way....do correct me if I am wrong.

Declare @test datetime

If Not Exists(Select ID From Test Where Id = 219798)

Begin

Set @test = getdate()

End

Select @test

Hope this helps.

Vinu Vijayan

Works Perfectly for me with IS NULL.

Tried it like this :

Create Table Ex

(item1 int,

item2 varchar(5),

item3 int)

Insert Into Ex

Select 1, 'pen', 34

Union All

Select 1, 'pen', null

Select * From...

How does the database know that item3 holds the value "pen, pencil"?...Is there a table where you have specified that item3 refers to "pen, pencil"?....

If there is then you need...

dwain.c (4/11/2012)

---

Being the contrarion that I am, I'll offer another solution.

DECLARE @t TABLE (id INT, test VARCHAR(10), status VARCHAR(10))

INSERT INTO @t (id, test, status)

SELECT 1, 'test1', 'Passed' UNION ALL

SELECT 2,...

This might sound stupid.

But why don't you use import data using a package in SSAS if you dont want to use SSMS??....That can be done from BIDS. right??....

Please do correct...

Please post the DDL of the tables and sample data so thatits easier for us to understand and provide a solution.

Vinu Vijayan