Search results for query: *

Hello Everyone.. I have ask this question to many SQL Developer but nobody had given me better answer... On my form i have button save/upload History when user clicks on it, I want to save the data from WLCust_Denormalized to WLCustAct_Emp table... How would i save the data from...

Hello Guys I am new with IIS.. I have installed IIS on My machine Operating System : Windows XP Professinal IIS Server is running and now i when i try to write open from browser http://localhost i have error paga cannot be displyed... Is anyone knows how to resolve this situation. Thanks AD

Hello Everyone I have allready post this question on VB Forum but didn't get any response...... I have a VB program that calls a DTS package to import data from a text file into a database for reporting. The DTS package works wonderfully. The problem I'm running into though is creating an...

Hello Everyone I have a VB program that calls a DTS package to import data from a text file into a database for reporting. The DTS package works wonderfully. The problem I'm running into though is creating an installer for my app with the right DTS files. I'm using VB 6 and the DTS packages...

Following function create a table on MS Access Name WLMod_Denormalized... every thing works fine but now i want to change one property: How do i set all column names property called required = NO In short in this table required data entry = NO by default it creates a field with require data...

I want to run following query in command click event VB 6.0 support only 25 physical lines lines joined with line-continuation... so is there anybody can help me out...that how and where should i write this sql to execute... any help would really appriciate.. INSERT INTO...

Table Name : WLCustAct_Emp Structure and data CustLifeNo WLActCatId WLDayId WeekNo WLEmpTypeId 330374 FRI 1 330374 FRI 1 C 330374 M FRI 1 330374 M FRI 1 330374 M FRI 1 C 330374 FRI 1 330374 FRI...

Table Name : WLCustAct_Emp Structure and data CustLifeNo WLActCatId WLDayId WeekNo WLEmpTypeId 330374 FRI 1 330374 FRI 1 C 330374 M FRI 1 330374 M FRI 1 330374 M FRI 1 C 330374 FRI 1 330374 FRI...

Dim strSql As string strSQL = "INSERT INTO tblWLActCat_WLDay ( CustLifeNo, WLActCatId, WLDayId, WeekNo )" & _ " Select A.Cust_Life_Num, A.WLActCatId, A.WLDayId, A.WeekNo" & _ " from WLActCat_WLDay A Inner Join" & _ " (select distinct (cust_life_num) from CUSTTB...

Using Microsoft DTS Package object library I am executing DTS package with in VB environment WLActCat_WLDay – table has 5000000 Records (SQL Server Tabel) More detail on WLActCat_WLDay – No Index define on any field Custtb – table has 45000 Records (SQL Server Table) Cluster Index define on...

Using Microsoft DTS Package object library I am executing DTS package with in VB environment WLActCat_WLDay – table has 5000000 Records (SQL Server Tabel) More detail on WLActCat_WLDay – No Index define on any field Custtb – table has 45000 Records (SQL Server Table) Cluster Index define on...

Anyone can please help me out to solve this error "Incorrect syntax near '='." CREATE PROCEDURE [terrredesign].[P_Retrive_Dowload_data] (@strWhere varchar(8000))AS SET NOCOUNT ON DECLARE @Error AS Integer DECLARE @sql AS varchar(8000) DECLARE @sql1 as varchar(8000) DECLARE @sql2 as...

Table Name : WLCustAct_Emp Structure and data CustLifeNo WLActCatId WLDayId WeekNo WLEmpTypeId 330374 FRI 1 330374 FRI 1 C 330374 M FRI 1 330374 M FRI 1 330374 M FRI 1 C 330374 FRI 1 330374 FRI...

Table Name : WLCustAct_Emp Structure and data CustLifeNo WLActCatId WLDayId WeekNo WLEmpTypeId 330374 FRI 1 330374 FRI 1 C 330374 M FRI 1 330374 M FRI 1 330374 M FRI 1 C 330374 FRI 1 330374 FRI 1 330374 FRI 1 C 330374 FRI 1 330374 D MON 1 330374 M MON 1 330374 M MON 1...

CREATE PROCEDURE terrredesign.RetriveDownloadData @strWhere varchar(8000) -- This is the input parameter. AS Select A.Cust_Life_Num, A.WLActCatId, A.WLDayId, A.WeekNo from WLActCat_WLDay A Inner Join (select distinct (cust_life_num) from CUSTTB where " & @strWhere & " )B On A.CustLifeNo...

I have Designed DTS Package on My Local SQL Server. Job & Flow :.. On DTS Design screen I have only three things 1) I have Microsoft OLEDB Provider which connect to my local SQL server 2) Execute SQL Task : Which contain 5 store procedures (this store procedures update/delete some tables) 3)...

If i create Temporary store procedure from VB on SQL server and My application has more then 10 users.. so How does sql server handle this kind situation when multiple user are trying to create same name temporary procedure. Is it really possible? I have ask this question to VB developer...

Dim rsDowload As ADODB.Recordset clsMvSQLServerSP.CreateStoredProcedure sqlDB ( This Method Executed for creating Storeprocedure and sqlDB it's string variable which has some where clause long expression ) clsMvSQLServerSP.ExecuteStroedProcedure rsDowload (This Method Executed for execute the...

Thanks For your reply... a) master table terrredesign_WIActCat_WIDay has cca. 8,000,000 rows. b) final join result to insert into tblWIActCat_WIDay has some 2,000 rows. c) EXISTS() and JOIN are significantly faster than IN() --- You right on above things...let me tell your something in...

select cust_life_num, case merch_mon_ind when 1 then 'M' else merch_full_mon when 1 then 'M' else merch_part_mon when 1 then 'M' else null end,'MON' from #CustID9 I have errror "Incorrect syntax near the keyword 'when'" Is any one can please help me out what wrong with this select statement AD