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

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

Yes I have read article and found the solution

Thanks all.

Regards,

Arjun

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

thanks jasone

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

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

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

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

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

Regards,

Arjun

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