Peter Bernhardt's Q&A profile

• SQL Server Multiple column update statement

  Hi, I'm new to SQL Server but not new to SQL because I used it with Oracle. I wonder if it is possible to do this kind of statement on SQL Server: UPDATE TableX M SET (M.column1, M.column2, M.column3)= (SELECT T.column1, T.column2, G.column3) FROM Table_Y T, Table_Z G WHERE join condition)) WHERE EXISTS (join condition for TableX) Basically, I'd like to update multiple columns in one statement but for some reason I can not get it to work. What would be the equivalent on SQL Server Thanks for the help, Laszlo M Hi Laszlo, UPDATE TableX SET column1 = T.column1, column2 = T.column2, column3 = G.column3 FROM TableX M INNER JOIN (TableY T INNER JOIN TableZ G ON T.column4 = G.column1) ON M.c ...Show All

• SQL Server problem with Transfer SQL Server Objects Task

  I have the following problem: All Sp's and UDF's in one base database have to be compiled into five identical databases located in the same SQL Server in order to keep all those five db's stored procedures synchronized. I made a simple SSIS package which content one "Transfer SQL Server Objects Task" component. Hardcoded connection/Source db/Destination db and setup properties as " Drop object first " = True " Copy All Stored procedures " = True " Copy All UDF " = True Then I executed the Package right from Visual Studio environment and after the substantial thinking finally it show me a green light. But when I verified the result no Sp's in the destination database were re- ...Show All

• Microsoft ISV Community Center Forums Worksheet.Copy causes execution to stop

  Hi I am experiencing an odd behaviour from my VBA code in Excel. I have some code that has worked until recently. We have gotten XP instead of win2k, which i could suspect is causing this in some strange way. My problem is that i have the code below. In the line where i say Worksheet.Copy, the execution simply stops. No errors appears, nothing. <CODE> On Error GoTo ERROR: Worksheets(SN_MonthYearAct).Copy After:=Worksheets(Worksheet.Count) .... ERROR: MsgBox(Err.Description) </CODE> The variable SN_MonthYearAct is a constant containing the string "MonthYear Act", and a sheet with this name does exist. Worksheet.Count returns currently 8, and there are 8 sheets in the workbook. I have trie ...Show All

• SQL Server how to use the OLEDB command to call a oracle function?

  HI, I want to use the OLEDB command to call a oracle function, but i havnt found any materials about how to do that, my oracle function is as below: CREATE OR REPLACE function GET_ZONEID_FROM_SYFZ(ycz varchar2,xc varchar2,strat_id varchar2) return varchar2 IS  zone_id_result varchar2(10) ; begin  PKG_DM_DQ.GET_ZONEID_FROM_SYFZ(ycz,xc,strat_id,zone_id_result);  return zone_id_result; end; In OLEDB command transformation component, i fill the sql command with "select GET_ZONEID_FROM_SYFZ( , , ) from dual", but i dont have it worked. The error message is :provider can not derive parameter information and setparameterinfo has not been called. Who have any idea about how to make it work Thanks ~~   ...Show All

• Visual Studio How to Pass a Variable to an Expression in the ReportViewer

  Hi everyone, I'm not sure if this is possible, but I want to set an expression for the Visibility tab of a table that I have in a local RDLC report to check the value of a variable. Basically, I have a boolean variable, PrintSysInfo that is set in the Public Module of my solution: Public PrintSysInfo As Boolean = False I refer to it in another form where it can be set to True or False. When my report runs, I want to have this particular table show up only if PrintSysInfo is True. I was hoping to be able to go into the Visibility tab of the table, set it to Expression and then put in something like: =iif(PrintSysInfo = True, False, True) But if I put this in there and then try to run my code, I get the following e ...Show All

• Audio and Video Development How to turn Subtitles off?

  Hi there, i tried the following to select subtitles and switch them on (or off) switch (g_sub) { case "de_sub": Player.subtitle.visible =true; Player.track.selectSubtitleTrackNumber(1); break; case "fr_sub": Player.subtitle.visible =true; Player.track.selectSubtitleTrackNumber(2); break; default: Player.subtitle.visible = false; break; } The first 2 "case" definitions works well. They turn german or french subtitles on. If "g_sub=='off'" the default definition should turn the visibility off. Right Wrong. the last selected subtitle is shown, although g_sub isn't "de_sub" or "fr_sub". How can I ...Show All

• SQL Server How to Add Subtotal in a matrix which shows all colunms nut seletd vales of total

  Hi I have a Matrix Like This Sales Type AZ CA ID NV WA OR Total No Surplus 1 2 1 3 4 1 12 Reverted 1 4 2 4 7 2 20 Surplus 2 4 1 2 2 1 12 This "Total" is of All States(AZ, CA, ID, NV, WA, OR). But I Just want the total of just four states i.e(ID, NV, WA, OR). And I also Want that States which are not included in the total i.e(AZ, CA) Should also appears in the matrix , but their values should not include in the total. I have already applied the filter on the subtotal, but (AZ, CA) did'nt appears in the matixr after filter. thanks Regard Mohammad Yaseen Hi thanks for ...Show All

