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 Chriss Miller 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
  • 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

    There must be another way the argument/parameter can be pass to a procedure at the time of execution rather than predetermined since the argument/parameter can change each time it is executed. For some reason, I was thinking the user would be prompt for the argument rather than giving an error...
  7. ijitnoin

    EXCUTING A PROCEDURES

    In other words, there is no way a user will be a to select records for a criteria of the field that may change each time the procedures is executed. In Access, the criteria of a field is based on the value entered by the user, not pre-determined This could be = or >= ect. Thanks for your effort.
  8. 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...
  9. 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...
  10. 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.
  11. 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...
  12. 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)...
  13. ijitnoin

    CALCULATION IN CASE WHEN THEN statement is not working!

    I realized that in the datediff(dd,GetDate(),A) statement the GetDate() must be the second date; meaning diff(dd,A,GetDate()) was the proper way to get the diference. Otherwise, the number of days will be negative. That is why the [Over 90 Days] field had 0 from the ELSE rather that the THEN...
  14. 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]...
  15. 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...
  16. ijitnoin

    Comparison in CASE WHEN 1 > 0

    I want to know if anyone can tell me why the < or > is not accept or call an error in a SELECT statement like the following: CASE WHEN (0 < 5 THEN 'TRUE' ELSE 'FALSE' END
  17. ijitnoin

    Comparison in CASE WHEN 1 &gt; 0

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

    Help with Search using LIKE

    Select CASE WHEN A < B THE 'C' ELSE 'D' END AS [Y]

Part and Inventory Search

Back
Top