Forum Replies Created

Viewing 11 posts - 16 through 26 (of 26 total)

  • RE: Pivot

    Please try below query this help you.

    SELECT

    num1,

    STUFF((SELECT ';X: ' + cast(id AS varchar(MAX))

    FROM temp1 t1 WHERE t1.num=t2.num1

    FOR XML PATH('')), 1, 1, '') [id]

    FROM temp2 t2

    GROUP BY...

  • RE: i need .bak files

    Using below link you can easily create backup of database and easily found the .bak file because here you can provide the path where you want to save your backup...

  • RE: some one write query for this problem

    Yes I have read article and found the solution

    Thanks all.

    Regards,

    Arjun

  • RE: some one write query for this problem

    Hello Kingston Dhasian,

    I have tried this query but it has show error "Invalid column name DS.ITEM".

    I have converted this query as my table structure.

    Regards,

    Arjun

  • RE: There is insufficient memory available in the buffer pool.

    Thanks you all...

    One more thing i want to ask that if i have changed max server memory in sql server property then is it must to restart the service of...

  • RE: Assistance with this query

    please try now

    SELECT temp.EMPLOYEEID, temp.FIRSTNAME, temp.LASTNAME, temp.STARTDATE, temp.EMAILADDRESS, temp.ORGANIZATIONID, temp.JOBTITLEID From

    (

    SELECT row_number() OVER (PARTITION BY employee.EMPLOYEEID ORDER BY ACTIONDATE) as 'RowNumber',

    employee.EMPLOYEEID, employee.FIRSTNAME, employee.LASTNAME, employee.STARTDATE, employee.EMAILADDRESS, org.ORGANIZATIONID, job.JOBTITLEID

    FROM linkedServer.linkedDB.dbo.AUEMPLOYEE as employee

    RIGHT...

  • RE: Assistance with this query

    Try this query it will work

    SELECT temp.EMPLOYEEID, temp.FIRSTNAME, temp.LASTNAME, temp.STARTDATE, temp.EMAILADDRESS, temp.ORGANIZATIONID, temp.JOBTITLEID

    (

    SELECT row_number() OVER (PARTITION BY employee.EMPLOYEEID ORDER BY ACTIONDATE) as 'RowNumber',

    employee.EMPLOYEEID, employee.FIRSTNAME, employee.LASTNAME, employee.STARTDATE, employee.EMAILADDRESS, org.ORGANIZATIONID, job.JOBTITLEID

    FROM linkedServer.linkedDB.dbo.AUEMPLOYEE...

  • RE: Truncate table

    select * from sys.indexes

    where object_id = (select object_id from sys.objects where name = 'TableName')

    using this query u can check the index that is exist on your table.

    Regards,

    Arjun

  • RE: Assistance in converting INT into date.

    CONVERT(VARCHAR(10), cast(StartDtID AS datetime), 101)

    Regards,

    Arjun

  • RE: Need help with a query for report

    This query gives output as you required please try

    SELECT temp.BackupReqCode,max(case WHEN temp.ServerFunction='IS' THEN temp.CountOfOpsServer ELSE 0 END ) as 'CountOfISServer',

    max(case WHEN temp.ServerFunction='Ops' THEN temp.Countofserver ELSE 0 END...

Viewing 11 posts - 16 through 26 (of 26 total)