|
Generating a "virtual column" with "AS"
9/03/2006 1:19:19 AM
(Total replies: 1)
|
| Hello,
at the moment I try to solve this problem:
I generate an sql select statement.
In my table (I get the data from another department) there are two columns:
VOUCHER_MONTH (Integer, contains a month value)
VOUCHER_YEAR (Integer, contains a year value)
I want to build a new column (datetime) in my select statement which contains a special date:
The first day of month VOUCHER_MONTH and year VOUCHER_YEAR.
Example:
Column VOUCHER_MONTH: 5
Column VOUCHER_YEAR: 2005
I ... |
|
|
|
Re: Generating a "virtual column" with "AS"
9/03/2006 6:50:32 PM
(Total replies: 0)
|
| Hello robf,
I don't understand which result your code creates.
In my table I have two columns:
MONTH (maybe 6) > INTEGER
YEAR (maybe 2004) > INTEGER
I want to get the value "first day of the combination MONTH and YEAR", in this case :
"01.06.2004 00:00:00" (german time format: day.month.year time).
So I have to create a string using both values (which is the new "date" as a string) and then I have to convert this string into datetime so that I could use this new date column to ... |
|
|
|
Export and import of database views
14/02/2006 7:08:31 PM
(Total replies: 1)
|
| Hello,
I have a database including many views. Some of them depend on other views.
Is anybody there who knows a method to export, import, copy all the views without trouble?
Using the DTS-Assistant or executing Stored Procedures failes. Many errors.
Are a database's views stored in a system table where I could copy them like "normal" datasets?
Thanks in advance.
Thomas |
|
|
|
SQL Server 2000 Enterprise: Optimization of table design (many records)
29/01/2006 11:03:09 PM
(Total replies: 1)
|
| Hello,
I have a question about SQL Server 2000 (Enterprise Edition): is there a limit for the number of records in a table?
If no - what do I have to take care of when the number of records amounts 1 or 2 millions?
How could I optimize table design to make simple SELECT-Statements be executed in an acceptable period of time?
(definition of field data types, indices, etc.)
I hope I'll find somebody here who knows the situation and could give me advice.
Additional information: ... |
|
|
|
Re: SQL Server 2000 Enterprise: Optimization of table design (many records)
30/01/2006 5:56:36 PM
(Total replies: 0)
|
| Hello,
thanks!
In a few days I know more... then the asp (3.0, "old asp") frontend is ready for testing the performance.
Maybe I could reduce the length of the fields... I will see.
At the moment there's only one index set > the primary key.
Regards
Thomas
(PS: winter in Germany can be terrible ... sometimes) |
|