Viewing 15 posts - 2,461 through 2,475 (of 2,894 total)
Praveen Goud Kotha (8/3/2010)
Eugene Elutin (8/2/2010)
I wonder, does original data comes in a such "pivoted" way? I would think that you might have the same data somewhere in a bit...
August 3, 2010 at 2:16 am
mike 57299 (8/2/2010)
August 2, 2010 at 10:27 am
mike 57299 (8/2/2010)
My issue seems to be in resource management. As shown below, each time stamp represents 1000 records. The first 10000 go very fast, then it drops...
August 2, 2010 at 9:35 am
jvanderberg (8/2/2010)
August 2, 2010 at 9:11 am
If you want to reduce using of "case when" statements I would suggest the following:
1. Create a function to calculate your Range count:
create function dbo.udf_CalcRange(@minR int, @maxR int
, @m01 int,...
August 2, 2010 at 8:40 am
Chris, it's look like OP data is not about person names, its URL names...
July 29, 2010 at 11:14 am
Chris Morris-439714 (7/29/2010)
Eugene Elutin (7/29/2010)
SELECT a.*
FROM dbo.Person a
LEFT JOIN dbo.Person_exclusion b
ON a.Name LIKE...
July 29, 2010 at 9:33 am
Can you test how long the following query will run and how many records does it returns:
SELECT a.*
FROM dbo.Person a
LEFT JOIN dbo.Person_exclusion b
ON a.Name LIKE b.Name_similar
WHERE b.Name_similar IS NULL
You...
July 29, 2010 at 6:59 am
Based on your "new" requirements, I suggest you to read my previous post which can give you an idea of how to try to speed up your process...
To make it...
July 29, 2010 at 5:06 am
Santhosh Yamsani (7/29/2010)
I tried in following way :
update a set a.ExclusionID = b.ID
FROM dbo.Person a
join dbo.Person_exclusion b
on a.Name like b.Name_similar
But it...
July 29, 2010 at 4:35 am
What is a "huge" time.
Do you want to determine for how long query will run before executing it? - I doubt you can do it, as i depends on...
July 29, 2010 at 3:34 am
You should learn how to use table aliases and nicer formatting to make your query a bit more readable.
Try this:
SELECT PT.FirstName, PT.LastName, @PayPeriod AS PayPeriod
FROM...
July 28, 2010 at 9:38 am
If you don't like way posted in Post #958743 (which, as stated could benefit from using permanent tally table) and you don't have Excel to format SQL (as per Post#958732,#958745...
July 27, 2010 at 8:08 am
tasnim.siddiqi (7/26/2010)
Just tested your code. It works fine now. But I dont understand, because the only difference is in the way you declared the table. Now you creating a table...
July 27, 2010 at 4:10 am
patil.mangesh.v (7/24/2010)
July 26, 2010 at 10:55 am
Viewing 15 posts - 2,461 through 2,475 (of 2,894 total)