Mistypo....using cell phone. excuse me

i meant which table stores schedule NAME and start time info. I can see one.

Which table exectle, because i can not see any column in sys tables storing schedule names.

ok got my solution

just add an update function to check if there was anyupate.

query execution time falls from 9 mins to 15 secs:hehe:

Silly questions:

1) Is this ok to define a trigger on an update/delete/insert operations, on a primary key col?

2) Can we join inserted and deleted on this primary key column? would...

those if else has some other business logic associated. Cant take them off. I knw this trigger has something wrong at

is not update(colA)

begin

if @inserted = 1 and @deleted =...

Hello people

I got the solution. In case you are interested these two web links were pf great help.

http://geekswithblogs.net/stun/archive/2009/03/05/mapping-stored-procedure-parameters-in-ssis-ole-db-source-editor.aspx

http://sqlserversolutions.blogspot.com/2008/10/prompting-for-parameter-in-ssis.html

Thank you all.

@new Bee and @ sqlCrazy.

You Guyz Rock. It worked. CTE was it....why it didn't strike in my mind? Stupid me. 🙂

Thanks a ton.

Have a great weekend.

No just two records for each trade. however ccy1 and ccy2 , idex1 and idex2 may have same values.

Excuse me for the confusion

Table is like this:

CREATE TABLE [dbo].[tb1](

[trade] [varchar](10) NULL,

[leg] [varchar](10) NULL, -----say it is my Unique key

[ccy] [varchar](10) NULL,

[idex] [varchar](10) NULL

) ON [PRIMARY]

/* select...

I am able to create a temp table which gives me a data set like

A1 USD LIBOR JPY FIXED

A1 JPY FIXED USD LIBOR

A2 USD LIBOR EUR FIXED

A2 EUR FIXED...

Got my solution.

It was data type size, that was causing errors. I raised the maximum size here and there (at source connection) and it worked.

Thanks though.

Thank you so much.

This execution plan is really shocking to me. I never thought about that before and infect i was using year function for my cause.

Thank you so...

i am little curious

can't we use 'year' function in where clause?

Thank you Mark Steve and Jason.

Thank you Mark, It really helped me to understand the concept.

I have one more question for you. As you said

"SQL holds a list of logons and passwords which is...