But I think regarding to performance you should adopt the stored procedure option and the query work much better than you are getting now.

any how, if this is not the...

Hi,

If you should get the error after this change, then replace the complete table name 'nsturesults' with the alias used in your query 'n'

Cheers

Hi,

You should not specify the optional delete clause in this senario ... so change your query and hope it will work now

delete nsturesults from nsturesults n inner join _temp t...

Hi,

you can do this stuff without the cursor, if you want...

here is the modification

CREATE FUNCTION dba.spd_ListFoldRemarks (

  @ArrivalPoint VARCHAR ( 4 ),

  @DocType VARCHAR(30),

  @VendID INTEGER )

 RETURNS VARCHAR (...

can you give the syntax for your delete you are going to try.

DELETE FROM nsturesults n inner join _temp t on n.setid = t.setid and n.groupid = t.groupid and n.studentid =...

Hi,

Why not you can use the Update clause rather than updated_columns

IF UPDATE(Column14)

  -- do something

else

   -- do nothing

cheers

Hi,

Roberts you are right I did not care in my response about that there is no option avaiable to execute the dynamic sql in the function.

You are right that "You...

Hi,

I would be more useful if you can mentioned the error you are getting.

I think that error is because you are using the table2 in the outer and same...

Hi,

I have just login and see your message. I check the query and the problem with the group by class... you need to change the group by clause.

Here is query...

Hi,

Yes you can used the replace function for this purpose.

SELECT REPLACE(FieldName,'Occupations','')

Hope this will slove your problem

Cheers

Hi,

Try this statement

SELECT * FROM dbo.DailyInvFunc (@StartDate, @EndDate)

Please always selects the columns by name rather then *.

Let me knwo why have you choose the function in place of stored...

Hi Ninja,

You are right... But I think the guy is wel aware of it and the error he mentioned showing that the problem is not with the security right...

Cheers

Hi,

Just place braces after execute

execute (@sql)

It will work e for you.

Cheers

I just say you cheers .... and plz have a proper english in your message it would be helpful for you as well to the person who answer you...

U can...

Hi,

As you declare your parameters with the datatype char and default length of the char datatype is one. But you are sending the values greater than this.

You should need to...