Nope. You write the query the same way.

Actually, your indexing will be dependent on how you query your data.

surma.sql (4/11/2012)

---

Hi

I have a task.

in that i need to run same stored procedure multiple time.

uspProgram_updatestudentprogram '004426495',-1,555,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0

uspProgram_updatestudentprogram '004308638',-1,559,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0

uspProgram_updatestudentprogram '004456262',-1,559,136,'2011-09-01 00:00:00.000',null,null,null,'','','',0

i am try to run in once but i...

How is the database supposed to know that Item3 is composed of pen...

hbtkp (4/11/2012)

---

@ stands for group

i have group name item3 ,which i am supplying in my sp.

now this group contains pen ,pencil .so in my table i have code for everything

for...

This is what I came up with.

create table dbo.TestSuite

(

Col1 int

, Test varchar(10)

, Outcome varchar (10)

)

insert into dbo.TestSuite

values

(1, 'test1', 'Passed');

insert into dbo.TestSuite

values

(2, 'test2', 'Failed');

insert into dbo.TestSuite

values

(3, 'test3', 'NotExec');

insert into dbo.TestSuite

values

(4, 'test4',...

hbtkp (4/11/2012)

---

ok.

le tme give you example.

exec spname

@name = @item3

this is how i need to execute my sp.

now @item3 is a group , it contains pen and pencil

in my table i...

Looks to me that the problem is not in the trigger but at the other end.

SQLRNNR (4/11/2012)

---

Lynn Pettis (4/11/2012)

---

Stefan Krzywicki (4/11/2012)

---

Lynn Pettis (4/11/2012)

---

Brandie Tarvin (4/11/2012)

---

Wow. Did I catch that right? The OP posted in an Article discussion because we weren't answering...

Your welcome. I thought it fit nicely.

SQLKnowItAll (4/11/2012)

---

seesachinjadhav,

note that it is not only bad etiquette in a forum to post your entire question in the subject line and nothing in the post itself, but extremely unprofessional...

...as [Your name here] goes over the bridge...

Stefan Krzywicki (4/11/2012)

---

Lynn Pettis (4/11/2012)

---

And...

GilaMonster (4/11/2012)

---

Lynn Pettis (4/11/2012)

---

And now...

Been there done that. I...

Years ago while in the USAF as a computer operator I had the best supervisor and trainer possible when I got to my first duty station after tech school. ...