[font="Verdana"]

tinku.reddy (10/20/2008)

---

Hi have a small question(indexes)

I created a primary key on a table.

There is clustered index created by default .

BUT ....

I want to create an index on some other...

[font="Verdana"]

Refer below URL:

http://www.sqlservercentral.com/Forums/Topic590618-145-1.aspx

Mahesh

[/font]

[font="Verdana"]

tinku.reddy (10/23/2008)

---

Hi please help me

i was trying to update using while loop

Here is my code ....

declare @y char(3)

declare @count int

set @y = 'no'

set @count = 1

select...

[font="Verdana"]John, Stored Procedure would have been best option then. You could pass just parameters from front end(shown by rbarryyoung)

--Mahesh[/font]

[font="Verdana"]Its not possible to set collation at run time. Mention the exact collation.[/font]

[font="Verdana"]Turn on SQL Profiler then.

Mahesh[/font]

[font="Verdana"]

mailsar (7/16/2008)

---

Hi Mahesh,

I am using, If update(column name) as it is one of the best way to find out whther the column is being updated....

[font="Verdana"]Will you explain what exactly you wants to do? What do you mean Avg on Row instead of Col? Altimately the values are going to be resides in cell.

Mahesh[/font]

[font="Verdana"]

This means your server has...

[font="Verdana"]

Abhijit (7/16/2008)

---

You simply need to create the UPDATE trigger on Customer table which includes Insert statment for AuditCustomer, Inserts the record from inserted / deleted table ( inbuild table in...

[font="Verdana"]http://www.sqlservercentral.com/Forums/Topic529741-149-1.aspx[/font]

[font="Verdana"]Too much indexing harm on Insert / Update / Delete statments on that table. Because the whole data needs to be rearranged again in case of these statements.

Mahesh[/font]

[font="Verdana"]SQL 2005 has PIVOT and UNPIVOT operators. For more information refer below file.

Mahesh[/font]

[font="Verdana"]

try this...

SELECT DISTINCT emp

FROM #tblseat

With (index=IX_placing,NOLOCK)

Mahesh

[/font]

[font="Verdana"]You need self join in this case. Like:

Select E.EmployeeId, E.Name, E.ReportTo, M.Name From Employee As E Inner Join Employee As M On E.ReportTo = M.EmployeeId.

Also you can add the columns...