Forum Replies Created

Viewing 4 posts - 106 through 109 (of 109 total)

  • RE: get the recent publications from each user

    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...

  • RE: text, ntext data types problems in SQL Function

    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...

  • RE: Connection details

    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

  • RE: Problem on Virtual Column Sorting

    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...

Viewing 4 posts - 106 through 109 (of 109 total)