• SQL Server ODBC Excel Driver

  dear all: I used ADO to connection excel file(excel2003); below is the source code: Dim Conn,Driver,DBPath,Rs, defaultPath defaultPath=Replace(xlsFile, "\VQAUser.xls", "") Set Conn = Server.CreateObject("ADODB.Connection") Driver="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & xlsFile & ";Extended Properties=""Excel 8.0; HDR=yes;"";" Driver="DBQ="&xlsFile&";DRIVER=Microsoft Excel Driver (*.xls);UID=admin;UserCommitSync=Yes;Threads=3;SafeTransactions=0;ReadOnly=0;PageTimeout=5;MaxScanRows=8;MaxBufferSize=2048;FIL=excel 8.0;DriverId=790" Driver="DRIVER=Microsoft Excel Driver (*.xls);DriverId=790;DefaultDir="&de ...Show All

• SQL Server Default SqlServer database creation path

  Hi, How can i get default sql server(2005) database creation path using Tsql/ or system stored procedure in previous(2000) i used undocumented sp(sp_MSget_setup_paths) to doing this. Thanks Dishan Hi, your post has been useful in pointing me to the right direction but I cant get xp_instance_regread to return a result set where the registry entry has spaces in the key. So it works perfectly fine for example: master . dbo . xp_instance_regread N 'HKEY_LOCAL_MACHINE' , N 'Software\Microsoft\MSSQLServer\MSSQLServer' , N 'DefaultData' , @SmoDefaultFile OUTPUT But fails for master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServe\ExtendedProcedures', N'Xp_regread&Allowed&Pa ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problems getting XNA working

  I've installed all required files for MSFT Game Studio Express to function. I've installed SP1, released yesterday for Visual C# Express. I've installed the XNA framework, .Net 1.1 framework, .net 2.0 framework, the directX December 2006 SDK, and platform SDK (for other reasons). I've found that there's a problem getting the XNA Transport Server started. In this situation, I cannot deploy anything to my 360, which is sitting next to my computer, on the same network/subnet. When I manually run the XNA Transport server (C:\Program Files\Microsoft XNA\XNA Game Studio Express\v1.0\Bin\XnaTrans.exe), it gets further in deployment, and tells me that the 360 has timed out. While doing a packet capture using WireShark, It appears that my machine s ...Show All

• Visual Studio Express Editions VB 2005 Express asks always for registration

  I am not sure what went wrong but VB 2005 Express Edition does not stop popping up on me via NotifyIcon Balloon Message, telling me that I should click there to register. I repeated this steps already several times and got even the THANK YOU email but when ever I open the program again I get the same ... I have no idea what to do about it! Any suggestions No, I used the download version (VB EXPRESS 2005) - I open the program every day several times but it does not stop telling me that I have to register! I registered in the beginning when I first started the program. Now I still get the message in the systray every time I open the application. Clicking on it and logging in for registering makes no s ...Show All

• Visual C# generic methods

  I want to be able to implement a strongly typed IClonable, so that I can clone based on lineage. public interface IClonableObject { T Clone<T>(CloningFlags flags); // flags specify level of cloning } so that I have something that looks like: public class Foo : IClonableObject, IFoo, IBar { string bar = ""; public string Bar { get { return bar; } set { bar = value; } } T Clone<T>(CloningFlags flags) { switch(flags) { .... case CloningFlags.ShallowCopy: { return (T)MemberwiseClone(); } } } } and can use it like: Foo f = new Foo(); Foo b = f.Clone<IFoo>(CloningFlags.ShallowCopy); I know this syntax (and most likely logic) is wrong. tha ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Generating MipMaps

  Hi, When I create a texture using the code below the mip maps always come out as a solid color, how can i generate proper mip maps from the texture TextureImage = new Texture (device, ii.Width, ii.Height, 5 , Usage .None, format, Pool .Managed); SurfaceLoader .FromSurface(TextureImage.GetSurfaceLevel(0), textureTexture.GetSurfaceLevel(0), Filter .None, 0); TextureImage.GenerateMipSubLevels(); Thanks for any help, -Dave You are a victim of a common misunderstanding what GenerateMipSubLevels do. It is only there to create the mip maps for textures that are used as render target. And even then they need to create with special parameters. The function you are looking fo ...Show All

• Software Development for Windows Vista WinXP and CardSpace problems still not addressed.

  Hello CardSpace Crowd, I am working very much part time on integrating simple PoC that uses Liberty Alliance with InfoCard being provisioned instead of anything else. In order to do some work have to have CardSpace from user perspective working i.e. working wallet. Unfortunately it doesn't work for me, no matter what I try. I have Installed extension for FireFox and IE7, .NET 3.0 and it always crashes once wallet applet displays or rather tries to display the content. So if I open Card Space from within Control Panel it crashes throwing 'Class not Registered' exception and I have no way of debugging it, as I am out of my depths when it comes to .NET and Win. When I try to install any card (https://www.xmldap.org/relyingparty/ or http://lab ...Show All

• SQL Server shared data source

  I experimented a strange behavior using connections for data source inside packages in vss 2005. Suppose we have a tab1 in a develpment source db and in a test source db: tab1 dev db contains 100 records tab 2 test db contains 200 records I start developing a package using an 'ole db data source' task inside a data flow. When I change the data source from dev to test, strange thinks happens. The 'ole db source task' retrieve only 197 records ... but if I open the connection inside the connection manager pane and only after i click on the 'test connection' button tI get 200 records. The source db is a sql 2000 db server and I use ole db provider for sql server. Cosimo cosimog ...Show All