Recent content by Hapr1

I have two tables in sql One is a supplier table with an autonumber supID,supname Another is a product table with productID,supname,supaddress,start year and end year. Now I get data for supname,supaddress,startyear and endyear using inputbox in vba. I have to use ADO connection to insert it...

Hi, I have a supplier table in sql with an autonumber field ,supplier name and supplier ID field.. I need to get the supplier name and ID using Inputbox in excel. Then I need to send that data to the supplier table in sql server? How do I do that? Thanks a lot...

Hi, I have a supplier table in sql with an autonumber field ,supplier name and supplier ID field.. I need to get the supplier name and ID using Inputbox in excel. Then I need to send that data to the supplier table in sql server? How do I do that?

Hi, I have a supplier table in sql with an autonumber field ,supplier name and supplier ID field.. I need to get the supplier name and ID using Inputbox in excel. Then I need to send that data to the supplier table in sql server? How do I do that?

yes, I figured it out. Thanks

I have a problem. I need to design a simple SSIS package, wherein I use an input excel source and an output SQL server table. All I need to do is to import data from excel to SQl server table by using a check condition on date column in excel sheet. In the package, I have an excel source...

Hi, I use SQL Server 2005 version and I am trying to built a simple SSIS package where I need to pass a variable with a preset value to a SQL command statement. The whole purpose of the package is to select some data from the SQL server with a particular Jobno and then put it into an excel...

Hello, I am having a problem with subqueries.The code works but i do not get the correct calculated output. I have the table structure and the expected output below. I need to basically find the max and min for each row within a table. the code needs to compare load_1 ,load_2 and load_3 on...

Hi, I have an IF statement Where I compare three variables If [@calendar_ID1]<>[@calendar_ID2] OR [@calendar_ID1]<>[@calendar_ID3] ELSE Else,I want to exit out of the Stored procedure.. What should I use. GOTO END is not working.. Can't use EXIT Thanks...

Hi Brian , How do I specify the 'else condition wherein exit out of stored procedure.. Thanks I can't use exit proc or end.. any ideas?

Hello, I am having problem in setting up an if statement where I have 3 calendar_id -@calendar_ID1,@calendar_Id2,@calendar_ID3. I need to check and see if (@calendar_ID1<>@calendar_ID2) OR if(@calendar_ID1<>@calendar_ID3) then I need to exit out of the stored procedure. How can I implement...

I have a question relating to subforms. I have a form1 from table1 and created subform1 using table2. Each table has a common field where it is linked.Now , I need to display a field from table2 in the form1? If i make a combo box in form 1, it does not work . it just remains the same for...

Hello I am new to .net. All I want to do is to design a web form which will collect details from users and then put it to a database. Now i know how to save details in a database. but I dont know to make a simple web form which can collect details from users . Also what is dataform wizard ...

Hello , I have a problem , I need to highlight a row in a table .How can I do it ? can i make it using query ?

Hello , I have a problem .i want to highlight a complete row ina table . how do I do it ? then I need to make this work in a macro ?