I have used bcp before, and it is pretty simple to extract to a file,

However this is a code that was assigned to me for a specific task to...

I totally understand what you mean, I will probably alter my trigger and return if they're any issues.

Many Thanks

Right i understand, I will take that into consideraton.

Thanks for that:-)

@Drew

How do you mean? Currently ev erytime an account is inserted into the call_list table, it automatically generates and that row is inserted into out_calllist table.

Is there an issue with...

if bigint is an issue, can nvarchar be used for the telephone number?

Thanks

Hi

It is ok i got it to work.

I did not ensure that both tables which have the column TelephoneNumber are set to data type BigInt.

One was set to Int. But...

Hi

Thank you for that, it works perfectly.

However, the TelephoneNumber field still does not appear when the trigger fires into out__calllist.

20120202 - Sorry, this is the date of the day it was created, therefore, if possible, I require todays date within the header, which Im sure you would use the...

20120202

100000,RamTallyman1,Ram,Kamboz

0,TALLYMAN,,TALLYMAN

1,tmInstall,,

3

Above is an example of a notepad, just showing a simple output of what the file should actually look like.

20120202 - the header of the file

100000,RamTallyman1,Ram,Kamboz

0,TALLYMAN,,TALLYMAN ...

Thanks Guys

Yes I meant columns, but I was just thinking about extracting rows of data, but just from the required columns

Sorry I did not comment it properly.

Just a few more...

DONE IT!

This is great!

No I did, I linked the database name twice.

But now I havent, it has now outputted to a text file.

But, is there a simple way of extracting certain rows from...

EXEC xp_cmdshell 'bcp "SELECT * FROM.TM37_1_2_ONLINE.dbo.USERS" queryout "C:\BMW\tsqloutput\gradfive.txt" -T -c -t,'

Ah. I have something else.

NULL

Starting copy...

NULL

4 rows copied.

Network packet size (bytes): 4096

Clock Time (ms.) Total ...

EXEC xp_cmdshell 'bcp "SELECT * FROM TM37_1_2_ONLINE.TM37_1_2_ONLINE.dbo.USERS" queryout "C:\BMW\tsqloutput\gradfive.txt" -T -c -t,'

Well I have changed it around and seems to come up with the same errors.

The users table definitely...

EXEC xp_cmdshell 'bcp "SELECT * FROM dbo.TM37_1_2_ONLINE.USERS" queryout "C:\BMW\tsqloutput\gradfive.txt" -T -c -t,'

The database name is dbo, and the schema name is tm37_1_2_online.

I query it out to the file i...