Viewing 4 posts - 106 through 109 (of 109 total)
You should add the PARTITION BY clause. Since I cannot run your code, I'll show you how to do that with a query that will also run on your...
July 4, 2008 at 8:35 am
Hi
What is your function doing with such a long text?
There are some ways to get a round this limit, but usually you do not want to process such long texts.
Post...
July 4, 2008 at 7:34 am
Hi
You could try
EXEC sp_who2
But if you want to get the counts, try this:
select db_name(dbid),count(*) NumOfConns from master..sysprocesses group by dbid
Hope this is what you were looking for
Tal Ben Yosef
July 4, 2008 at 7:30 am
I'm afraid the compiler is right...
Since this is a computed column, it cannot be used inside the same query.
The options are:
1. Include the salary function in the ORDER BY that...
July 4, 2008 at 4:00 am
Viewing 4 posts - 106 through 109 (of 109 total)