Viewing 15 posts - 3,421 through 3,435 (of 5,393 total)
I don't see any way other than creating a proxy account. Why is it a problem for you?
-- Gianluca Sartori
February 24, 2011 at 12:58 am
I'm afraid it's overcomplicating a simple problem, anyway you could also try this:
;WITH FlagCounts AS (
SELECT IND1, IND2, IND3, IND4, IND5, IND6, IND7, IND8, COUNT(*) AS CNT,
ROW_NUMBER() OVER(ORDER BY (SELECT...
-- Gianluca Sartori
February 23, 2011 at 10:31 am
WITH INDS AS (
SELECT CAST(IND1 AS int) AS IND1,
CAST(IND2 AS int) AS IND2,
CAST(IND3 AS int) AS IND3,
CAST(IND4 AS int) AS IND4,
CAST(IND5 AS int) AS IND5,
CAST(IND6 AS int) AS IND6,
CAST(IND7 AS...
-- Gianluca Sartori
February 23, 2011 at 10:20 am
Well, amazing! 😀
5 posters = 5 different versions of the same trigger!
You should be able to merge everything into a single trigger...;-)
-- Gianluca Sartori
February 23, 2011 at 9:38 am
I see a couple of issues:
1) You're assuming only one row gets inserted/updated at a time.
2) You're assigning to variables read from the source table (Table1) and not from the...
-- Gianluca Sartori
February 23, 2011 at 9:31 am
a_ud (2/23/2011)
-- Gianluca Sartori
February 23, 2011 at 6:22 am
SKYBVI (2/22/2011)
Gianluca Sartori (2/22/2011)
The space allocated by those objects cannot be reclaimed, even if not used.
To reclaim that...
-- Gianluca Sartori
February 22, 2011 at 7:31 am
Marco V (2/22/2011)
DBCC FREEPROCCACHEGO
Please note that DBCC FREEPROCCACHE flushes the procedure cache for the whole server. Depending on your database load, your server could suffer for some minutes due to...
-- Gianluca Sartori
February 22, 2011 at 7:29 am
Tempdb contains internal objects such as spools and hashes used by the queries.
The space allocated by those objects cannot be reclaimed, even if not used.
To reclaim that space, in SQL...
-- Gianluca Sartori
February 22, 2011 at 7:15 am
abhas (2/21/2011)
hi Sartori,table structure is same as presented in below link.
and i want to display servernames as mentioned condition above post.
thank u
Abhas
I guess you have to extract top 50 rows...
-- Gianluca Sartori
February 22, 2011 at 1:57 am
Your query can't execute, it is missing some GROUP BY clauses.
Can you post some sample data from the tables involved?
-- Gianluca Sartori
February 21, 2011 at 7:53 am
Grant Fritchey (2/21/2011)
And this post makes 10,000 points. On to getting 10,000 posts.Figured I'd break the threshold on The Thread.
Congratulations, Grant!
-- Gianluca Sartori
February 21, 2011 at 7:51 am
top 50 records from average of top 90% records
Top by what? Can you post table creation script, some sample data and the expected results?
-- Gianluca Sartori
February 21, 2011 at 6:25 am
I suppose you mean a replacement for ROW_NUMBER function in SQL 2000, right?
-- Gianluca Sartori
February 21, 2011 at 6:23 am
You're not saying where those results come from.
Take a look at the article linked in my signature line. You will see how to improve your question and get a quicker...
-- Gianluca Sartori
February 21, 2011 at 6:20 am
Viewing 15 posts - 3,421 through 3,435 (of 5,393 total)