yes, but can you please tell if i mention rowpattern in OPEN XML like '/Payroll/Doctor' Only then will be the corresponding path for below i used "//" but getting only...

Can this be acheived through sp_xml_preparedocument

Got the Answer... Yippee..

Follow Answer 12 on link mentioned below 😀

http://go4answers.webhost4life.com/Example/ftp-connection-manager-set-ftp-59066.aspx

SSIS

Appreciated your views,

And yes there might be case when i need only few tables data which will be faster than a fullbackup.

But my main concern for same was that i...

Thanks it worked i just created clustered index and execute the query the space was reclaimed. 😀 😎

Hi Erland,

I know that @match does not put any effect on query i just added to let developer know which part define

define which filtration, and that is precise that...

Hi Erland Sommarskog,

This is getting the same result as my query above.

I would like to check match and non match row in one query.

I can achieve this by below logic

declare...

I am loggin my checkin and checkout time from office in a table , checkin is working fine but checkout depends when i shutdown my system any clue for same...

:unsure: I guess table to log data should also be created in master only , because when i did so i started logging data.

One thing i would like to ask...

HI Koen,

Do i need to schedule the same as i tried to add my procedure created in master database but logging the time in table of other user defined database...

Can you please elaborate this default trace.

;with cte as (select name, Markname,Marks,RANK() over (Partition by name order by Marks desc) as rm from(

select name,Mark1 ,

mark2 ,

mark3

from sample

) p unpivot

(Marks for Markname in...

;with cte as(

select name, Markname,Marks from(

select name,Mark1 ,

mark2 ,

mark3

from sample

) p unpivot

(Marks for Markname in (Mark1,Mark2,Mark3))

as unpvt

)

select name,Markname from cte

where exists (

...

Does it work with package configuration also ?