Answer Questions

• ravindra_pn Help with SQL Update statement

  Hi I have fields in one table I need to update from another based upon certain criteria, the fields in question are :- Table1:- AddressLine1, AddressLine2, AddressLine3, AddressLine4,ID1 Table2:- Add1, Add2, Add3, Add4,ID_1 What I need to do is update AddressLine1 with the contents of Add1, AddressLine2 with the contents of Add2, etc,etc. But, if one of the fields is empty or contains the word 'NULL' then I want to update that field with the next 'populated' field along. eg, normally it would be something like:- Update Table1 Set AddressLine1 = Add1, AddressLine2 = Add2, AddressLine3 = Add3, AddressLine4 = Add4, From Table1, Table2 Where ID1 = ID_1 but I need an 'if' statement or something in there to check whether Add2 is blank or = 'NUL ...Show All

• Sivaraman subtotal in table

  Hello! How can I add into an object "Table" subtotal by page Note that a page is a relative term in SSRS. Some renderers (PDF, Image) produce hard page breaks according to the page size you set. In comparision, other renderers (HTML) support interactive features where the information displayed on the page may change based on the user interaction (e.g. toggled visibility, drilldown, etc.). That said, to meet your requirement consider: 1. Having a fixed number of rows displayed per page by adding a table group that uses the RowCeiling function. 2. Adding a group to the table that forces a page break at the beginning so the group footer of the previous group is on the previous page ...Show All

• andradrr protected sql database file

  how can I create sql database file and it cann't be use or open (open mean to design view or structure) . my case is: I have Acces db and this db has its own username and password, no body can read, write or view the designing, so it is useless. But there are somesoftware able to break and hacking db access. I think sql database file is more secure, so how can I do it Hi, Their are many ways you can secure your database refer http://hemantgirisgoswami.blogspot.com/2006/07/securing-sql-server.html You may restrict user accessing your database by creating User/Role and assigning proper privilege to them but if their is a SA privilege of BOX to user he/she can easily reset the privilege. for e.g. you have a database named 'my ...Show All

• bozo01 Import Flat Files

  hi all i using SSIS to import flat files and i need support how can i import flat file from folder inculed many files and when finish start to next and next ..... if can i select from flat files to add condition like Select * from.....where ...... thanks Hosam Abd EL-Wahab wrote: hi all i using SSIS to import flat files and i need support how can i import flat file from folder inculed many files and when finish start to next and next ..... if can i select from flat files to add condition like Select * from.....where ...... thanks You can run a foreach loop in your control flow to loop over every file... No, you can't do a select * from flatfile where.... Howev ...Show All

• learneroob Can't see a New Data Driven Subscription link

  Hi: I have SSRS 2005 standard but can't see the New Data Driven Subscription link so I am not sure how to create it! Please help.. Thanks. As far as I am concerned the data driven subscription is an enterprise-only feature. cheers, Markus ...Show All

• Maizatul Akmal Select Data from Two Tables

  The table Schema Employee: primary key (EmpID) EmpID EmpType EmpName EmpSalary OTAmount/Per Hours 101 0 Kumar 110 20 102 0 Anit 105 20 STF001 1 Mohan 6000 50 STF002 1 Malar 5500 50 Here EmpType 0 = Worker and 1 = Staff Attendance : primary key (AttnEmpID) AttnEmpID EmpType EmpName AtDate Status InTime OutTime 101 0 Kumar ...Show All

• JavaBoy Staying with the SQL Agent during Execution

  I need to create a stored procedure that triggers off a particular job in the SQL server 2005 agent, waits for the job to complete and then returns back the control to the calling application with the job execution results. As far as triggering off the SQl server agent is concerned, I can use the sp_start_job procedure. But what is the best way to wait for the job to complete execution (Because the sp_start_job proc returns back the control immediately after starting the job). I could use the sp_help_job proc in a loop and wait for the value of the "current_execution_status" column to change from 1 to 4...but is there a better way of doing this Appreciate inputs here. - Thanks, Manmeet Thanks Rob. Really Appreciate you inpu ...Show All

