Viewing 15 posts - 481 through 495 (of 2,894 total)
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...
May 9, 2013 at 9:25 am
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...
May 9, 2013 at 6:03 am
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'"
May 9, 2013 at 5:37 am
--WHERE LEFT(CompanyIdentifier, 5) != 'EXCLU' -- NOT SARGABLE
WHERE CompanyIdentifier NOT LIKE 'EXCLU%' -- SARGABLE
Yeah, I thought about this one too, but if you check attached execution plan (from previous...
May 9, 2013 at 5:30 am
El_Mou (5/9/2013)
INSERT INTO DWProd.dbo.DIM_MATERIEL
(ID_MATERIEL,
LIB_MATERIEL,
CODE_MATERIEL,
TYPE_MATERIEL,
MARQUE_MATERIEL,
...
May 9, 2013 at 5:22 am
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...
May 9, 2013 at 5:18 am
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...
May 9, 2013 at 4:56 am
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/
May 9, 2013 at 3:11 am
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...
May 9, 2013 at 2:58 am
...
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...
May 9, 2013 at 2:50 am
dwilliscp (5/8/2013)
Sean Lange (5/8/2013)
What are the results of these two queries?
select COUNT(*) FROM #Delivery Where cast(delivery as int) = 83535308
select COUNT(*) from details_2 where cast(details_2.Delivery_Doc as int) = 83535308
One...
May 9, 2013 at 2:36 am
Lynn Pettis (5/8/2013)
Eugene Elutin (5/8/2013)
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,...
May 9, 2013 at 2:19 am
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...
May 8, 2013 at 10:56 am
elmoustabchir (5/8/2013)
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...
May 8, 2013 at 10:30 am
dwilliscp (5/8/2013)
I have two tables.. linking on Delivery No and Item No..
Temp table #Delivery has one record with...
May 8, 2013 at 9:06 am
Viewing 15 posts - 481 through 495 (of 2,894 total)