Search results for query: *

Hi I have 2 values I need to distinguish from 'F-One Time $30,000 Set-Up Fee' and 'F-One Time $3000 Dealer Socket Set-Up Fee' My problem is that if I SUM on c.nm_display_name like '%One%Time%$%Set-Up Fee%' I am capturing both 'dealer socket fees' and 'non described set up fees. Any ideas...

I am getting an error on my report server every time I do a "FIND" for an account number on my report. I have exhausted my search and need help on this one. Anyone seen this before? The error is as follows: Reporting Services Error ------------------------------------------------------------...

I am trying to upgrade my SQL tools from sql2000 to beta 2005. I only what to install the tools not a new SQL database. My options are A. SQL SERVER, B. ANALYSIS Services, both of which have a (install as virtual server option which I am not able to check) I have heard that ENT.Man and QUERY...

I am writing a sales report and only want the sales persons to see there sales report, so I have set up a column that stores the sales person NTLOGIN so....SalesNet/JDOE. Then in the data portion of the Report look like this: Select * from JulyComm where AELOGIN = User!UserID Getting errors...

I am looking for an easy way to extract and rename .pdf files from one main .pdf. This is a very tedious task taking me up to three hours to extract and rename 90 reports from 1715 page .pdf. I don't know how but thought I would ask just in case.

I am trying to put together an equation that will specify the correct interval based on ‘getdate()’(today’s date). For any give date you should have a maximum of two records returned one for EOM billing and one for MID(mid month) billing. Here is and example of the tables I am using...

I have 3 select statements I am using a UNION to bring them all together, is there a way to get a sum on the entire select statement? Results are still giving me more than one amount per id.acc(account #) SELECT a.id_Acc, sum(a.amount) as "Payments" from t_pv_payment b, t_acc_usage a where...

I am trying to change the zip code information in our SQL2000 DB, currently we are storing 10 digit zip codes. I am able to isolate the offending zip codes and change them to 5 digits but how do I do an update the table? select id_acc, substring(c_zip, 1, 5) as c_zip --into NEW_t_av_contact...

I have seven original columns have to work with for solving this problem. For every range of zip codes, I would like to break them up into single records, the problem being I have 3156 records and the ranges vary from 1 to 1000 zip codes per range. So, I need to construct a VB script or SQL...

I have seven original columns have to work with for solving this problem. For every range of zip codes, I would like to break them up into single records, the problem being I have 3156 records and the ranges vary from 1 to 1000 zip codes per range. So, I need to construct a VB script or SQL...

I am using Excel 2003, I have lots of data I need to autofill but need to make room for it first. I would like to inset a row on every other record so basiclly a blank row on every other line. Any shortcuts to doing this, very new to excel Thanks

I have eight original columns and one column I have added for solving this problem. For every range of zip codes, I would like to break them up into single records, the problem being I have 3156 records. So, I need to construct a script in SQL that with create an additional record for every...

I am using SQL server 2000 as a reporting server and would like to set up a DTS that runs every night to update about 20 tables. Currently I am dropping the tables and then just importing the new ones. The from sever name is NetMeter, the reporting server name is NetMeter_Test. Would I use...

I am tring to combine about ten table that contain phonenumbers. Is union the best way to do it or is there a better way? Also what is the best way to store the phone numbers nchar/float ect...? This is what I am tring but it is not working: create table animaster as select ani from dbo.AM...

I am trying to convert a datetime field BEGIN_DATE to come out as 03/15/1994 for example. does anyone have any ideas I tried BEGIN_DATE = convert(datetime,convert(char(10),BEGIN_DATE,101)) per a prior post but no luck as it still outputs the time any help would be great thanks

I am a new user but have seen reports that ask you the parameters you want to look at. Such as interval = to xyz and = xyz and you can enter the information you want to look at. I think there is an easy way to set this up but I don't know the key words to look it up or I just can't find it...

I am having proplems when I run a SQL statment were I get this error. Warning: The table 'dja_master_report' has been created but its maximum row size (8343) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds...