Gurpreet Singh Gill's Q&A profile

• SQL Server Convert to DateTime

  I have a date filed 12/26/2006 and a time field 7:00am. How can I combine them in my select statement and get a DateTime field. declare @v1 varchar(20) select @v1 ='12/26/2006' declare @v2 varchar(20) select @v2 ='7:00am' select convert(datetime,@v1 + ' ' + @v2) but is safer to use the YYYYMMDD format for dates Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All

• Software Development for Windows Vista Directshow time stamp question

  Howdy, I am extracting the mp3 information from a .swf file and streaming to an avi file in directshow. I need to set up the time stamp on the audio manually. The problem I am having right now is that I can't set the time stamp in my way: (0, 2000000) (2000000, 4000000)(4000000, 8000000)(8000000, 16000000)(16000000, 24000000),.... As you can see, I want to use small step(4000000) to set up the timestamps for the first couple frames and then use a large step(8000000) for the rest of time stamp. When I use settime, I always get the error from directshow which says "the start time stamp is later then the end time stamp." I have printed out all the time stamp that I stamp on each audio sample and can't find any illegal time stamp. Al ...Show All

• SQL Server SQL Rptg Svcs in SQL 2005 Only ?

  I am in the planning stages of moving a fairly large app from Access to ASP.NET 3 / C# / SQL Server 2000 and am investigating report generators. We will need to produce - Standard paper reports (that can be output in PDF format) Excel spreadsheets The app will be mostly Win Forms, but there will also be Web Forms Is SQL Reporting Services available with SQL Server 2000, or would we need to upgrade to 2005 Is there a summary white paper anywhere on the capabilities of SQL Reporting Services Many thanks Mike Thomas Yes Reporting Services is available with SQL Server 2000. check the below link for overview of reporting services and sample reports. http://www.microsoft.com/sql/technologies/repor ...Show All

• SQL Server Issues With SQL 2005 Encryption

  Are there any pitfalls i should look out for when using the encryption in SQL 2005 That is really strange. The key ring is session based, may it be possible that you are using 2 different sessions to open the key and to alter it If not, I will appreciate if you can give us some more information to try to repro this problem (what client you are using, the script you are trying to run, etc.) BTW. You can run SELECT * FROM sys.openkeys to see the keys opened in the key ring. Thanks a lot, -Raul Garcia SDE/T SQL Server Engine ...Show All

• SQL Server Database mail configuration

  I have configured database mail using the wizard, but when I try to send a test message I receive the following error: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 Exception Message: Cannot send mails to mail server. (Failure sending mail.) Is there some more configuration I must do I have enabled mail using the surface area configurator. Thanks I would try using xpsmtp mail and forget standard SQL mail...it is a pain in the rear. You can get it (yes it is free) here http://www.sqldev.net/xp/xpsmtp.htm It is easy to set up and use and has teriffic documentation. I know this is not an answer to your question but I hope this ...Show All

• Visual C++ changes in namespace member in managed code not reflected in unmanaged code

  I have an unmanaged project (a simulation) that has a set of global variables within a namespace. Another project, this one being managed, acts as a front end for the unmanaged code, and changes these global variables on user input before running the simulation. The code for loading user input simply writes directly to the variables with their namespace qualifier. I then call the simulation, at which point the unmanaged code takes over. The problem is that those changes to the global variables aren't reflected once the unmanaged code takes over, almost as if there are two copies of the namespace. An example of how to duplicate this behavior: A.h: #pragma once #include <iostream> namespace N { static double namespace_member = 0.0; ...Show All

• Visual Studio Express Editions Can someome PLease help me!! i HAVE no idea how to use this!!!!

  I have no idea how to use C+. I would reall reall like to learn. I have looked at some sites allread but i did not find anthing helpfull. Can someon lead me threw the steps of making a game or how to get started Or if anyone knows a good site I could go to. Thank You - Ryan Hi I an using a book from wrox and it is a very very good book and lerns to make gams and the language as wall if you wnat more info about the book i will gladly help you : ...Show All

• Visual Studio Help disabling Just-In-Debugging

  I installed .net 2.0 yesterday and now Just-In-Time Debugging has taken over my apps I work on outside of VS.net. I have followed all steps I have found to disable JIT with no results. So then I uninstalled 2.0 and reverted back to 1.1. Still, the JIT dialogue pops up. The pages I am working on are classic asp pages and the last thing I need is these JIT popups. I have been unable to find any information beyond the checkboxes in VS.net. Could anyone shed some light on this If it matters, I am on XP Pro and run VS.Net 2003. Thanks. Ok, thanks. I now understand the problem. What are the values of "Auto" & "Debugger" under the AeDebug registry key Habib Heydarian Program Mana ...Show All

