Viewing 15 posts - 50,416 through 50,430 (of 59,078 total)
Piotr Rodak (5/20/2008)
I gave it a bash, see if this can work for you:
That will work fine on small chunks of data, but recursion is inherently RBAR and therefor slow.
The...
May 20, 2008 at 8:10 am
I agree... clustered index with an index hint on it or and order by is required and you've been lucky with the order so far.
What are you doing that requires...
May 20, 2008 at 8:07 am
It's not done by Excel... it's done by the query. Add this to it...
WHERE ESASKSIZE > ' '
AND ESBIDSIZE > ' '
May 20, 2008 at 8:05 am
You would get 100 if you weren't also grouping by customer name and date as in your original code.
May 20, 2008 at 7:28 am
If you substitute the word "table" for "database", I'd agree with that.
May 20, 2008 at 7:25 am
All 3 work just fine if all you want to do is to detect that there is one or more. #3 is the fastest for this purpose. #1...
May 20, 2008 at 7:21 am
No... redundant data is not necessary. Like I said, you could use a trigger to pull this off.
Just curious... why do you want to do this? What is...
May 20, 2008 at 7:19 am
I believe you can limit that a bit by using the WITH (ROWLOCK) hint on the update.
May 20, 2008 at 1:50 am
Yes... your code for the trigger... let's see it...
May 20, 2008 at 1:45 am
gaurava16fc (5/20/2008)
select count(datetime) from XYZ where convert(datetime,left((convert(nvarchar,datetime),11)) = '2008-05-15'
Yes, that works... but no chance of an Index SEEK. The code should be written similar to the following to allow...
May 20, 2008 at 1:36 am
SQL King (2/7/2008)
Now, some of the data may OR may NOT change on day 2, how do I compare Day1's data with Day 2 data?
Like Matt suggested, it's not possible...
May 20, 2008 at 1:12 am
I've found XML splits to be just a tad on the slow side. Take a look at the following URL.
http://www.sqlservercentral.com/articles/TSQL/62867/
Also, fairly big article on splits coming out on Wednesday.
May 20, 2008 at 1:02 am
Can't be done... computed columns cannot refer to other tables.
You might be able to use a trigger to accomplish this. Why do you need to do this?
May 20, 2008 at 12:57 am
David Lester (5/19/2008)
RowID Char(16) {Primary Key, Unique}
Code1 Char(6)
Code2 Char(6)
Code3 Char(6)
Code4 Char(6)
What I need to do...
May 20, 2008 at 12:55 am
Viewing 15 posts - 50,416 through 50,430 (of 59,078 total)