|
If you are using SQL Server 2005, you should consider using SQL Server Integration Services (SSIS) to produce your exports. This site[^] has plenty of useful information. I suggest you search it for information on exporting data to specific formats. Deciding what format to export your data depends largely on the requirements of the people who will be consuming the data. Have you discussed this with your users, and what have they told you?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hello,
I have datatable and it is populated with some values.
Is it possible to add a column in an exiting datatable now with a auto increment values?
I am trying like this but it does'nt wotk
dslistItems1.Tables[0].Columns.Add("ID", Type.GetType("System.Int32"));
DataColumn[] pk = new DataColumn[1];
pk[0] = dslistItems1.Tables[0].Columns["ID"];
//dslistItems1.Tables[0].PrimaryKey = pk;
dslistItems1.Tables[0].Columns["ID"].AutoIncrement = true;
dslistItems1.Tables[0].Columns["ID"].AutoIncrementSeed = 1;
dslistItems1.Tables[0].Columns["ID"].ReadOnly = true;
This code doesn't populate the values in the column
Regards,
Pavas
|
|
|
|
|
mpavas wrote: Is it possible to add a column in an exiting datatable now with a auto increment values?
It is possible to add a column in an existing datatable with data's in it .. but u CAN'T set it to autoincrement
Sathy
|
|
|
|
|
|
Hii all,
I want to know how to insert multiple rows into a single column with one single statement. I want structure something like this.
JobNumber Supply Parts
J001 Tyres
Bonnets
Engine
J002 Mirrors
Seat Cover
Is it possible in Sql Server 2005 or My Sql. I want to insert values where column JobNumber will have only one value and Supply Parts for that particular job number say J001 will have different values like above in SupplyParts column.
Any help will be greatly appreciated
Thanks
Imran
|
|
|
|
|
You want to have more than one table and set up a relationship between tables. Then you create a row that represents the "job" in one table, and a series of rows in the other table to represent the supply parts. The supply parts table would have a link back to the job table.
|
|
|
|
|
hi All
i have a stored Procedure that runs well ,So i want to Run this Procedure in DTS, i get this Error
Invalid Pointer
My Stored Procedure runs well in Query analyzer, but when i use it in a DTS it gives me that Error. This is the name of my Stored proc
SDE.ACTIVITY_PROPERTIES_WITHOUT_NEW_GV_vUYI @Error = ' '
wHAT IS WRONG
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Use the SET NOCOUNT ON at the start of the query in your stored procedure and SET NOCOUNT OFF at the end of the query.
This should help resolve "invalid pointer" error messages.
This is a known issue with DTS packages.
Regards
Guy
You always pass failure on the way to success.
|
|
|
|
|
Thanks man you are a Star its Working
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
You're welcome
You always pass failure on the way to success.
|
|
|
|
|
hi folks
Actually from an employee database table i am reqd to find out the duration of time from the date of joining of that employee till 1st Jan 2008. How to do that .plz help.The date of joining field is date_of_join.
Thanks.
skd
|
|
|
|
|
Something like this[^] (Assuming that you are working with Sql Server)
|
|
|
|
|
Hello guys.
Im looking for a select statement for vbscript to access my Birthday database and display all the people that celebrates their birthdays on that particular day given that the day and month corresponds with the system month and day.
")
end if
rs.close
set rs = nothing
end if
%>]]>
Here is my script at the momen.If you have a script that mite work or a website that may help.Please help .Thanx in advance.
kagiso
|
|
|
|
|
matjame wrote: you have a script that mite work
You've given nobody any idea what the tables are like in your database. You expect people to magically know?
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
i m having 2 table rolles and forms . rolles having a pk roll_id which is foreign key in forms table. now i want to update the forms table.but it is generating error. how to write the query.
|
|
|
|
|
shabi uz zaman wrote: it is generating error
That's not really helpful. You expect people to look in their crystal ball and know the answer for you. Try being more descriptive.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
You have defined that Roles inherit Forms... is this really what you intended?
|
|
|
|
|
how to select a singe qutoes value
eg:
SELECT fBrID,fDocNo,fIntDocNo,fDate FROM tblFinTrans WHERE fNote=erer'l
|
|
|
|
|
Not sure if there is a better way to do this, but I tried the following one and it worked.(Assuming that you are using the query inside a stored proc)
SELECT fBrID,fDocNo,fIntDocNo,fDate FROM tblFinTrans
WHERE fNote = 'erer'+<code>''''</code> + 'l'
Just in case there were two single quotes, then
SELECT fBrID,fDocNo,fIntDocNo,fDate FROM tblFinTrans
WHERE fNote = 'erer'+ <code>''''''</code> + 'l'
|
|
|
|
|
How to discover the foreign key information when using the new GetSchema command on the Connection object? I do get FK info, but cannot figure out how the tables and fields in this FK are related. For SQL2005 I get a FK name but not related table and field. Pls help.
Or could you give me the SQL query for the problem above?
|
|
|
|
|
Huh?
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
Is there a simple, ADO.NET native, way of obtaining a tables metadata without querying data from it?
-----
You seem eager to impose your preference of preventing others from imposing their preferences on others. -- Red Stateler, Master of Circular Reasoning and other fallacies
If atheism is a religion, then not collecting stamps is a hobby. -- Unknown
God is the only being who, to rule, does not need to exist. -- Charles Baudelaire
|
|
|
|
|
Le Centriste wrote: Is there a simple, ADO.NET native, way of obtaining a tables metadata without querying data from it?
A quick Google search[^] should provide you with the information you need.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
|
I have 2 tables Earnings and Payroll with ID as primary key and used in payroll as EarnID.
Now how to show the data in tabulated form i.e. is there a way to show
data as shown below as a view?
USERID | BASIC | HRA | DA | TRAV | BONUS
1 | 5000 | 800 | 200 | 0 | 500
2 | 8000 | 1200| 200 |400| 0
TABLES
Earnings
ID | DESC
_______________
1 | BASIC
2 | HRA
3 | DA
4 | TRAV
5 | BONUS
Payroll
UserID | EarnID | Amount
______________________________
1 | 1 | 5000
1 | 2 | 800
1 | 3 | 200
1 | 4 | 0
1 | 5 | 500
2 | 1 | 8000
2 | 2 | 1200
2 | 3 | 200
2 | 4 | 400
2 | 5 | 0
Thank you,
Prashant Koli
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
