I meant like this not with the update statement:

EXEC('

CREATE VIEW dbo.vGph

WITH SCHEMABINDING

AS

O.OpportunityID as Opp_Code,

...

Grant Fritchey (4/26/2010)

---

I'm still confused by why you need to dynamically create views for use with your data. It's an odd approach, so I don't get what business need you're...

we don't have primary key and foreign key relation ship on this database.

Create Table dbo.tOpp

(

OppID int,

editUserID int,

customerid int ,

partid int

)

insert into dbo.tOpp (oppid,edituserid,customerid,partid) Values(1,2,a01,Swjji2123)

insert into dbo.tOpp (oppid,edituserid,customerid,partid) Values(2,3,a02,Swjj456)

insert into...

I have updated the view ,but it is giving me error:

Msg 4406, Level 16, State 1, Line 1

Update or insert of view or function 'dbo.vGmopph' failed because it contains a...

Thanks for the replies and suggestions.

Grant Fritchey (4/26/2010)

---

Are you attempting to dynamically create a view using values selected from the database?

Or, are you attempting to create default values for a view, like this:

SELECT 'Dude'...

I can't join the tables because there are no reference columns.

i am attaching the code below:

when i try to create the procedure i get the following error:

Incorrect syntax near...

Well i am trying to create a view in which there are two variables @a and @b which will be coming from date table ,now how can i create...

I am Updating the table in a cursor which is in stored procedure (developed by someone).

here the table B is used as cursor which...

I did search the site and found this article but got...

This is not related to scheduling.but can anyone tell me how to get start date of the month too.

Thank you

I am sorry for the late reply...

Anyway, i have replaced the cursors with while loop .

here you go ,

Create procedure procedurename

(

@columnname int,

)

as

Declare @column1ID int;

Declare @sql nvarchar(200);

Declare...

i have used select instead of set like and called the variable in a procedure

select @usertoterritoryid=usertoterritoryid

from tusertoterritory

where userid=@userid

I don't know i need to look in google or some articles.

I have done it by creating cursors inside a cursor..

i got it.