Search results for query: *

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...

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

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...

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...

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...

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

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...

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

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%'

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) )...

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....

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...

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...

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...

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...

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...

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...

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...

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...

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