about the sorting order in setting up new instances. if I was using the default one(case incensive etc) now we would like to...
We just upgrade to Sql 2005, how do I setup so that the transaction log should be committed at day end and clear up ? thanks
May the best...
I have two tables
Table 2 <--this table only record the change in RatingName Value
ID RatingName Value TimeStamp
Thanks in advance.
I have a view return 3 columns
date amount series
1/1/2005 20 A
1/1/2005 20 B
I have two table 1 to 1 relationship with data in it already. what is the best way to merge them into one table?
I have a Server2003 with SQL2000 with a domain name all local user log into that. Now we have a spare server. I install server2003 with sql2000...
SQL2000 if I can't create a view can I create a store procedure ?
Here is what I want to do. We have some pdf files and want to create an asp.net to distribute them. I want to store the pdf into the...
I have a table Contacts(ID,name, phone, etc)
ex: ID can be duplicate since can be more than 1 contacts under the same company
1 a 34232423...
How come in SQL2000 I created a view with the following statement
select c1,c2,c3 from t1
select c1,c2,c3 from t2
order by 3...
insert table1 some columns value
insert table2 with scope_identity from table1
I have six table t1, t2,t3,t4,t5,t6 and I have the mastertable I just create, I will select 4 common column cc1,cc2,cc3,cc4 and...
Here is what I have
daysleft is the different between getdate(todaydate) and maturitydate
let say I have table Hedging, Repo, Swap, Futures, FX, Options they all unrelated but have the columns below in common. Can I create a Master Table...
I have the following table bonds,repo,swap,futures,fx,option they are unrelated but have some field in common I want to create a view for report to...
I have 2 table
b_id a_id b_name
I want a select...
Does anyone know how to use crystal report in VB6? I know this is not the right forum to ask but I only use this forum ever since.
in my vb...
We have Server1, windowserver2003, mssql2000 now we have another server for backup Server2,windowserver2003, mssql2000. Server2 is a child...
Does anyone know about DataGrid in VB6 ? I am using ADODC with DataGrid to insert directly to the database. Don't worries about the ADODC I just...
Hi I need help with the SQL code below. I have a table cp_issues after I select the maturity_date I want to update the column officetalk to 0 to...
Separate names with a comma.