Viewing 15 posts - 3,076 through 3,090 (of 9,643 total)
To be honest, I'd be happy with anything. When I worked at a for-profit, I got nothing, well, that's not true the first couple of years we got a...
April 16, 2010 at 6:19 am
Interesting editorial. I really think companies should have and enforce internet use policies. I've never worked for one that does, but I know I need to more judicious...
April 15, 2010 at 8:45 am
I'm definitely against any government regulation in this area, but I do think that an organization like PASS should develop and publish guidelines for continuing education. I'd tie that...
April 14, 2010 at 7:40 am
RBarryYoung (4/12/2010)
Doggoneit! Does everyone one this site have better graphics than me? :angry:Great article too, Paul. Congrats. 🙂
I don't. I can barely include a screenshot....
April 13, 2010 at 3:37 am
Good post Paul, as expected. Clear, concise, and good examples. Looking forward to part 2.
April 12, 2010 at 6:03 am
So you want to have 1 visible and 2 hidden when you click a single hyperlink? There is no way to know which one is currently visible, so I...
April 8, 2010 at 9:52 am
I think the first method is better then the second with the unions because you are only scanning the source table once. If you have to cross tab/pivot it,...
April 8, 2010 at 9:50 am
For SQL Server 2005 on XP it would be "Documents And Settings\User\Application Data\Microsoft\SQL Profiler\9.0\Templates\Microsoft SQL Server\90". Basically user templates are stored in the user profile, wherever that may be...
April 8, 2010 at 9:39 am
I think logically that Gus's query using a CTE and your query using the derived table are the same.
April 8, 2010 at 9:35 am
Ann Cao (4/7/2010)
Thanks,but I still get multiple records for each person.
I only want the first records
Based on your original query you would expect to get multiple rows per person...
April 8, 2010 at 8:52 am
I had to ask the warehouse question because it does make a difference.
Are the inserts/updates typically single row or sets?
Does the application use stored procedures or ad hoc sql?
Is this...
April 8, 2010 at 8:43 am
The issue with putting the logic in a stored procedure that is called from within a trigger is that you then need to loop through the inserted table and call...
April 8, 2010 at 8:19 am
Could you post an image of a mock-up of what you want the report to look like? I'm still not sure exactly what you want to accomplish. I...
April 8, 2010 at 7:03 am
When you say warehouse application, do you mean an application that runs a warehouse facility or a data warehouse?
It sounds like your queries are doing clustered index scans, which means...
April 8, 2010 at 6:31 am
Viewing 15 posts - 3,076 through 3,090 (of 9,643 total)