If you don’t want the user abc to delete the data and you want to have the delete statement in the procedure, then you shouldn’t give the user abc permissions...

Just a small...

I’m sorry but it is hard to understand what you need. Can you post a small script that includes create table statement that creates the table, insert statements to...

This is because of the ownership chain. Since the stored procedure and the tables that the procedure works with are owned by the same user, ownership chain is obtained....

Here is one way of doing it:

declare @string varchar(20)

set @string = 'FA885A0/FA094V0'

select left(@string, charindex('/',@string)-1) as FirstPart,

right(@string, len(@string) - charindex('/',@string)) as SecondPart

Adi

You can use a CTE that uses the row_number function that is partitioned by code and subcode and then update the table through the CTE where row_number function returns 1....

For some reason nested transactions is one of the most confusing subjects. There are few rules that you need to understand and then the whole subject will be clear....

There are 2 ways that I can thing about to make sure that this code will be executed by 1 process each time. The first way it to use...

Yes you can, but notice that you are missing a coma in your statement.

Adi

You can convert it to a string and then work with the string manipulation functions. Here is an example:

declare @i int

declare @ci char(8)

set @i = 23052008

set @ci = convert(char(8),...

--Creagin the table and inserting the data

create table #t (string char(3))

insert into #t (string)

select 'abc'

union all select 'abc'

union all select 'abc'

union all select 'fgh'

union all select 'dft'

union all select 'fgh'

go

--Using...

rockingadmin - Pleas post your question only once instead of posting it few times in different forums.

For anyone that wants to help rockingadmin pleas use the thread at http://www.sqlservercentral.com/Forums/Topic813032-145-1.aspx

Instead...

You don’t have to specify all the columns’ names. You have to specify only the names of the columns that you want to update. If you are going...

It is unclear if you are getting results and the results include the null as the value or in your procedure the variable @sql is getting the null value....

You didn’t specify the way that you want to modify the data. In your example you changed letters to different letters and not only made those capital letters (for...