Hi,

BCP always overwrites any file that might already be there. There is no option to append.

However there are work arrounds for the same, either you can use following steps to...

river (7/27/2009)

exec master..xp_cmdshell 'bcp "select cod,nome,data from [SGCTcentral]..Vteste" queryout "c:\excel\teste21.xls" -c -T -S [fscg41\sql2000]'

I receive this error:

SQLState = 08001, NativeError = 17

Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]O SQL Server não...

Hi,

In that case you can try the bellow query

SELECT a.dt, COUNT(*) As Customer_Count

FROM

(

SELECT MIN(Convert(varchar,dateTimeStamp,101)) AS dt, CUS.customerName, CUS.CustomerID

FROM EasyRecharge.dbo.CustomerUsage CUS

INNER JOIN EasyRecharge.dbo.Customers_Dormant CNU on CUS.FromMSISDN = CNU.MSISDN

WHERE ([DateTimeStamp]

between '2009/07/01...

Hi,

This thing can be acheived using one querry also. I am not sure that all the three conditions need to be checked in the same table or different tables.

-- If...

Hi deepak,

I am just curius to know whether the above solution worked for 4th, 5th level of the child records. I tried here with some sample data but didnt get...

Having a lookup table for the PROCESS_TYPE is the best approach to handle your problem. You should not...

Hi,

You can use @@error variable. If the value is 0 that means some error has occured.

For ex:

IF @@error 0

Begin

--- Update...

Hi,

Use the following querry

SELECT

a.location AS Location, a.name AS Name,

a.wirelessnum AS 'Wireless No', a.rateplanmins AS 'Rate Plan Minutes',

a.rateprice AS 'Rate Price', a.featuresprice AS 'Features Price',

a.rateprice + a.featuresprice...

.

Hi,

The querry checks for the first occurernce of the Sales Order Id in the Sales order detail table. we can right select top 1 salesorderid (or some other column) from...

Hi,

You can use the following querry for better performance

SELECT h.SOID, h.CustomerNumber, h.PoNumber

FROM SalesOrderHeader h

WHERE EXISTS

(Select top 1 1

...

Hi,

Can you change the where clause from

WHERE PointsCategory = ISNULL(@PointsCategory, PointsCategory)

to

WHERE (PointsCategory = @PointsCategory OR @PointsCategory IS NULL)

This would definetly give some benifits.

You can change the delimeter of our string, use pipes("|") as the delimeter in place of commas.