Viewing 15 posts - 436 through 450 (of 3,232 total)
Kudos on sticking with a thread that is 2 years old!
June 15, 2010 at 3:54 pm
jmyren (6/15/2010)
After re-evaluating i definitely need a new approach. Thanks for the info.
If you can describe what you are trying to do, we can help you come up with...
June 15, 2010 at 2:52 pm
It would require dynamic SQL to get this to work. The catch is that the temp table will be scoped to the EXEC statement so you'd need to create...
June 15, 2010 at 2:26 pm
Cowboy DBA (6/15/2010)
John Rowan (6/14/2010)
June 15, 2010 at 9:54 am
If you let your homework go too long, it will become urgent. We are all volunteers here on this site so it would help us if you would do...
June 14, 2010 at 10:39 am
Can you show us what you have tried so far?
June 14, 2010 at 10:34 am
charipg (6/11/2010)
Can you please let me know how do we free up the memory and how frequently you do that?
Why would you want to free up the memory? Your...
June 11, 2010 at 2:38 pm
Your SQL Server database instance will reserve memory as it needs it. Once the memory has been reserved, it will not release it. It keeps it for buffer...
June 11, 2010 at 2:29 pm
So did that work and produce the same results as your original?
June 4, 2010 at 11:16 am
By the way, here's your new proc:
CREATE PROCEDURE dbo.myProcedure
@ID int
AS
SELECT
SUM(CASE WHEN SomeTypeID = 1 THEN 1 ELSE 0 END) as ColumnA1,
SUM(CASE WHEN SomeTypeID = 2 THEN 1 ELSE 0...
June 4, 2010 at 9:26 am
Viewing 15 posts - 436 through 450 (of 3,232 total)