shwaindog's Q&A profile

• SQL Server Multiple time dimensions and inventory measures.

  I got 2 time-dimentions: [Week] Hierarchised dimension based on Year - Halfyear - Week - Day ! The supply calculated based on the Week-dimension sum( generate ( ascendants([Week].currentmember), iif( [Week].currentmember IS [Week].firstsibling, {}, [Week].firstsibling: [Week].prevmember ) ) + [Week].currentmember , [Measures].[Mutation] ) [Posting Period] Hierarchised dimension based on Year - Quarter - Month - Day ! The supply calculated based on the Posting Period-dimension sum( generate ( ascendants([Posting Period].currentmember), iif( [Posting Period].currentmember IS [Posting Period].firstsibling, {}, [Posting Period].firstsiblin ...Show All

• SQL Server using text file data in a SQL Task

  I have some fields in text file that I want to use in a SQL Task. What is the best way to read these fields and then plug them into the SQL Task Thanks Aref The text file include this line 20060721 through 20060725 This file is sent as a trigger that the daily production files need to be processed.                        I need to use the two given dates in the next delete SQL statement ad DATE_1 and DATE_2: DELETE FROM [SpecialtyPlate].[DBO].[RP_Temp] WHERE [RP_OFF_DATE] BETWEEN DATE_1 AND DATE_2 thanks Aref ...Show All

• SQL Server XQuery fn:id problem

  There is an entry in SQL Server 2005 Books Online ( http://msdn2.microsoft.com/en-us/library/ms190915.aspx ) that gives an example of using the id function. The example has a schema for employees where each employee element has an xs:IDREF attribute that references the employee's manager. The example then shows an XQuery to find a particular employee's manager by way of the fn:id function.... declare @x xml(SC) set @x='<e:employees xmlns:e="emp"> <employee eid="e1" name="Joe" manager="e10" /> <employee eid="e2" name="Bob" manager="e10" /> <employee eid="e10" name="Dave" manager="e10" /> </e:employees>' s ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DX 10 release

  so when is the SDK avaliable to Download. I tried to open the Instancing10 Sample with the SDK. but I get this error "could not initilize Direct3d 10, This application requires a Direct3d 10 class device running on windows vista or later" does that mean i need to install Windows vista ( I will get it soon from MSDNAA) so DirectX10 wont be supported on XP I have the latest drivers for my 8800GTS. ...Show All

• SQL Server Transactions - Back to Basics

  Hi all, I am having no end of trouble with transactions in the package which i am building. I now just want to go back to basics and see if someone can tell me where i should set specific transaction options. Firstly, my package runs a for each loop which loops through a directory of directories. In each of the sub directories there are 2 files. The first steps in the loop are to check if a folder has been processed previously, if so then it moves it to a specified directory. The reason that this is done first is that i cannot move the directory whilst it is being read in the foreach loop, so i pass the path to the next iteration of the loop. There is another file system move directory task outwith the foreach loop to deal with the last di ...Show All

• SQL Server sqlcmd

  I created a DOS batch file that runs SQL scripts that load tables in a specific order. Could you tell me how I can stop the script from running when an error occurs in SQL Server Any help would be appreciated... Thank you Sorry, I was corrected. I need this to happen in the window's batch file. I am looking for something like this... if errorlevel GEQ 1 exit else sqlcmd -S%SYS% -E -d%UDB% -iScript.sql REM echo “Done” Could you verify Thank you for your time... ...Show All

• Smart Device Development Find Key number pressed?

  using .NET CF 2.0 SP1 WM5 I am wondering if there is a way I can check to see what keypad key has been pressed on the Main Form Kepress event The keypress arg will only give me the keychar pressed, but I am wondering if I can find out from this what the actual key was pressed Is there a way I can find out I want to be able to still handle this event when the user presses the key. Thanks! thanks for the above reply- so is ImmGetVirtualKey completly useless In the sense, we can never use it to retrieve the actual virtual key When I tap the WM_KEYUP message, the wParam parameter contains the actual key code, but this it not what the documentation suggests, so I'm wondering how safe/portable it is to use this techniqu ...Show All

• Windows Forms Custom Menu's

  Hi Folks, I'm using MS Visual Studio with Managed C++ and I'm curious to know how I might go about trying to get Menu's that look similair to the fancy ones in MS Outlook 2003 Any ideas -Zero There's no "out-of-box" control in VS2003 to do this as far as I know. You can play with DrawItem/MeasureItem events in order to customize the painting, but in VS2003 this functionality is not provided by default. ...Show All

• Visual Studio 2008 (Pre-release) WPF not displaying images

  Hi all Today i sat down and decided to do some more work with WPF and i decided to try some stuff out with various images. But when i went to place a PNG image into my window it doesn't display. To clarify further i can see the PNG image in both the Visual Studio and Blend designers, but as soon as i run my app and the window loads with the PNG on it, i don’t see the PNG any more. Also, this same pattern seems to be happening with various other images that i have. Some work and others don't and all of them are included in the project in the root directory. If anyone can help me out on this that would be great. Thanks Anthony Here is the code if it makes any difference, although as you will see i am not doi ...Show All

• SQL Server Conditional Split Component - annotation issues

  Greetings SSIS friends, When I configured my conditional split component (directing the data flow in 2 directions) The annotation does not align properly with the lines. Is there anyway to shift the text as to make more presentable Thanks for your help in advance. Hi Phil, Excuse the silly questions! So how do I turn off the annotations ! I think I'd much rather add my own as the automatic ones don't seem to align themselves with the data flow lines. Shame. ...Show All

• .NET Development Listing methods using reflection in c#

  Hi, I am using reflection to get all methods defined in an interface.My interface is having a set of methods and properties.By using GetMethods function, it returns all methods in the interface including get and set of each property as functions.Is there a way to get only the functions wriiten by me in the interface Thanks in advance. Eby What i have done is shown here Assembly a = Assembly.LoadFrom(dllname); Type[] type = a.GetExportedTypes(); MethodInfo[] mi = t.GetMethods(BindingFlags.Instance | BindingFlags.Public); foreach (MethodInfo m in mi) { Methods.Items.Add(m.ToString()); } PropertyInfo[] pi = t.GetProperties(); foreach (PropertyInfo p in pi) { Properties.Items.Add(p.ToString()); } ...Show All

• Visual Studio Problem installing update

  Hi, I am trying to install an update for VS 2003, and whenever I open it, it will open up and say "Preparing to install" and just hang there. I let it sit there for half an hour and it didnt do anything. When I hit cancel, it will just hang and say "Canceling" and I have to shut it down w/ taskmanager. I think that it may be the msiexec that is the problem, because I have another program I am trying to install and it is having the same problem. I've looked high and low all over the web for a solution, any ideas Thanks, David ...Show All

• .NET Development Intelligent XML/HTML Parsing: Firefox/Netscape Bookmarks.html Format

  Hi, I have a question on how to parse/edit an html file with a specific format. I'm talking about the Firefox/Netscape's bookmarks.html format. Is there an easy way to write new bookmarks (essentially link and text in according to specified spec) to this file format I'm thinking is there a way to convert this format into an XML object in the .NET XML object format and manipulate it that way Please give me any thoughts you have on this specific problem, or the general problem at large. Thanks. Is there an easy way to write new bookmarks (essentially link and text in according to specified spec) to this file format You may use the File.ReadAllLines method and insert new bookmarks just before the fi ...Show All

• Visual Studio Express Editions Log view application

  I'm working on a little program called LOG View in Visual Studio Express. I have a couple of questions 1. How can I get another dialog to open up when I click on the "About" button in the " " menu 2. How do I get a open file dialog and when the file is selected and I click open it will load into the RichTextBox field I created I also want to know how to get it to select the file type as *.log. Thanks for you help, I'm new to Visual Basic. answer to first question: Use the code: Form2.Show() to show another dialog replace Form2 with the name of what you want to display. In the properties for the form you want to show, set the WindowStartPosition to: centerscreen. If you want a simple ...Show All

• SQL Server analysis Backup problem

  Hi guys, Im having problem in backing up my Analysis Database...Below is the error... "The semaphore period timeout has expired" Anybody who encountered this problem...Please let me know... thanks, Larry If you see this problem persisting please report it at Connect ( http://connect.microsoft.com/sql ) Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All