Answer Questions

• Tabas Update a record based of a record in the same table

  I am trying to update a record in a table based off of criteria of another record in the table. So suppose I have 2 records ID owner type 1 5678 past due 2 5678 late So, I want to update the type field to "collections" only if the previous record for the same record is "past due". Any ideas The problem is that the records are not in a set order. So, I use the previous record. Thats if I am understanding your reply correctly Sorry - I probably was a bit too vague. I have a table that has a ton of data in it. Think of it as an event type table, where there are duplicate owner ids. Now the table by a primary key named eventid. So I have to look at transactions by owner, and I get t ...Show All

• GethWho handling special characters using oledb to oracle

  hi, i am using oledb to connect to oracle. i want to know if there is a way to handle different character sets in this type of connection. for sql to sql, i have been using auto translate in the connection string. what about for sql oledb to oracle how can i make sure that the data from sql to oracle is transferred as is many thanks. You might be better off asking this on the Data Access forum: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=87&SiteID=1 -Jamie ...Show All

• doug finke Data with 0 values in pie chart

  I have created one report with expolded pie chart showing data along with labels. The problem is though one of the values in pie chart is 0, it still shows the colour in pie chart. For eg - The chart has two values - 'Yes' or 'No'. Though the value for 'No' is 0, it still displays the colour of 'No' on pie chart. Is it a bug in SSRS Is there any solution Please let me know!! Thanks in advance!! ...Show All

• Banhnam SQL Express, Saving Queries?

  I opened up a new project using Visual Basic Express, and selected the SQL object to start creating a database. Well I finished putting all of my tables together and started making the queries but for some reason I can't save them like when I finished making the tables. When I finished making the tables I could just click the disk icon and name the table and it would appear in a drill down menu on the left. However when I do that with the queries it just says it's saving in the lower left corner but it doesn't do anything I am new to VB & SQL so any help is appreciated. Thank you. Hi PMSAR, Whenever you saved a query it is saved in a file just as you save any document, it comes under File->Recent Files , it won't displ ...Show All

• Mateusz Rajca SQL Server Package Execution

  I tried to execute the package,which is importing the data from the Flat file(flat file from map network drive on other computer).But Packages are created and executed on Server.While i executing that package it shows error as "Package could not be found.". Please help me ASAP. Thanks in advance Whiz-kid wrote: I tried to execute the package,which is importing the data from the Flat file(flat file from map network drive on other computer).But Packages are created and executed on Server.While i executing that package it shows error as "Package could not be found.". Please help me ASAP. Thanks in advance Does the se ...Show All

• naguaramipana New to SSIS, where to research how to normalize and re-key tables and lookups?

  I am just getting started studying SSIS with Kirk Haselden's "Integration Services" book. The problem I am trying to solve would seem easy enough to solve in code, but I am still early in the book and would like to be able to focus on the aspects of SSIS that would help me expedite this with SSIS, or to find out early whether what I need to do cannot be easily done. The problem itself is simple enough: I have a database of roughly 100 tables. Ignoring the poor normalization in the database for the moment, my more pressing problem is that that I need to rekey all of the main OLTP tables from a mashup of different key schemes to UNIQUEIDENTIFIERS. For example, Client table is presenrly keyed on an INT, Client Number. ClientFile ...Show All

• Devesh Srivastava How to use variables for server connections

  Hello, Today is day two of using SSIS and having some issues adjusting. In DTS I would simply populate my global variables via an Active X step or pass them in at the job line. I am having a hard time being able to do either or in SSIS. Really all I want to be able to do is pass in a server name to the Connection of an execute SQL task from a scheduled job line. Same goes for any variable really ... how do I pass them in, and how do I assign them to specific areas of a task Thanks! Many of my processes (including this one) are designed to be very generic so that I can dynamically set specific items ... such as server name, database names, etc. So the current SSIS package I'm working on, I hav ...Show All

• viswaug Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)

  I just upgraded SQL Server 2000 to 2005 without any errors. Afterwards, I tried registering with sa and it failed. I registered with another sysadmin login to get into most of my databases, but I need sa to work for my backup software Idera SQLSafe to login to the database. Does anyone have any experience or recommendations I know my password is correct. Mindy Hi Mindy, This is curious issue. But, I need more info. What is your message client's content For example: Msg 18456, Level 14, State 1, Server <server name>, Line 1 Login failed for user '<user name>' Good Coding! Javier Luna http://guydotnetxmlwebservices.blogspot.com/ I can't believe this, but the pr ...Show All