• SQL Server Parent Attribute Hierarchy

  Does anyone know how to create a parent-child hierarchy that can be expanded in reporting services as well as analysis services Currently, I have a dimension with three attributes: parent, child, and key. Everything seems to work fine in Analysis Services. However, reporting services doesn't seem to recognize the parent hierarchy as being a true hierarchy. Any help Thank you. There is only sinlge way to create parent-child hierarchy in Analysis Services. You dont have any choice here. Not sure about Reporting Services and how it is displaying parent-child hierachy. Moving thread to Reporting Services forum. Edward. -- This posting is provided "AS IS" with no warranties, and confers no r ...Show All

• Visual Studio VS.NET 2005 debugger hangs

  While debugging a .NET 2.0 app, VS.NET 2005 UI becomes unresponsive and then attempting to break the execution results in the error message "A fatal error has occurred and debugging needs to be terminated. For more details, please see the Microsoft Help and Support web site. HRESULT=0x80131c08. ErrorCode=0x0.". The debugging session has to be terminated. This happens at different times during the debugging session and it happens while stepping through the code when I try to continue the execution when I try to step out of a function I tried to debug this application in CLR debugger and noticed the same problem. I read about an issue with ContextSwitchDeadlock MDA and disabled it to see if it would have any effect. I was of no u ...Show All

• Visual Basic How to display correct subcategories after selecting a category from a combo

  I am developing an application that must have a category combo list and a subcategory combo list. My category combo list will consist of the following: Computers Printers Software If I select Computers as my category then I want my subcategory to display the following: Desktop PC Notebook Server How do I develop this using Visual Basic 2005 Professional together with SQL to achieve this Regards Dipendra Thanks for the details. I will be using combo lists to achieve this for the time being. Is the method the same ...Show All

• Audio and Video Development Validator Stopped Working

  The HD DVD Validator recently stopped working could it be because of an upgrade of internet explorer (7.0.5700.6) or do I need to install something again The simulator works fine. Greets! Try re-installing; it *may* have installed a custom JScript.dll that was then clobbered by IE. That shouldn't really have happened though... Can you get it to work at al, eg just by running with a / command-line switch ...Show All

• Windows Forms Non background image on a label.

  I want to show a little graphic directly to the left of a piece of text in a windows forms applications. The System.Windows.Forms.Label control seems like the obvious place to go for this... I create my Label control and set the .Image property to my image and set the ImageAlign property to MiddleLeft. Unfortunately, the image is underneath the text... not adjacent to it... not exactly what I wanted. (Nor what I expected since other controls, like Panel, call the property BackgroundImage if it is going to be painted under everything else). Then I think... no problem... the same thing happens in System.Windows.Forms.LinkLabel, and I know the solution. I am using a 16px image, so I set the left padding on the Label to be 16. (This works f ...Show All

• SQL Server sql query

  Hello All, I am using sql server 2005. I have a table with the following data.... Name date time load base Joe 01-01-2006 8pm-9pm 100 500 Joe 01-15-2006 8pm-9pm 100 500 Joe 02-10-2006 8pm-9pm 100 500 Joe 01-15-2006 8pm-9pm 200 500 Joe 02-10-2006 8pm-9pm 200 500 Joe 02-25-2005 8pm-9pm 200 600 Mark 01-20-2006 8pm-9pm 100 500 The first three rows have common data, but for the date. Similarly, the 4th and 5th row are similar to first three rows, but for the "load& ...Show All

• SQL Server How to add filter based on query?

  Hi guys, I have the following problem: I have several tables in SQL 2005 ( table GeographicLocations and other related to it ). I created a cube in SSAS in which GeographicLocations is dimension. I was able to add parameters but I need something more complicated: Having columns longitude and latitude in GeographicLocations I need to be able to return all locations within X (parameter) miles from passed GeographicLocation (parameter - GeographicLocationID ) I found SQL function that calculates distance from passed longitude and latitude of two points and T-SQL would like this: declare @GeoId int ; set @GeoID = 200765 ; select * from GeographicLocations as t1 where dbo . geo_distance ( t1 . longitude , t1 . la ...Show All