Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: problem creating index on view

    both views are in the same schema.

    Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)

    June 10, 2009 at 8:35 am

    #1007451

  • RE: problem creating index on view

    I didnt get you. Can u explain me in detail by taking an example.

    Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)

    June 10, 2009 at 8:34 am

    #1007448

  • RE: capturing default return value of a sp

    Thanks.

    Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)

    May 10, 2009 at 9:03 am

    #991787

  • RE: Configuring the Report Server

    Hi Matrix,

    Thanks for the reply. Everything is installed alone in XP stand alone system. .net is working fine. IIS is working fine. I am able to run the reports...

    Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)

    May 3, 2009 at 9:22 pm

    #987907

  • RE: Configuring the Report Server

    i installed everything perfectly. My iis is working fine.

    Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)

    May 3, 2009 at 8:57 am

    #987824

  • RE: Finding the week of the month in sql server 2000

    Thanks John and Ashok

    Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)

    March 20, 2009 at 5:20 am

    #963421

  • RE: comma seperated parameter

    Hi

    Thanks for all the replies and suggestions. here is the query to get the required reuslt

    SELECT c.customer

    FROM #customer_master c

    INNER JOIN

    (

    SELECT cl.customerid,COUNT(DISTINCT l.languagename) AS langcnt

    FROM #customer_language cl

    INNER JOIN #language_master...

    Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)

    February 21, 2009 at 9:08 am

    #948171

  • RE: comma seperated parameter

    Thanks for ur reply. is there any other better way to do this?

    Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)

    February 19, 2009 at 9:42 am

    #946870

  • RE: stored procedure with optional parameters

    Hi,

    I got the solution. create sp like

    create PROCEDURE COMPLIANCE_TASK_DETAILS(@USR_ID INT, @OPERATION VARCHAR(10), @GET_ID INT = null,

    @GET_TASK_NAME VARCHAR(300) = null, @GET_STATUS VARCHAR(100) = null,

    @ASSIGNED_TO INT = null, @GET_COMMENTS VARCHAR(500) =...

    Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)

    February 2, 2009 at 5:45 am

    #936354

  • RE: ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure

    I am facing the same problem every now and then. Did u find any solution for this? I just restarted my server then its all fine. Pls let me know...

    Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)

    February 2, 2009 at 2:20 am

    #936292

Viewing 10 posts - 1 through 10 (of 10 total)