SELECT a.NAME,d.[Type],t.[Out_Type] FROM A a

INNER JOIN D d

ON a.Name=d.Name

INNER JOIN [TYPE]t

ON d.[Type] IN ( SELECT t.[Out_Type]FROM [Type])

In you Query How does the Type table join to Table A....

I had one not that long ago where I clicked run and waited and waited and waited. nothing happened no color change no error no nothing. I thought...

I guess I am not following what you mean by "payment before date" What fields would be involved in that?

Sorry wasn't paying that close attention. It is Friday and all. My Bad.

Have you tried running the Query against the DB directly with out the variables and...

missing a comma in your orderby cluase assuming the variables translate out to be column names.

ORDER BY @SFIELD, @SFIELD_TYPE

Sorry you want something like

EffectiveDate > Getdate()-1

this would effectivly give you everything for today.

Remember that get date would translate into the exact date and time. So lets say...

If you use GetDate() in place of the hard coded date you will get anything for today.

I would not think you need to learn DTS per say but you should try opening a few and get familiar with them. A basic understanding should be enough....

pavan_srirangam (4/14/2011)

---

As far as I concern,

If you are creating a package any way you define a connection to the actual server. so it deosn't

matter I guess.

all new...

WE have both BIDS installed as we have a similiar situation as you. While we have been able to publich reports from VS 2005 to 2008 it is not...

I know to upgrade to 2005 the SP level for 2000 had to be SP4 or you could not select the instance for upgrade. I would assume the same...

picky picky. LOL :hehe:

Add this to your where clause and this should take care of it.

AND DATEPART(hh,C.ROWUPDATE)=>20 AND DATEPART(hh,C.ROWUPDATE)=<6

Try to connect to the linked server using the same user and pass.

the first part would run successfully even if you put in a user that did not...

I would look at what the hardware differences are between the two boxes. I would also look at the level of activity between Prod and Test. You mention...