|
Helo,
Can anybody help me!
I have 3 tables
first 1 have a header table with one row
the second table are all the data records
and the third is a trailer table!
So now i want to create 1 file
with all the fields of the header table separated through ;
then new line, the data table with the fields separated through ;
and finally the trailer table with fields separated through ;
i think i can do this with Bcp utility or something like this,
but i don't know how!
Please help!
Thank you
|
|
|
|
|
You can create a SQL statement giving you correct result set and then save the result to a file.
Use UNION and concatenate all fields from a table to a single field using desired separator
Mika
|
|
|
|
|
Ok, thank you but i want to put this in a stored Procedure...
So i can call it from out of a program!
A.
|
|
|
|
|
Well, you have several options
You can use BCP (with a stored proc or a select) and a format file to create an output file, but this relies on ALL rows having the same number of fields
You can use the idea of concatonating the fields together with your delimiter and use this query in your bcp with effectively a single field per rocord
You can just read the data into your program and write the file yourself.
Try Goggling for format files in bcp
There are probably other ways too, but I can't be bothered to do your job any more...
Bob
Ashfield Consultants Ltd
|
|
|
|
|
It doesn't matter. You can return the result set from procedure almost like you can return it from SELECT statement so wrapping the statement into procedure is ok.
|
|
|
|
|
What is the difference between Sql Server 2000 and Sql Server 2005
Thnx
|
|
|
|
|
One was released in 2000 and the other in 2005.
On a serious note, there are thousands of articles dedicated to this on the internet. All it needs is a simple search.
|
|
|
|
|
HI,
For this question please refer google because so many difference are there and i can't tell them on this forum then also i ll tell you from programmers point of view.
Error Handling:
In sqlserver 2005:
Addition of TRY/CATCH allows more mature error handling. More error_xx functions can gather additional information about errors.
In sql server 2000:
Limited to checking @@error, no much flexibility.
Language:
in sql server 2005:
All the power of SQL Server 2000 with the addition of CTEs for complex, recursive problems, enhanced TOP capabilities, PIVOT/APPLY/Ranking functions, and ROW_NUMBER.
in sql server 2000:
SQL Language enhanced from previous versions providing strong data manipulation capabilities
Hope this will help you
Reasons are not Important but Results are Important.
Swati Tripathi
|
|
|
|
|
For starters:
SSRS
SSMS
SSIS
“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan
|
|
|
|
|
|
Are you seriously that dumb that you cannot use Google? I suggest getting away from any career using computers right now.
Blog link to be reinstated at a later date.
|
|
|
|
|
U r the dumb who is completely dependent on google. May god just close the google for one day then dumbo how would find the solutions to ur probs
|
|
|
|
|
You ask a question to which there are many available sources of information, not least the Microsoft site which actually gives you a summary of the differences. You then complain when people suggest you look for yourself, and then further insult them when they suggest using Google.
Time you got some manners and a career change - if you cannot perform simple reasearch for yourself you will never make a decent programmer.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
And what would you do without CP to do your work for you rather than buying a book or doing some basic research? Based on your attitude, good luck getting ANY help from CP again.
Blog link to be reinstated at a later date.
|
|
|
|
|
Hi guys =D
im having a trouble in finding median (in a monthly basis) with sql with microsoft sql server...
can someone kindly help me =D
because im stuck with this part =(
below are my tables
NSWVIC TABLE
Region
DateNum
day_id
month_id
yearNum
time_id
TotalDemand
RRP
PeriodType
Month Table
Month_ID
MonthName
Thanks for the help =D
Regards
Jo
|
|
|
|
|
Ridiculous...What are we supposed to do with your table names? 
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
|
Hi,
I'm having problems finding out how to delete a field in a jet (Access) database via SQL code (using OleDbCommand in C# code). This field is set to Indexed=Yes (no dups).
From my research, it looks like I have to change the Indexed to 'No' before deleting the field?
I found this on the net, but if the field was created with MS Access app, I don't know the idxName to use in my SQL code.
DROP INDEX idxName ON tblCustomers
thanks for any help you can give,
Ron
|
|
|
|
|
 I need to replicate my database in SQL Server.
So how can I do it?
Nasrin
|
|
|
|
|
Try looking in BOL for replication - its a large subject
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I suggest you read BOL or get a book on SQL server management as this is not answerable in a forum post. Its the same as asking how do I set up SQL Server, answer, install it.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
In crystal report, you can select the printing direction in Layout tab between "Across then Down" and "Down then Across."
For Ex:
I have a dataset with 2 column:
id Name
1 Jim
2 Jess
3 John
4 Jane
5 Joey
I want the result to print like this:
id name id name
1 Jim 2 Jess
3 John 4 Jane
5 Joey
How can i do this in local RDLC report or is it even possible?
Please help/advice. I'm really stuck on this. Thanks in advance!!!!
|
|
|
|
|
What an odd request, I thought so last time you asked, obviously you got no answer. I will be surprised if you get one in the SQL forum for a CR issues. However heres what I have done when CR SSRS won't do as they are told.
Try getting the result in SQL server before passing it to CR. You may be able to position the data where you want it in a sroed proc and just stick the lot into a grid type control in CR.
I presume you have tried the CR forums and support - now theres sarcasm for you.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Umm... he's not really asking how to do this in CR, I think... 
|
|
|
|
|
He does mention CR in the OP and "local RDLC report", I have no idea what an RDCL report is and as he first asked this in the VB forum I got the idea it was a CR issue.
Never underestimate the power of human stupidity
RAH
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
