Forum Replies Created

Viewing 15 posts - 1 through 15 (of 34 total)

  • Reply To: Rows to Column

    Thank you for  your response. As per your request I added identity  column in that table. Please help me.

  • Reply To: Date Range Dynamic Column count in sqlserver

    I need Query for this output. Frankly, i am not good in PIVOT

  • Reply To: Date Range Dynamic Column count in sqlserver

    In my requirements input parameter is

    Start date and end date.

     

     

    Based on count I want to create a date column. Based on this column I need a count.

     

  • Reply To: Need Query

    Thank You

  • Reply To: Need Query

    Sorry i did mistake my Question now corrected ,In my scenario i have two tables

    create table #tblCombineCourseMaster(Combinecourseid char(9),Courseid char(9))

    insert into #tblCombineCourseMaster values (‘110100013',’110100009’)

    insert into #tblCombineCourseMaster values (‘110100013',’110100012’)

    create table #tblSectionCoursemaster(courseid char(9),subcourseid...

    • This reply was modified 3 years, 2 months ago by  vs.satheesh.
  • RE: User Defined Function for following scnario

    Jonathan AC Roberts - Thursday, January 17, 2019 6:41 AM

    Function:
    CREATE FUNCTION dbo.udf(@RowCount int)
    RETURNS TABLE
    AS
    RETURN
    WITH X AS (SELECT * FROM...

  • RE: Sql server Log shipping across internet

    Sue_H - Tuesday, July 10, 2018 8:12 AM

    vs.satheesh - Tuesday, July 10, 2018 7:19 AM

  • RE: Quert Required

    Thank you for your reply. But my client using sqlserver2005.This Query not working in sqlserver2005.

  • RE: Query Required

    Thank You for replay.My client using SQL server 2005 . This Query not working sqlserver 2005.

  • RE: Decrementing total

    Dear Friend,

    Please give me same sql query for sql server 2005

    Regards

    V.S.Satheesh

  • RE: Interview Questions

    Thank you for ur reply

    What is sys.fn_get_folder? Is it system Function ? Which version?

  • RE: SQl DBmail problem

    Still I am not able to send a mail.Please give me s solution.

  • RE: Transfer the data

    Hi My question is i want move data from production server to testing server.I want take transfer the data in source to destination in all the 50 tables.But one condition...

  • RE: Interview Questions

    Thank You

  • RE: Missing Number Find out

    HI Still i am not getting answer.One small changes I use only one table,that table i store a values like a

    registerno

    101

    102

    103

    104

    105

    106

    107

    109

    110

    120

    121

    122

    123

    124

    125

    127

    129

    130

    I want following result like following manner

    101-107,109-110,120-125,127,129-130

    Please help me

Viewing 15 posts - 1 through 15 (of 34 total)