Search results for query: *

Thank's I am sure I can get this running w/ PATINDEX. Never using it before.. THANKS

$ amounts do change thats one of the major problems as they are adding odd amounts all the time, and no need for a count.

True, but I still need to capture the 'F-One Time Set-Up Fee' by itself. As I have it now.....I am incorrcly capturing all set up fees with '%One%Time%Set-Up Fee%' Any other idea's?

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.

MS Reporting Services is great and free w/ MS sql2000 and YUKON. I just implemented it and it is GREAT!

Not working...pulling in 6 records(two records for every year) and when I modify it to contain say '08/16/2004' it still points to July enddate

Above solution pulls in 4 records all of which are in an end date of Aug. for today’s date we would be looking at two records from July enddate. Thanks for a new look at it though.

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

Great, not problem its working now..THANKS!!

Darn...Still just can not get it to give me any results. seems to have a problem with the group by still

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

Your a goddess, thank you so much. I will use the condition as I have some zips that are Canadian. so... Update t_av_contact Set zip = left(zip, 5) --or Set zip = substring(zip, 1, 5) where len(c_zip) > 5 and c_country = 421

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

PHV- That is a great start for me thanks!!! I am super new with VB what function does "For i = 1 To 5" play is that say the first 5 coulums = i?

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