Viewing 15 posts - 8,416 through 8,430 (of 8,731 total)
thisisfutile (9/11/2012)
Luis Cazares (9/10/2012)
CELKO (9/9/2012)
The correct terms are "preserved table " and "unpreserved table" ...Can you explain us these terms? I can't find any reference on the web.
While I'm sure...
September 13, 2012 at 8:09 am
Eugene Elutin (9/13/2012)
...
Do you realistically expect to write to this table more times that the number of atoms in the Universe?
...
Sorry, I completely forgot this one. Could you please...
September 13, 2012 at 7:33 am
Does this image helps?
September 12, 2012 at 1:11 pm
I agree with your reasons Jeff, but I don't see any reason why are there only id columns instead of issue_id, jrn_id, details_id, etc.
September 12, 2012 at 9:24 am
Try performance by time (miliseconds or nanoseconds)
DECLARE @ddatetime2
SET @d = SYSDATETIME()
with a(num) as
(select 1 union select 2 union select 3 union /*select 4 union*/ select 5 union /*select 6 union*/...
September 12, 2012 at 9:18 am
Eugene Elutin (9/12/2012)
You don't really need last join as the last digit of the second number can only be '3'
Wouldn't that be cheating?
Because that way I can get the...
September 12, 2012 at 8:22 am
In 2005 there are TVF (Table Valued Functions)
There are not Table Value Constructors.
Is that what you meant?
It can be fixed by
declare @TestDate date = '2012-09-12';
with SevenRows(n) as (
...
September 12, 2012 at 7:10 am
sestell1 (9/12/2012)
Thanks for the question... I never understand these collation quirks.According to the documentation:
_CS_AS = Case-sensitive, accent-sensitive, kana-insensitive, width-insensitive
If it's case-sensitive but NOT width-sensitive, why is "peppers" at the end??
Width-sensitive...
September 12, 2012 at 6:58 am
For my understanding:
1. It sorts the words regardless of their case one letter at a time. A shorter word will come before a longer one because spaces come before letters...
September 12, 2012 at 6:56 am
Another option:
SELECTtable1.column1,
'99',
left(table1.column2,2),
max(table1.column3),
'Yes',
'Test'
FROMtable1
LEFT
JOINtable2 ON ltrim(rtrim(table1.column1))+ltrim(rtrim(left(table1.column2,2)))
= ltrim(rtrim(table2.column1))+ltrim(rtrim(left(table2.column2,2)))
WHERE table2.column1 IS NULL
AND table1.column4 = 'Yes'
GROUP BY table1.column1,left(table1.column2,2)
September 11, 2012 at 1:27 pm
Have you tried this article? It might help you with what you're trying to accomplish.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns [/url]
September 11, 2012 at 1:12 pm
I'm not sure if this gives the correct results. I can't compare it to anything but it should give you something to start with.
;WITH Sample AS(
SELECTI.StockCode,
B.ParentPart,
B.Component,
B.QtyPer,
B.Route,...
September 11, 2012 at 12:54 pm
For general knowledge and maybe performance (you'll have to test your case), I leave you with my personal preference:
SELECT DeptName,
SUM( CASE WHEN YEAR( StartDate) = 2001 THEN 1 ELSE 0...
September 11, 2012 at 11:57 am
ramadesai108 (9/11/2012)
Cannot do that because that will require too many changes in the application.
Why? How are you populating your Excel file?
Are you sure this is the correct approach? I'm not...
September 11, 2012 at 10:55 am
It depends :hehe:
I had the same question and ran queries on tables with over 9million rows on SQL Server 2005 and 2008 (I used mine and Chris, I should have...
September 11, 2012 at 10:37 am
Viewing 15 posts - 8,416 through 8,430 (of 8,731 total)