Yes, there are issues with the query itself, but what did the question ask? How do you ensure you get the top 25 in sales. The only answer...

Christopher Stobbs (3/19/2009)

---

If in your table you declare rundate as a datetime and just insert into to from sysjobhsitory run date the conversation should happen automatically.

here is an example of...

LGibson69 (3/19/2009)

---

I expected to get no records because the transaction was still open but, when I ran it on SQL 2008 I got an error message saying "Msg 208, Level...

Also, FOR EACH ROW is used in Oracle, not in Microsoft SQL Server.

I have to agree with Chris above.

What table and field is this date going into?

Will this work for you?

select left(datename(mm, getdate()), 3) + '-' + cast(datename(yyyy, getdate()) as char(4))

Here is some code you can work with on this.

declare @TestTab table (ColA int, ColB Varchar(10));

insert into @TestTab

select 1, 'John' union all

select 1, 'Josh' union all

select 1, 'Bob' union all

select...

Michael O Connor (3/19/2009)

---

I have a table which has multiple indexes....

Index_Name: PK_My_Table

Type: Non-Clustered

Cols: col1,col2,col3,col4,col5

Index_Name: IX_My_Table

Type: Clustered

Cols: col1,col2,col3,col4,col5

The PK_My_Table index is created as a result of the PK constraint...

Bob,

If you are processing incoming data, you may really want to look at the fuzzy lookup in SSIS. I used it quite a while ago in a now defunct...

Here is some test code for you to look at:

declare @D1 datetime,

@D2 datetime,

@diff int;

select...

More efficient, I believe so. Please look at my code I posted earlier.

foxjazz (3/18/2009)

---

Um I don't quite understand and it's my fault for not getting my last req accross.

Forget producttype..

lets say we just have partnumber, seq

and we want to insert a part...

Sergiy (3/18/2009)

---

Guys,...

Jeff Moden (3/18/2009)

---

Lynn Pettis (3/18/2009)

---

Chris Morris (3/18/2009)

---

Heh quite possibly - but the count of BEGIN - END...