Search results for query: *

I discovered the solution to my issue, in case anyone else has the same problem. I had set the NT permissions in the new USERS$ share on F: to "Read Only" whereas the USERS$ share on D: had "full control" permission. So once I the gave USERS$ share on F: full control permission, individual...

Running Windows Server 2008 with about 50 users. I'm trying to move a few user "personal folders" to a different physical disk. The folder structure in both drives is the same: <top level>\...\Users\<userID>. In the current drive (D:) the Users folder has these explicit permissions...

I finally broke down and installed VFP on my Win7 machine. Cruising along fine, and then this completely unexpected error happens: This code: SaveDir=curdir() CD <some_other_folder_on_the_same_drive> . . some code . CD (SaveDir) yields "Invalid path or file name." I've used this construct...

Using VFP9 running on XP SP2 and Office 2003, I open an existing Excel 2003 file, add data to it, and save it. It worked fine. When I upgraded Office to 2007, it stopped working. I can still open and populate the workbook, but when I execute the SaveAs method, I get: with a "Switch To... /...

I am running VS 2008 pro SP1 on one computer and BIDS 2008 on a second computer. On the first computer, when I attempt to edit the script of an existing script task in an existing DTSX package, I get: Cannot show Visual Studio Tools for Applications editor. For help, click...

Hmmm. I don't understand. The entire CTE is based on only one table: oea_program_enrollment. It is joined to itself. Does CTE take the two parts of the join to be separate tables even though they are based on the same underlying table? To make things even more confusing, the following CTE...

I'm getting Msg 4405, Level 16, State 1, Line 1 View or function 'overlap' is not updatable because the modification affects multiple base tables. However, I'm only referencing one table. The purpose of the CTE is to identify and consolidate overlapping insurance enrollment periods. It is...

Never mind - my statement that rows with NULL values do not appear on the report was incorrect. I must have done something else wrong. Mike Krausnick Dublin, California

I have: select userloc,event_type,count(*) as cnt from ( select distinct userloc,event_type,clientid from table1 ) t2 group by userloc,event_type ) t1 pivot ( sum(cnt) for event_type in ([New] , [Renew]) ) t3 This produces a nice grid with user locations down and client events across. If...

Thanks. I'll give that a try. I'll have to buy the tape drive! Mike Krausnick Dublin, California

Bear with me please, I'm not an expert Arcserve user. We're running Arcserve 12.0 on Win2K3 with 1 HP Storageworks 448 Ultrium tape drive in a scsi dual-drive rack-mount enclosure. Our daily full backups are starting to need a second tape occasionally. If I just add a second identical drive...

Thanks for taking the time. However, the inconsistency in the default setting should not have kicked in, since I supplied parameters in the FILL call. There would have been no need for the system to supply a default value. The problem is the error message indicates the parameters I supplied...

This is probably an easy one but I'm stumped. I'm learning SSRS. I created a report based on a view using VS 2008 report designer. It previewed OK in the report viewer. I wanted to add a date range parameter. I changed the query to include the parameters in a where clause: SELECT lastname...

Right you are George. I knew that once, back in the cobwebs of my brain! Mike Krausnick Dublin, California

Beautiful! Worked like a charm. Mike Krausnick Dublin, California

Combining records from two different select statements requires a UNION operator: select <list_of_fields> from <list_of_joined_tables> UNION select <list_of_fields> from <_another_list_of_joined_tables> Notes: 1. The <list_of_fields> must be identical in both cases. The list_of_tables does...

When I do this: CREATE PROCEDURE [dbo].[MyProc] @p_EndDate DateTime = GetDate() I get this error: If I take away the parentheses it compiles but when I execute it with no supplied date I get: If execute the SP and supply a date, it runs with no errors. What am I doing wrong? Mike Krausnick...

Good point about the XP minimum requirement for .NET 3.5. So I take it that if I'm developing on XP forward in VS2008 that I only need .NET 3.5 and not the prior versions. Thanks for the info. Mike Krausnick Dublin, California

Thanks to you both. I figured as much, but not being a T-SQL expert, I thought I'd ask anyway. Mike Krausnick Dublin, California

Is there a one-statement way to code this T-SQL: IF @dBeginDate > '11-01-2007 00:00' SET @PeriodStart = @dBeginDate ELSE SET @PeriodStart = '11-01-2007 00:00' In VFP I would write dPeriodStart=iif(dBeginDate > {^2007-11-01}, dBeginDate , {^2007-11-01}) or dPeriodStart =...