Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mkrausnick

    Can't write to folder even though Active Directory effective permissions shows full control

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

    Can't write to folder even though Active Directory effective permissions shows full control

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

    CD (SaveDir) doesn't work in Windows 7?

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

    VFP-generated Excel 2007 workbook won't save

    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... /...
  5. mkrausnick

    &quot;Cannot show Visual Studio Tools for Applications editor&quot; error

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

    CTE error 4405

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

    CTE error 4405

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

    Including NULL results in PIVOT-based SSRS report

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

    Including NULL results in PIVOT-based SSRS report

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

    Utilizing two tape drives for one backup

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

    Utilizing two tape drives for one backup

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

    SSRS doesn't recognize passed parameters

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

    SSRS doesn't recognize passed parameters

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

    Combining select statements

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

    Error when using GetDate() in SP default parameter value

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

    Combining select statements

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

    Error when using GetDate() in SP default parameter value

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

    What .net framework version(s) should I install?

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

    Is there a 'max' function in T-SQL?

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

    Is there a 'max' function in T-SQL?

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

Part and Inventory Search

Back
Top