Viewing 15 posts - 1 through 15 (of 334 total)
So far, nothing.
November 6, 2017 at 8:04 am
Distance on a plane, or distance on a sphere? If locations are far-ish apart, it makes a difference.
I did consider this but given that the locations are all within...
May 27, 2011 at 5:18 am
I have great respect for your knowledge in relational theory, I even own two of your books. However, since database and query design are not my primary responsibility so...
May 27, 2011 at 5:16 am
Worked perfectly. Thanks.
May 26, 2011 at 10:19 am
Simpler than I thought. I generally don't consider cross join because of the volume ramifications but the entire table is 36 rows and the matching entries by state/city are in...
May 26, 2011 at 9:12 am
Runs once a year
March 29, 2011 at 8:40 am
Here's the final entire thing. Went from minutes to milliseconds. Much thanks.
Declare @counts table (ID int, Entries int)
truncate table dbo.DrawingPool2
-- Get players and compute # entries based on position (1=100,...
March 29, 2011 at 8:34 am
Looks like it might do the trick. I'll give it a shot.
March 29, 2011 at 7:59 am
I think I see where you're going. Two things:
1. What is dbo.Tally?
2. Do I just add an Insert above the Select from the CTE to actually perform the insert?
March 29, 2011 at 7:48 am
I found that solution in the SSRS Forum on MSDN. Fortunately when you open a new question they look at the subject you entered and list what they think may...
September 14, 2010 at 6:13 am
It was Parameter Sniffing. Check here:
I changed the single SP parameter to assign it to a local variable and it fixed the problem. Go figure..
September 14, 2010 at 5:30 am
Without posting all the code which is sizable, here is an outline of the SP:
DECLARE @Temp TABLE (BusinessUnit varchar(255), Leader varchar(100), [Level] int,
Sublevel int, Staff int, Emps int, Resps int,...
September 14, 2010 at 5:14 am
Are you sure the sp is not locking or deadlocking?
Fairly certain. It's a simple read of a couple of tables into a table variable, compute some additional fields in...
September 14, 2010 at 4:49 am
There's no direct correlation between the tables. The only thing is the BinPath. I could join Leaders to ReportingHierarchy based on the "LEFT(r.BinPath,LEN(r.BinPath)) = l.BinPath" understanding that using LEN in...
September 7, 2010 at 1:36 pm
Thanks for all your work on this.
I already have a function similar to your dbo.GetEmployeeDownLine(ID) function. My end use case is that I need a table of all the employees...
September 7, 2010 at 4:59 am