Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ijitnoin
  • Content: Threads
  • Order by date
  1. ijitnoin

    SQL STATEMENT FROM ACCESS TO SQL SERVER

    While executing a Access Application/Program, records are inserted into a table. This from a MS Access program to a SQL Server database (backend). The following INSERT statement was executed: INSERT INTO table_Import (RecordID, Ctrlno, [Check], CheckDate, Total, ImportDate, Side) VALUES...
  2. ijitnoin

    ACCESS AND SQL

    While executing a Access Application/Program, records are inserted into a table. The following INSERT statement was executed: INSERT INTO table_Import (RecordID, Ctrlno, [Check], CheckDate, Total, ImportDate, Side) VALUES ('3269BEA39C804C15822D826C55F5DAC2', '200605220997', '5006', #5/22/2006#...
  3. ijitnoin

    Importing data SQL Server

    Hello, Is it possible to import data (dbase or text type)from Access front end into tables linked to the MS SQL Server? When tables were linked to a Access backend, this work properly with no error messages. Basicly data is being input to the temporary table correctly, but one error I'm...
  4. ijitnoin

    ORACLE OR SQL Server

    My superviser asked me tell him why I would use ORACLE or why MS SQL Server 2000. If you was asked to remove a system out of MS ACCESS, what do you suggest and why?
  5. ijitnoin

    First and Last

    In a Access summary query, you can use the following: First(Date) or Last(Transaction) Is there a way of converting these over to a column in a query/view of the SQL Server. I tried MIN(Date) and MAX(Transaction), but I'm not sure either of these will be the same as the First or Last above.
  6. ijitnoin

    EXCUTING A PROCEDURES

    The procedure is as follows: CREATE PROCEDURE [dbo].[MFG] @Entered_MFG CHAR(5), @EnterBeginning_InvoiceDate datetime, @EnterEnding_InvoiceDate datetime AS Set nocount on SELECT qryBankMFGInvRmk.[CTRLNO], qryBatchMFGInvoiceSum.MFG,qryBatchMFGInvoiceSum.MinOfInvoiceDate AS InvoiceDate...
  7. ijitnoin

    EXECUTING/RUN A PROCEDURE

    Sorry, no message was sent on the last thread. I hit the Enter Key. After creating the procedure, as follows: Create Procedure x @Y datetime Set nocount off Select mmm, nnn FROM dbo.ttt WHERE ttt.date = @Y Set nocount on GO EXEC x 1 You can not tell what happen, no output/result/listing is...
  8. ijitnoin

    EXECUTION OF PROCEDURES

    If have created Views of which I assume can be called by an application to create a form or report. I am not sure how this work. My problem mainly is how to execute a procedure to see/test the output; verifying that the results are acquate.
  9. ijitnoin

    STORE PROCEDURES

    Can you call Store Produre within a SQL query? I create a procedure for the unknown parameters. I did not include every column in the previous query where the unknow was needed. I only referenced the column/fields neccessary to create the stored procedure as follows: CREATE PROCEDURE...
  10. ijitnoin

    Prompt For Unknown Parameter in WHERE

    Please Help! In Access, you could enter an unknown parameter in the criteria and you will be prompted to enter the unknown value. The following is a sample WHERE: WHERE (((qryBatchMFGInvoiceSum.MFG) = [Enter MFG Number, 5 positions]) AND ((qryBatchMFGInvoiceSum.MinOfInvoiceDate)...
  11. ijitnoin

    CALCULATION IN CASE WHEN THEN statement is not working!

    SELECT TOP 200 qryBatchMFGInvoice.MFG, qryBatchMFGInvoice.INVOICE, qryBatchMFGInvoice.MaxOfInvoiceDate AS InvoiceDate, qryBatchMFGInvoice.InvoiceStatus, dbo.qryBatchMFGInvoice.SumOfINV_TOTAL AS [Total Invoice]...
  12. ijitnoin

    Accept Column Names and AS names referenced later

    Help! SQL Server will not accept filename.SumOfInv_Total as a column name. Nor will it accept column names such as [1 - 30Days] as a valid column. You can not reference as column name use in 'AS' in sum, difference. SELECT qryBatchMFGInvoice.MFG, qryBatchMFGInvoice.INVOICE...
  13. ijitnoin

    Comparison in CASE WHEN 1 > 0

    SELECT qryBatchMFGInvoice.MFG, qryBatchMFGInvoice.INVOICE, qryBatchMFGInvoice.MaxOfInvoiceDate AS InvoiceDate, qryBatchMFGInvoice.InvoiceStatus, qryBatchMFGInvoice.SumOfINV_TOTAL AS [Total Invoice], qryBankMFGInvoice.SumOfINV_TOTAL AS [Total Paid]...

Part and Inventory Search

Back
Top