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 Rhinorhino 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: Steve95
  • Content: Threads
  • Order by date
  1. Steve95

    Increment

    Hi All I have created a sp in sql 2005 and from my table variable I am inserting into a live table and the last column in the live table is a colum labelled id data type: int. The values in this are incrementing by 1, I need to know what to put in my insert statement that will populate the live...
  2. Steve95

    Storage Size

    Hi All Iam new to sql and have been looking into data types. Please can someone tell me in plain english the pro's and cons of Storage size (bytes) or how they work related to data types. Many Thanks in advance
  3. Steve95

    Deleting Records

    Hi All I have need to know of an effective way to delete 2000 records from a table holding 4000 records. Their is a unique key ie. originalno. which identifies each record and also I have the originalno. of all the records that need to be deleted. But what syntax do I use to make this quick...
  4. Steve95

    Insert with multiple Values

    Hi All I have complied a SP in sql 2005, iam using a table variable to manipulate the data, in my final insert which is directing the data to inserted into a db table, it is coming back with the following error msg :- Msg 512, Level 16, State 1, Line 51 Subquery returned more than 1 value...
  5. Steve95

    Simple SQL

    Hi All Iam new to SQL espcially sql 2005, I have a select statement where Iam selecting to fields from a table and then at the same same adding the 2 fields to and outputting as a new column denoted with a t. I want to refine the select by the new the results that have been generated ie...
  6. Steve95

    Copying Table and Data

    Hi All Iam working with sql 2005 and have a table sitting on a different server and db. I want to copy the table structure and data across to another server, how do I do this? Many Thanks
  7. Steve95

    Declaring in SP

    Hi All Iam new to SQL SPs and have created a SP which starts off with a declare statement referencing a table variable. In the SP their are are various select and insert statements which manipulates the data and finally the data is inserted in a table. However I want to test an section of the...
  8. Steve95

    Multiply

    Hi All I am trying to multiply the following select process_yr from tbl_report where (process_yr*4) and its not working....some can some one tell me what Iam doing wrong... Many Thanks
  9. Steve95

    er

    Hi All Iam new to sql and stored procedures..... In a sp iam looking at a select statement has 'er' in it, what does do and mean? eg. from fin_datawh.dbo.tbl_Report_Exc_Rate er where rate_type_code like 'syse%'
  10. Steve95

    New to Stored Procedures

    Hi All Iam new to sql and stored procedures..please can someone tell me what the follwoing code does.... declare @rates table ( exchange_rate decimal (18,6), gbp_exchange_rate decimal (18,6), final_exchange_rate decimal (18,6), General_Purpose_Code_Name varchar(10), original_currency char(4) )...
  11. Steve95

    LOV Scehduled Job

    Hi All Iam using BOXi Rel 1 and have created a LOV and scheduled the job to refresh to later tonight. What I dont understand is where is this job stored if I want to change the time? I have checked the repository and and the cmc.....Strange.... Many Thanks in advance....
  12. Steve95

    BOXI rel 1 act as a DTS?

    Hi All Iam trying to create a LOV for a parameter for a report I have created in CRXI rel 1. My data source is a Lotus Notes view, which gets updated on a daily basis with new entries. I have a destination table in sql 2000 which reflects this. Now what I want to do is automate this, ie...
  13. Steve95

    Empty Field

    Hi All I have a report in CRXI Rel 1, from data source Stored Procedure. In one of fields which is data type 'String' their are blank values. I need these blank values to return in my report, however I have tried every where {field} = " " isnull ({field}) etc etc and I am running out of...
  14. Steve95

    Overwriting Data

    Hi All Iam new to sql and currently using sql 2000. I have just setup my first DTS. Feels good.....I have scheduled a Job to make the DTS run every day. What I want to be able to do is, when the DTS runs it overwrites existing data. So in the destination table only new records appear (if any...
  15. Steve95

    Week - Year

    Hi All I have a formula in my details section which brings back weekno and year as:- 38-2006 39-2006 etc etc I have a graph which points to this and also has a range option available. Since the new year, the user did not run this report and now needs a urgent fix, Typical user! When...
  16. Steve95

    Substring <>

    Hi All I am new to sql, I am working from a sql 2000 view. I need to set a <> criteria on a field called account. The account field is a datatype varchar. I want to be able to create a statement which basically stops a certain certia feeding through. I hope this makes sense, if I have missed...
  17. Steve95

    SQL Syntax

    Hi All Iam new to sql, Iam using sql 2000....I have a view which is returning 5 million records. I want to limit this down, I have 2 fields I want to limit this down by date and database type. The date field is datatype: varchar and the database type is datatype: varchar The problem starts...
  18. Steve95

    Cascading Parameter

    Hi All I am trying to create a cascading parameter and coming across some strange results. Iam using CRxi Rel.1 My data source is sql 2005 and reporting from a view. I have a field called 'zone' and each zone has numerous pages belonging to it, the field is called 'pagename'. Now what I want...
  19. Steve95

    Parameters

    Hi All Iam using CRXi Rel 1, I have a report where currently I have 2 parameters zone and page name. Under the zone parameter the user has a option to select one of eight and then select either the individual pages from the page name parameter or to select all. Each zone has around 30 pages...
  20. Steve95

    Extra rights to a user

    Hi All Iam using BOXi Rel 1, I have a user which belongs to a group. What I need to do is allow this user to be able to reschedule reports which have been created by another user of the same group? Anyone ideas how this is done? Kind Regards

Part and Inventory Search

Back
Top