Answer Questions

• toughtalk LIKE clause in IF statement

  Can the like clause be used in IF statement or only applicable to SELECT statement e.g. IF (@lADDRESS LIKE '%P.O. BOX') BEGIN PRINT 'IGNORE ADDRESS' END Thank you Yog Yes.  Did you try the example you posted   It should work...   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < yog_23@discussions.microsoft.com > wrote in message news:aca634c4-82de-46fc-a326-926711b349e2@discussions.microsoft.com ... Can the like clause be used in IF statement or only applicable to SELECT statement e.g. IF (@lADDRESS LIKE '%P.O. BOX') BE ...Show All

• Alan Robbins Most effecient way to get "previous row" values?

  Wow, this board has gotten really busy lately - maybe 2007 is the year that a lot more people start using SSIS :) Anyway my question is this: If I have an ordered set of data in the data flow and I want to add a column, lets just say "previousID" that basically has the ID value of a column from the row immediately before it - what is the most effecient way of doing that I've done much more complicated things with running averages, mean, etc by creating an asynchronous script transformation, pushing the data into a datatable in memory and looping through row by row using variables etc to do the calcs... but I just have this feeling that there is a "lighter, faster, easier" way for just getting previous row's value (with ...Show All

• jss3426 Dateadd problem

  Try this: print dateadd(y,+4, '29 feb 2008') Funny how the 1 day that is used to go from 29 jan to 1 mar stack if you add multible years to a day. +4 year should put it back on 29 feb 2012, +3 years should put it on 1 mar 2011. Well, mabye it has been posted before, I just found it interesting. That is because you are using y not yy. Look in the BOL for the parameters. dy/y is dayofyear not year. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Stevo Zilik 1 project - Multiple packages

  Greetings SSIS friends, If I have more than one package within one project, how do I select which package I want to run first Thanks in advance. Hi Jamie, Thanks for your speedy response. I appreciate your time and effort to help a newbie like me. Okay, say you have Project A with Packages 1, 2 , 3 and 4 if I want my packes to run in the order 3, 1, 2 then 4 I would have to modify my project property to have it starting with package 3 then within package three control flow I have the execute package task for 1, 2 and 4 This make me want ask a rather obvious question. What exactly is the point of having a project I can understand that a project can have multiple packages but what is that makes the packages r ...Show All

• Modeller Checkbox

  Hi, In the reports tollbox there is no Checkbox control,In my report i want to add the checkboc control,How to add checkboc control to the toolbox. Please help me. Thanks in advance Hi, I tried in that way.I put one multivaled parameter that display all the available columns,Suppose i have the multivaled parameter named "columns" with values:Date,Empid,State.When user select date and Empid,Columns parameter returns the string in this format:'date,empid',then how we set the visibility property for the table columns based on this string.With this iam struggling. Please help me Thanks in advance Try this: in your column visibility expressio ...Show All

• yaotong Schedule SQL Express BAckup using SQL DMO

  Is it possible to schedule SQL Express BAckup using SQL DMO do I need to use WScript.Shell,SQLDMO.SQLServer,SQLDMO.Category,SQLDMO.Job, SQLDMO.JobStep,SQLDMO.JobSchedule I would like to schedule back up programatically in ASP. If I want to use WSH , It can only run VBScript and JScript files that are .vbs or .js. It does not run .asp files. If you wish to run the VBScript code contained in an .asp file in the WSH environment, you need to remove all of the HTML tags; the <% and %> tags, and rename the file with a ".vbs" extension. Also, remove all references to any of the ASP intrinsic objects. What would be the best solution is it possible to S ...Show All

• VSB how can I obtain message_id?

  Hi all! How can I obtain message_id when I SEND the message, before I execute RECEIVE statement Thanks a lot for the help! You don't have to have one message per dialog for this to work. I would say you want 1 Dialog per business transaction, that way any responses to any messages are on the same conversation group. You might want to send two messages rather than having to combine data from different sources in one message Are you sending to a service and then wanting to recieve from it straight after in the same code What are you trying to achieve with this code I still don't know why you need the message Id. Are you trying to manage state We didn't see a need to expose mes ...Show All

• dhino Connection String Encryption for SQL Server Mobile

  I'm seeking suggestions on how to go about encrypting a database connection string in the compact framework. It's something that I thought would be relatively straight forward as I've accomplished it without much difficulty in the full framework, but I'm stuggling to find a solution. I've been trying to implement a solution using public/private key asymmetric encryption using the RSA provider. I've essentially been trying to encrypt the connection string once on my development machine so that I can include both the encrypted connection string value and public key in either code or an external file. I'd then keep the private key out of harms reach. The problem I've encountered in doing this is that that RSA provider seemingly only allows ...Show All

• Uwe82 ACCESS SQL SERVER TO USE NORTHWIND DB (continuation)

  I went to Start>programs>sqlserver2005>configuration tools>surface area configuration. Next, I selected local and remote connections. Further, under this selection there is: Using TCP/IP only (SELECTED) Using named pipes only; and Using both TCP/IP and named pipes. Again, I received a message saying SQL server does not allow remote connection. Any suggestions Thanks!! Thanks for the link on how to configure the SQL server to allow remote connections! In step 3 for creating exceptions in Windows Firewall, the Instance ID is located and is showing as MSSQL.1. Even though MSSQL.1 is showing in the Instance ID, it is not active ...Show All

• Kolf Mssql - Mysql

  Hi! As a newbie I'm wondering if there is a difference between mySql and msSql. Will mySql -code and -tables work in a msSql database Thank you! Hi ! Well...thats depends. The code ported from mysql ill work if you only used the ANSI SQL compliant features. if you use any specific keywords or features of MySQL you will get a compilation / syntax error because SQL Server won’t know of these keyewords (like LIMIT). The relational data itself it compatible with SQL Server as you find an appropiate matching data type at SQL Server. Data Types differ in the different system, so while importing data in SQL Server you will have to decide how to convert (or match) the data(-types). HTH, Jens Suessmey ...Show All

• MaciekWojcik User initiated backups

  During the month end close the accontants want to have their SQL2000 databases backed up before they run certain processes. We (IT) run the backups using the SQL management console when they call. Is there a way we can allow the users to start a backup without giving them access to the SQL management console Or you can create that script as an adhoc job, as and when required they can right click execute that job. And refer this http://www.sql-server-performance.com/faq/sqlviewfaq.aspx faqid=137 about allowing them to view or execute the jobs. We'll explore these suggestions, they look like they should work for us. Thanks for your responses. It depends on how much ...Show All

• Matthew Roper Question using Render method

  I am using rendermethod to download the report in pdf form. i use the following: Dim stream As FileStream = File.OpenWrite(c:\reports\myreport.pdf) Can you please tell me do i need to save the report on webserver(reportserver hosting server) or on the client machine who is trying to download or view the report. what is the method and where shoudl i download. if it is client computer, please help thank you very much for the information. Displaying the report to the client would be to redirect the response stream to the windows and setting the response header to the right type: http://support.microsoft.com/default.aspx/kb/875447 Saving would be the same with additional saving the byte[] to ...Show All

• shade29450 How to write this query?

  hi guys, I run into this question again. Here is it. I have two tables like this: StoreVisit(StoreVisitID(PK), UserID, StoreID, LoginID, LogoutID) ProductOrders(ProductID, UserID, StoreID, OrderQuantity, StoreVisitID) What I want to do is, I need to find out the lastest store visit record and put the StoreVisitID into ProductOrders table for the same userID, StoreID. So what I tried is: update ProductOrders set StoreVisitID=sv.StoreVisitID from ProductOrders po inner join (select top 1 * from StoreVisit where UserID=po.UserID and StoreID=po.StoreID order by StoreVisitID desc) sv on po.StoreID=sv.StoreID and po.UserID=sv.UserID Where po.UserID=@UID and po.StoreVisitID is null When I run it, it shows the error: The column prefix po, ...Show All

• Norbifier Snapshot replication

  Hi, I am using SQL SERVER 2005 snapshot wizard to create snapshot. But as soon as i create a snapshot it takes away all the indexes and constraint for the tabels on the subscription end although i have this indexes and constraint on Publisher side. Can someone help me in finding if their is some setting to create a snapshot without losing indexes and constraints or if their is some other way to do this. Thanks, Prashant To give you more detail information: In new publication wizard: after you pick snapshot publication and reach step "Articles", after picked your article, there is a "Article properties" button on the right side of the dialog, click the button and select either "Set Pro ...Show All

• cssjm Problem of adding trusted accounts to reporting services: 'Some or all identity references could not be translated'

  Hi I created a new database called "TestReportServer" as mentioned in the installation instruction but I didn't see (or could select) the option "Create the report server database in SharePoint integrated mode". How can I select this option Do I need to remove the reporing services and reinstall it again Any suggestions After creating the database I get the error 'Some or all identity references could not be translated'. The user I selected is a local administrator and has permission to all groups starting with wss. I guess the database is not created as a sharepoint integration mode as I can start Server Management Studio and see the database. Is that a correct assumption I hope somebody out there can he ...Show All