Obviously you can, but I would never recommend it, unless proven to be the only possible solution.

Set-based code outperforms cursors...

That would update a single row. I'm not sure this is what the OP is after.

Try this:

ALTER TRIGGER [dbo].[Calculation] ON [dbo].[Customer]

AFTER INSERT

AS

BEGIN

-- Don't forget this line, or applications may break

SET NOCOUNT ON;

UPDATE CUST

SET Percentage = dbo.GetPercentage(INSERTED.Value)

FROM Customer CUST

INNER JOIN INSERTED

ON...

Google is your friend:

http://www.google.it/search?sourceid=chrome&ie=UTF-8&q=how+to+upgrade+SQLServer+SSRS+2005+to+SQLServer+SSRS+2008+R2

anilr71 (1/18/2012)

---

hi

one database i have one table is there.

in that table 200 rows are there

so my question is

1to 100 the rows data will be store in one table and...

What do you mean with "crash"? Database is suspect? The instance does not start? You found corruption with CHECKDB?

In order to restore the database you can issue...

There is no way to back up a single table.

You could take a "logical backup" exporting the data to a flat file using BCP or SSIS, but it's a whole...

sharada.mn8 (1/17/2012)

---

Perfect! Perfect! Perfect! This should work. I will check this on my query and I will update if this displays the result set the way I want it to...

If you turn it ON, you can send mail from SQL Server.

If you leave it OFF, you can't.

😛

No seriously, it's a very vague question. Is there anything in particular you...

Pivot? Yup.

DECLARE @Table1 TABLE (

Call_Id int NOT NULL,

Call_Description nvarchar(50),

Call_Other_Details nvarchar(50)

)

INSERT INTO @Table1 VALUES(1, 'Test call', 'xxx')

DECLARE @Table2 TABLE (

Call_Id int NOT NULL,

Call_Status nvarchar(50),

Other_Details nvarchar(50)

)

INSERT INTO @Table2 VALUES(1, 'Response...

Not that I'm aware of.

Snapshot publications take a "photograph" of the data in the publication at a given time. There is no way AFAIK to apply changes to the snapshots...

I agree. I got it wrong BTW...

Jeff Moden (1/16/2012)

---

Adi Cohn-120898 (1/16/2012)

---

If you have the same structure, but different length for each value, then you can convert it to XML and then use Xquery to get the...

Why reserve your opinion?

I'm sure that lots of people here (including myself) would love...

Revenant (1/16/2012)

---

Gianluca Sartori (1/16/2012)

---

SQL Kiwi (1/16/2012)

---

Gianluca Sartori (1/16/2012)

---

Also, I don't find 2012 SSMS to be slow at all, even in a VM. I must admit that my laptop is a...