tim.hulse (9/19/2011)

---

GSquared (9/19/2011)

---

tim.hulse (9/19/2011)

---

kokila.kondasamy (3/23/2011)

---

hi

Kindly find the sample code...hope this will help u...is there any better way of performing the delete operation, kindly let us know

Declare @count int

set @count...

SQLTestUser (9/19/2011)

---

Sorry for the confusion

This is what i am trying to do

whenever a product or products are made inactive on the company table i want to make that company...

In that sample data, what does this part mean?

How would you translate that into rows/columns?

Alternatively, are there a finite number of variations on the grading tables? If so, make one backup for each common variation.

tim.hulse (9/19/2011)

---

kokila.kondasamy (3/23/2011)

---

hi

Kindly find the sample code...hope this will help u...is there any better way of performing the delete operation, kindly let us know

Declare @count int

set @count =0

while @count<=2000

begin

delete...

Miles Neale (9/19/2011)

---

Just a bit off topic. Thanks for the statement "We all have thigns at work that we do a certain way." This is not a criticism,...

I'm not clear on what you're asking.

If you need to know if a trigger on Table A can do things (insert/update/delete) in Table B, then the answer is yes. ...

Wow. That's a complex way of doing this.

Considering all the overhead built into this, all based on the assumption you don't know what table the trigger is being built...

Will the objects and the metadata be the same in all of these databases?

If so, save yourself significant time and work, and create one copy of it, then do a...

Try adding a column like this:

alter table dbo.MyTable

add RID as 'R' + right('00000' + cast(ID as varchar(5)), 5);

You can probably index a column defined that way, if you want to.

Just to clarify:

Are you using SSIS (Integration Services) to try to import these files, or are you trying to do it via Access, or are you trying to do it...

sbentz 2061 (9/19/2011)

---

I am in need of a very similar situation and agree that hard-coding the database name into the procedure is a bit pointless. I would like to...

Will the letter be auto-generated and incremented? Will it be a meaningful value? (Half the point of an ID column is that it has no business meaning.)

Either way,...

Yes it is. If you take the DB offline or stop SQL you can edit it. Great for documenting the DB.

Editing the text file will not harm the DB...

Brandie Tarvin (9/19/2011)

---

GSquared (9/16/2011)

---

Brandie Tarvin (9/16/2011)

---

I'm thinking about getting a tablet so I can do email & social networking apps while I am at functions (rather than lugging my laptop...