Ok thanks a lot for ur reply.

Can I compare a text field in WHERE clause.

Hi thanks for the quick reply, as i am new to T SQL..

Here this SP, I want to shedule it to run by itself, I dont want to pass any...

Ohh OK It is working fine. Thanks a lot.

I tried using bythis but still cudnt decrypt

I understand that I can get my resultset as required from the view by adding and deleting joins irrelated to the schema I have.

I tried deleting relationship from view but tht did not reflect in the daigram too.

If am deleting a relationship from my view design mode, does it also deletes in my DB scehma?

what I understand is only if I have relationship between 2 tables then I can use inner joins to query out the required resultset.

Do u mean tht u dont need...

vladan, can u tell me what benefit or what we are going to minimize when you are avoiding NULLS

Hi guys I am interested to know how do u follow in u r environment.

The thing is, I want to know whts wrong in allowing NULLS for a column, why do we need to set them to some default blank value istead of allowing...

Ok this is query..

INSERT INTO perfmeasure..Quarterlyentry

(

  ProjectedQtr ,

 Yr_EndProjected ,

 Diff  ,

 DiffPercent ,

 DiffReason ,

 CorrectiveAction

&nbsp

SELECT  

  Projected_Qtr1 ,

 Yr_EndProjected ,

 Diff  ,

 DiffPercent ,

 DiffReason,

 CorrectiveAction 

FROM PM..quarterlyEntry

FYI.. Iam not inserting particular values in it, I am inserting complete table from one DB to another

so..u want me to allow NULLS there and it works fine.