Help BCP The Following Query

Expand Post »

Good Day All

I have the Following Query

MS SQL Syntax (Toggle Plain Text)
DECLARE @CurrentTime DATETIME
SET @CurrentTime = CURRENT_TIMESTAMP
SELECT tr.Descr [Room], tb.Purpose [Purpose], tb.Description [Description],
convert(varchar,datepart(hour,tb.starttime))+':'+convert(varchar,datepart(minute,tb.starttime)) [Start Time],
convert(varchar,datepart(hour,tb.endtime))+':'+convert(varchar,datepart(minute,tb.endtime)) [End Time],
tu.name [Requested BY] FROM tbl_booking tb INNER JOIN tbl_resource tr
ON tb.resources = tr.id
INNER JOIN tbl_user tu ON tu.id = tb.RequestedByUser
WHERE (day(startdate) = day(@CurrentTime))AND(month(startdate)=month(@CurrentTime))AND(year(startdate)=year(@CurrentTime))AND(tb.STATUS=1)
ORDER BY [Room],[Start Time]
FOR xml raw
DECLARE @CurrentTime DATETIME
SET @CurrentTime = CURRENT_TIMESTAMP
select tr.Descr [Room], tb.Purpose [Purpose], tb.Description [Description],
convert(varchar,datepart(hour,tb.starttime))+':'+convert(varchar,datepart(minute,tb.starttime)) [Start Time],
convert(varchar,datepart(hour,tb.endtime))+':'+convert(varchar,datepart(minute,tb.endtime)) [End Time],
tu.name [Requested by] from tbl_booking tb inner join tbl_resource tr
on tb.resources = tr.id
inner join tbl_user tu on tu.id = tb.RequestedByUser
where (day(startdate) = day(@CurrentTime))and(month(startdate)=month(@CurrentTime))and(year(startdate)=year(@CurrentTime))and(tb.status=1)
order by [Room],[Start Time]
for xml raw

This creates an XML, but now i want to store it in

Quote ...

C:\X.XML

how can i BCP this Query

Thanks

Similar Threads

Removing Query Strings in ASP.NET
php Query with combo box item in PHP
help with SQL query / view / count problem.... in MS SQL
Sql Query in VB.NET
Double MySQL Query in PHP

vuyiswamb

Reputation Points: 31

Solved Threads: 14

Posting Whiz

Offline

310 posts
since Mar 2007

Permalink

Nov 2nd, 2009

Re: Help BCP The Following Query

Why don't you handle this task at the application layer instead of the DB layer? Often time the MSSQL Service is not running with administrative rights and does not have filesystem access to the root drive of the disk, ie C:\

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Nov 3rd, 2009

Re: Help BCP The Following Query

Good Morning

This is not an Application, so i will not have a BLL or DAL. i have all the Rights to write to the File System. all i need is help to BCP the given query

vuyiswamb

Reputation Points: 31

Solved Threads: 14

Posting Whiz

Offline

310 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Extract table statistics DDL

Next Thread in MS SQL Forum Timeline: insert date

DaniWeb Message

Cancel Changes

User Name
Password