Friends, please analyse the above one also in comparision to datediff. I use it always and would...

Hi Karthik,

Refer to Jeff's mail above. That is how majority of us learned. You have been provided 2 approaches. One using local variable and another without them.

Any way, if you...

Using Datefunctions.

select getdate()-day(getdate()) as LastDayLastMth, getdate()-(day(getdate())-1) as FirstDayThisMth,dateadd(m,1,getdate())-day(dateadd(m,1,getdate())) as LastDayThisMth,dateadd(m,1,getdate())-day(dateadd(m,1,getdate()))+1 as FirstDayNextMth

I have used Export Import Data utility which comes along with MSSQL and it works fine.

Hi guys,

I got it done using VBScript, below is the code.

dim conn

dim R

dim F

dim fs

const adPersistXML = 1

set conn = Server.CreateObject("ADODB.Connection")

conn.open (application("connstring"))

set R...

Thanks Zahi and Hanslindgren,

I can do by using the IE and giving the command as URL and then by saving the file.

But my problem is that i want to do...

Hi Elise,

There is a second way also. One which I follow and you do not need to know that much about SQL Server....

Hi guys,

How do I direct the xml output to a file. What I want to do is to retrieve the xml through a query like,

select .... for xml auto...