10e5x (1/9/2013)

---

[/b]

---

So if i have an sql statement in my execute sql task that looks something like this:

Delete from TABLE where (CREATION_D = ?)

CREATION_D is the column i am discussing...

What about this: http://www.sqlservercentral.com/articles/T-SQL/63351/.

Thank you. Also I want to thank...

Thank you everyone. The one thing I missed when looking at the code was that the @schedule_id parameter is still there in SQL Server 2008 and 2008 R2. ...

Anyone with a SQL Server 2008 (not SQL Server 2008 R2) installation, I could use a little help here: http://www.sqlservercentral.com/Forums/Topic1404303-391-1.aspx.

This article should help some as well: http://www.sqlservercentral.com/articles/comma+separated+list/71700/.

harri.reddy (1/7/2013)

---

i need to run in sql 2000,so cte is nto working over there.i need select statement.

create table A

(id int primary key,

date1 date)

create table tableb

(id int references tableA(id),

productname varchar(40)

insert into...

terrygefael (1/7/2013)

---

Celko,

I definitely appreciate your taking the time to respond to my post.

The forum name is "SQL Server Newbies". I had assumed maybe that would be taken into account.

While I...

Have you looked at the OLE Automation procedures? That may do what you want, but I haven't used them.

Your code still only runs the test code for one of the indexes not both. If I want the execution plans for the queries using the clustered index now...

Why the requirement that CTEs cannot be used?

ben.brugman (1/7/2013)

---

The code for a Heap situation is included in the code as wel.

I should...

Toreador (1/7/2013)

---

Lynn Pettis (1/7/2013)

---

Since everyone is playing word games why don't we look at this one:

This should really say:

by default a Primary...

This is a 4+ year old thread. ...

Actually, with the code you posted there is no difference. You index is a clustered index meaning that both queries use the clustered index. Looking at the actual...