dao.tran (5/16/2013)

---

Hi,

I'm having exactly the same problem, please let me know how to drop this table as I have tried all solutions above and none work.

Also allow system catalog updates...

One suggestion, since you are now on 2008 can you change the datatype of your text column to varchar(max)? That will likely help your query because it won't have to...

adonetok (5/16/2013)

---

I do not know how to post real table but I did the same case using .net in application (create a dataset and then looping in dataset).

Now, I...

adonetok (5/16/2013)

---

In fact, in real table there are about 20 colums and 200 ID need to check cell by cell.

I do not think that without loop can do it.

Can someone...

John Mitchell-245523 (5/16/2013)

---

I...

adonetok (5/16/2013)

---

This is the original table named as COLOR

COLOR

ID----BLUE---RED---YELLOW

111---X--------------------

222----------X------X------

333---X--------------------

444-------------------------

I need a loop to check above table cell by cell and then update another table.

The final result is table...

sqlguy-736318 (5/15/2013)

---

SSCrazy - Any reason why you wouldn't query sys.objects on object name instead of object id? Seems like a simpler approach?

I originally queried sys.objects for the info but...

select *

from sys.objects

where object_id = object_id('YourProcNameHere')

baseehkhan (5/14/2013)

---

I want to create the fiscal week for the date.In my case the starting month of the fiscal year keep change it depends on user.

For that i need help....

Maybe you can split this into 2 updates?

Something like this:

UPDATE [dbo].[Customer]

SET

[Resort] = @p_Resort,

[RoomNo] = @p_RoomNo,

[DepartDate] = @p_DepartDate,

[Paid_Accomm] = @p_Paid_Accomm

WHERE [CU_ID] = @pk_CU_ID

and [RoomNo] <> @p_RoomNo

SET @l_rowcount = @@ROWCOUNT

IF @l_rowcount...

You're welcome. Glad that worked for you.

carsten.crystaldive (5/14/2013)

---

Hey Sean,

I moved my last one about the Stored Procedure into a New Topic ... you're more than welcome to check it out 🙂 ...

Is there a way...

Profiler may not be capturing everything as you think. If the reseed...

Jack Corbett (5/14/2013)

---

Sean Lange (5/14/2013)

---

Sapen (5/14/2013)

---

Sean Lange (5/14/2013)

---

Seems a bit strange that you can put a trigger on a table but not a unique constraint. The constraint will...

Jack Corbett (5/14/2013)

---

Sean Lange (5/14/2013)

---

Seems a bit strange that you can put a trigger on a table but not a unique constraint. The constraint will perform better and...