• cmwith How to debug stored procedure in SQL server 2005

  Hi all, I really need to know that " How to debug stored procedure in SQL server 2005 " please help me to solve my problem regards sujithf I cant see "Step Into Stored Procedure" wheni right click on a perticular stored procedure I am using SQL server management studio in 2005 Go into the Server Explorer and choose the database connection you are interested in. Expand the connection and drill down into the Stored Procedures/Functions folder. Choose the procedure/function you are interested in, right click and choose "Step Into Stored Procedure" so please help me to debug my stored procedures thanks regards sujithf Try the following: open vis ...Show All

• manick312938 Cannot connect to SQL Server 2005 April CTP from remote computer

  Hi, I am trying to connect to a SQL Server on a Windows2003 w/sp1 Server from a remote computer but always seem to get the infamous "Access is denied or Server Does Not Exist" error.  However, if I try to connect from the machine that is running the server, there is no problem. (Used sql account, server=mixed authentication) The windows 2003 Server is a single server installation with .Net 2005 Beta 2 Team Suite, Team Foundation Server and Sql Server - Installing these items  took me a while, but eventually I managed to install from scatch to end without any installation errors. I have triple checked that both TCP 1433 and UDP 1434 is open on my router and under windows firewall. I have ensured that TCP/IP is enabled in SQL Ser ...Show All

• e. ogas Smart Device CAB Project Detected Dependencies not included?

  Hi I have created a Smart device application for Windows CE 5.0 device using Visual studio 2005 and i have added the smart cab project to the solution. When I add project out in teh appllication folder, the detected dependencies are not included. Instead dependent files appear with red circle in solution explorer. My project uses .Net Framework 2.0 and SQL Server mobile 2005 and SQL Server mobile database file and some symbol files I need included all of them in my cab project and when user clicks on it (in the device) it should install all of them. Let me know why detected dependencies are not included in the Cab project and how can get all the above mentioned things to be installed along with my program Regards ...Show All

• DrawMusic Equivalence de ROWID in SqlServer 2005

  je cherche l equivalence de RowId en SqlServer 2005, surtout dans la clause where : exp : comment faire traduire cette requete en T-sql Update table set col1 = @col1 where RowId = 5; There isn't one, if you are talking about the kind of physical row pointer that I think Oracle has. But if you have a column named RowId (I hope not) then this statement would work just fine. What exactly are you trying to accomplish there is no support for oracle like ROWID , u'll have to make use of TOP, thats wat sqlserver provides for top n analysis. There's no way to use in the same way that Oracle. But you can do the following: To get the frist 100 rows: select top 100 * from your_table ...Show All

• MIC DA EDY could not deploy the cube

  hi hannes, i tried the option you had told me now i am getting that i dont have permission to create a object in the server i.e, the client on which i am wroking has no permission and i dont know how to give it... could you help me with this lalitha Hi Lalithak, You would use Manage Roles option in your Analysis Services Database. Good Coding! Javier Luna http://guydotnetxmlwebservices.blogspot.com/ See my reply in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=676039&SiteID=1 Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. Hi Lalithak, It is in your server. Good Coding! J ...Show All

• IrishWolf SSIS Package Execute Error

  While executing packages in a file from a procedure, I get error: Error: 2006-10-24 14:58:54.62 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Please let me know how to solve this error. Thanks Phil...That part was lost in traslation Rafael Salas Rreview the protectionLevel property of the package; if the value is EcnriptedWithUserKey anybody but the creator of the package can run the package. You ...Show All

• Jabber Configure Report Server with SQL Server Express with Advanced Services.

  I'm having a world of trouble with the Reporting Services Server. The install went fine. I went in to configure the Report Server and when creating the Report Server and the Report Manager virtual directories I get the following error: "The virtual directory could not be created. The previously set virtual directory will still be used." The problem with this is that I have not previously set a virtual directory. When clicking on the link I get the additional error information: "System.IO.FileNotFoundException: at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, Invok ...Show All

• Jebrew Property AnsiNullsStatus is not available for UserDefinedFunction

  I created a table valued function in SQL Server 2000 SP3 using SQL 2005 Management Studio, but when I try to edit it (Right-Click, Modify or Script Function As...) I get the following error: Property AnsiNullsStatus is not available for UserDefinedFunction '[dbo].[fnMyTDF]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo) I can edit it in other tools (Sql Query Analyzer) just fine. I'm in the sysadmin role. Versions: Microsoft SQL Server Management Studio 9.00.2047.00 Microsoft Analysis Services Client Tools 2005.090.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft ...Show All