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...

Bob Hovious (3/18/2009)

---

Hey Lynn, why are you quoting me? I think the man in the helmet is the one who requires the apology before the energy...

Sergiy (3/18/2009)

---

It's not exactly what they name "on vacation". 😉

"On vacation" means "gone fishing", "being on tour", "hiking over incredible range", getting pissed end in...

Bob Hovious (3/18/2009)

---

Lynn's saintly patience is well-known. I'm betting on a long shot, for once. It seems to be paying off. But until he...

Florian Reischl (3/18/2009)

---

If your statements don't too much changes you can work with transaction rollbacks:

IF (@@TRANCOUNT != 0)

ROLLBACK TRANSACTION

BEGIN TRANSACTION

INSERT INTO anywhere VALUES (1, 'Hello World')

ROLLBACK TRANSACTION

So...

Can't speak to the first part of your post, as we load our SSIS packages to msdb. Yes, it will increase the size of your msdb database. The...