• RSUser08 SQL Server Management Studio and SQLCompact

  Hi, just wondering if there are any plans to have SQLServer Management Studio Express connect to SQLCompact databases - given express and compact are both free products it would seem to make sense. Or am I missing some configuration setting that already allows SSMSE to do this - dont seem to be able to connect to a non SQLExpress datasource thanks, Roger Hi Roger, This is in our plan and we are working on it. With the release of SQL Server 2005 SP2, it will be integrated with SSMS express. Thanks Sachin ...Show All

• jme23 Exception in EnumMergeDynamicSnapshotJobs

  Hi, I'm manually creating dynamic snapshots for a push merge subscription, however I often get an exception thrown when I call EnumMergeDynamicSnapshotJobs. The exception says: Unable to cast object of type 'System.Byte' to type 'System.String'. The stack trace is: at System.Data.SqlClient.SqlBuffer.get_String() at System.Data.SqlClient.SqlDataReader.GetString(Int32 i) at Microsoft.SqlServer.Replication.ReplicationObject.SafeGetString(SqlDataReader lclReader, Int32 nColumn, Int32 nLength) at Microsoft.SqlServer.Replication.MergePublication.EnumMergeDynamicSnapshotJobs() at ART.AlphaRMS.DatabaseManagementLibrary.SMOCommands.CreateDynamicSnapshot(MergePublication publication, MergeSubscription subscription, String dy ...Show All

• dmkp231 Space problem in ReportServerTempDB.ldf

  As we have heavy reports.and due to large space occupied by reportservertempdb.ldf we have to manually detach the ldf every time in few days..how can i programitically minimize the space generating in reportservertempdb.ldf.. Give me some tips that i sud take care of for this issue.. WHat about: http://support.microsoft.com/kb/873235 Placing the commands in a job or using a maintaince plan will help you here. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Richard78 SSIS logic for storedprocedures

  Hi,       Do you have any suggestions of how to transform the below code in SSIS       I guess we should use foreach loop container...... also i would appreciate if you can post some related articles.   Praveen Dayanithi wrote: Hi, Sorry i thought the exact code can make you understand my problem easily.....neways this is wat happens in that code.... 1) Field1,field2,.. are fetched into a cursor from table1. 2) For each and every row in the cursor all the corresponding(may be severals records) records ar pulled out from a merge join resultser of table2 and table3. This is wat code does.... can you tell m ...Show All

• user11 new work in DTS package ?

  I'm an IT developer with an experience of 4+ yrs and mainly working in VB, ASP and in SQL SERVER.   Now i got an offer to work only with SQL SERVER DTS packages   Is it really works well for my career   My profile in the new offer will be like...have to conver the vb application into sql dts service.   Please suggest me !  Thanks in advace. Tan Q Not worth it, career wise. DTS is depricated and has been replaced with SSIS. If you're going to be an ETL developer using SSIS, why then yes, it'd be a good move! ;) ...Show All

• R.Tutus How to rename a table ?

  Hi all. I'm porting an application from eVB-ADOCE to VB.Net-SQL CE In the old application there are some SQL statements like this: "ALTER TABLE OldTable TO NewTable" Is there an equivalent instruction or a simple way to rename a table I was not able to find anything simple to do the same. I really need NOT to do something like SELECT * INTO NewTable FROM OldTable because the resulting table could go outside memory and/or spend too much time in elaboration. Please let me know what I can do. Many thanks ! Joao Paulo, I don't know how to say "thank you" for your kindness. I'm going to use your work just now. If you come to Milano (Italy), please let me know ! I shall ...Show All

• Lady Mog generate sp using wizards - have problem

  When I change some tables dbowner (design table > table and index properties > owner) I can’t generate sp using wizards (tools > wizards > database > create stored procedures wizards). What is the problem (User dbo haven’t any problem) could it be permission problem. check if you have rights to create proc in the Db hi, \which wizard are you referring to if it is the dot.net wizard, you need a primary key on the table or you should be using the required data provider in the connection string thanks joey Run sql server enterprise manager > tools > wizards > database > create stored procedures wizards. Yes I  have rights to create proc in the Db ...Show All