Search results for query: *

I searched previous posts and the FAQ, but didn't see anything about this. I have a table that is generated by a 3rd party software. The name of the second column is not static. It contains a date reference. For instance one time the column name may be FFEB07 and another time it may be...

I'm completely new at PS and I'm stuck. I feel like I'm right on the cusp of what I'm trying to do. Running Windows Server 2008 R2, IIS 7.5 in 32bit mode Here's my script: foreach ($i in Get-WebApplication -Site "Default Web Site" | Select-Object -Property Path) { echo $i $url =...

Is there any technology out there that would allow our corporate office to obtain local phone numbers in other states and have the ability forward incoming calls to those local numbers to cell phones (or any other phone really)? I know locally, we can go through our phone company and get a...

CR XI (11.5.11.1470) SQL Server 2008 I'm having a problem getting the exact result I'm looking for and could use some help. I have 5 fields: CSize, Serial, WO, RefT, Lbs I have two types of records that are being displayed currently: Cyl record and a Ref Record This is the current output...

I have a few views that I'd like to see the original code, but when I edit the view it's showing the calculated date rather than the formula used to come up with that date. Is there anyway to keep SQL from processing the calculation so that I can just see the code? BTW, I'm using SQL 2008.

I have an MSDE 2000 database with several databases and stored procedures that I've duplicated onto a new server. The new server is Windows 2008 R2 running on VMWare vSphere 4. I've loaded SQL 2008 Standard SP1 onto this VM and copied all of the databases and stored procedures from MSDE 2000...

I have a cross-tab in a footer that looks like this: 11 113 12 123 1a 22 M Total B 852 1,110 98 0 445 1,596 858 1,596 C 1,194 843 517 257 0 9,117 2,561 9,117 N 1,521 622 134 7 1,110 12,748 9,178...

I'm trying to get an average weight (stored in the quantity column of itemkey 'refr%') of the contents of a particular line item(TS:3050) and also the count of TS:3050. I have one table that lists credit memo header info and that joins to another table that shows transaction line details...

I've been scratching my head for days on this error message : "The remote certificate is invalid according to the validation procedure" When I did google searches, I couldn't find anything relating specifically to Sharepoint. I finally figured out what the issue was and so I thought I'd...

Hi my name is Snakeroot and I'm.... oh wait.. not that AA. This may be a dumb question, but I'll ask anyway just in case :) I was just wondering if there's a way to call a backline, reach an AA and at this point dial out to another number?

I've been dreading asking for help on this one because this report is so lengthy and a lot of it has nothing to do with my question. I'm going to try to give you enough info to answer my question without making you wade through everything. For the sake of this question, I have 3 page headers...

I have a strange problem, I'm hoping someone has run across before. I'm using VB.NET(2005), Crystal XI R2, SQL 2000 I created a windows app that uses the reportviewer. I have a front end form to select the data that is passed to the crystal report's parameters. After the first report is...

I just wanted to document the code for this, so that it's easier for others to find. I had a heck of a time finding code to do this. Finally this thread lead me in the right direction: thread796-1012322 There were however a few typos when the original poster converted from C# to VB. Here's...

I'm not sure what to search for on this question, so I'm just going to ask the question. I have two queries built and I want the results to combine the AccountRef_FullName categories together. Here is the first query: SELECT SOPD.AccountRef_FullName, SUM(ILD.Amount) AS SumTotal FROM...

I have a summary page that looks like this: Main headings 5 Type 1 2 Type 3 3 Secondary headings 7 Type 1 5 Type 3 2 Other headings 1 Type 0 1 "Main headings"...

I'm basically running a query like this example: SELECT RT.serial, Rt.Customer, RT.Invoice, RT.RentalTxnDate, RT.TxnLineID,RT.Location, CD.InvoiceTxnDate FROM RentalsView as RT INNER JOIN InvoicesView as CD ON RT.serial = CD.serial AND RT.customer = CD.customer AND...

Can someone give me a couple of ideas about how to know if a cursor is necessary? I have a loop and I need to pull a variable line by line and immediately I'm thinking cursor, but after seeing all the warnings about not using cursors unless you really have to, I thought I'd ask for some input...

I'm working on adding a column to a temp table. I'd like it to be true/false. I would like to condition it from the field called CDTxnDate. (If the difference between the two dates is more than one month, then true, else false.) For now I've tried to simplify by just putting a static date in...

This is a new question in reference to an old post of mine: http://www.tek-tips.com/viewthread.cfm?qid=1402688 Same report, but I've moved the subreports from the report footer to the group footer. Here's the situation, I have different franchise locations that need to have a report ONLY...

Crystal XI w/ SQL 2000 Is it possible to display two seperate reports side by side on each page? Customer |Serial |Date |Invoice --> Customer |Serial |Date Cust1 23355 1/1/07 2043 Cust43 23433 8/8/07 Cust2 32344 3/2/07 23423 Cust32 22233...