I don't understand much of French, but I can tell you that what you are trying to do is 99% possible to achieve in a single insert statement without...

You cannot put SET in the middle of SELECT.

It is a separate statement and should be placed before INSERT!

Also, if you have some dates in English, then CONVERT will fail...

Actually, looks like SUBSTRING (LEFT) can be sargable now. Check what is compiled to. Exactly the same as NOT LIKE would:

"substring([Companies].[dbo].[SourceTable].[CompanyIdentifier] as [a].[CompanyIdentifier],(1),(5))<'EXCLU' AND

substring([Companies].[dbo].[SourceTable].[CompanyIdentifier] as [a].[CompanyIdentifier],(1),(5))>'EXCLU'"

Yeah, I thought about this one too, but if you check attached execution plan (from previous...

El_Mou (5/9/2013)

---

Truncate table DWProd.dbo.DIM_MATERIEL

INSERT INTO DWProd.dbo.DIM_MATERIEL

(ID_MATERIEL,

LIB_MATERIEL,

CODE_MATERIEL,

TYPE_MATERIEL,

MARQUE_MATERIEL,

...

Your query doesn't look very logical, especially in its select list part as it doesn't correspond to order by.

Would be beneficial if you could post some test data (in...

Please post complete query, as it is impossible to see what is wrong just from two lines.

BTW, your second line finishes with comma. If nothing follows it, it will...

Just copied well known link from very recent thread in this forum (just check one about "optional parameters in WHERE...")

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Have you had a chance to read all responses made to your thread so far?

What exactly problem you are facing now?

The reason why some dates can not be converted from...

...

The question was not about use of XML in real life, but about why we cannot store XML files using good old nvarchar/ntext data type.

...

Yes, the outcome is an XML...

dwilliscp (5/8/2013)

---

One...

Lynn Pettis (5/8/2013)

---

Eugene Elutin (5/8/2013)

---

Actually you can, if you really want or need to!

You should use cursor datatype in output parameter of your procedure. Here you will find a sample:

http://msdn.microsoft.com/en-GB/library/ms175498(v=sql.105).aspx

Should,...

Here is a simple example how to deal with case if your date strings do come in different languages. Yes, you will need to use cursor (or loop) in order...

elmoustabchir (5/8/2013)

---

thank you

for my first error , its a column like this : déc 5 2007 12:00AM ( i dont understand why it doesnt work because its pretty simple...

dwilliscp (5/8/2013)

---

I have a join that is doing something that I can not explain.

I have two tables.. linking on Delivery No and Item No..

Temp table #Delivery has one record with...