hello everyone about the sorting order in setting up new instances. if I was using the default one(case incensive etc) now we would like to...
Hi 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 1 ID CompanyName 1 A 2 B Table 2 <--this table only record the change in RatingName Value ID RatingName Value TimeStamp 1...
Hi Guys Thanks in advance. I have a view return 3 columns date amount series 1/1/2005 20 A 1/1/2005 20 B 1/15/2005...
Hi Guys I have two table 1 to 1 relationship with data in it already. what is the best way to merge them into one table? table 1 id,name .......
Hi 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 ? SELECT ......... FROM ........ WHERE ...... Union SELECT ............
Hi Guys 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...
Hi Guys 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...
Hi guys How come in SQL2000 I created a view with the following statement select c1,c2,c3 from t1 Union all select c1,c2,c3 from t2 order by 3...
Using commitTrans insert table1 some columns value insert table2 with scope_identity from table1 table1 id 3 table2 id t1_id 1 3 or...
Hello everyone 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...
Hi Guys Here is what I have id amount maturitydate daysleft is the different between getdate(todaydate) and maturitydate example id 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...
Hi Guys I have 2 table TableA a_id a_name 1------N 2------A 3------N 4------A 5------A TableB b_id a_id b_name 1------2------x I want a select...
Hi Guys 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...
Hi Guys We have Server1, windowserver2003, mssql2000 now we have another server for backup Server2,windowserver2003, mssql2000. Server2 is a child...
Hi 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.
