Answer Questions

• moondaddy How to find oldest file in a folder

  I may have one or several files in a folder that act as source files. How do I loop through the folder, picking the oldest dated file according to its 'Date Modifield' attribute. Do I have to use a Script Task or similar as I can't seem to find a way to do it with normal tasks. If so, does anyone have example code. Thanks P R W. I have not done that; but I think this thread can help you: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=632171&SiteID=1 Make sure you vote on that suggestion... ...Show All

• HSBF Lewe how to perform this statement?

  I am using this SQL in a stored procedure : INSERT INTO staff_address (staff_number, block_number , block_name) VALUES ( @staff_number , @block_number , @block_name ) and I want to update the value @block_number from blocks database with: SELECT * FROM blocks WHERE block_number = given_block_number OK, you want to do something along the lines of:   --- DECLARE @block_name VARCHAR(100)   SELECT @block_name = block_name FROM blocks WHERE block_number = @block_number --- -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     <Jassim Rahma@discussions.micro ...Show All

• badsign Error Starting Script Editor in SSIS

  I am having a problem in the Business Intelligence Development Studio. When I add and try to edit a Script Task or a Script Component, I click on the Design Script button and get one of two errors. For the Script task I get an error that states: Cannot show the editor for this task. (Microsoft Visual Studio) For the Script component I get: Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio) For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help! (I think the underlying cause is s ...Show All

• Gess Man Restart required after setting 'clr enabled' = 1?

  Is a restart of SQL Server required after changing the 'clr enabled' setting The SQL documentation clearly states that a restart of SQL Server is not required: The clr enabled option is an advanced option. If you use the sp_configure system stored procedure to change the setting, you can change clr enabled only if show advanced options is set to 1. The setting takes effect immediately after sp_configure is run. No restart of the SQL Server instance is required . I've seen updated documentation where it points out that this setting is not really an advanced setting, so, there is one error that was corrected. Also, the documentation seems to imply that RECONFIGURE is not needed. Although, after you run EXEC sp_configure 'clr enab ...Show All

• Zulbaric how to do this in SSIS? soory if i m a noob

  Hi all, Am trying to setup a SSIS package between a sql2000, sql2005 source and a sql2005 destination. I have 2 concerns, firstly, due to performance reasons (we have 2 huge legacy databases): After 1st run, Source table has: 1 - 1000 records Destination table has: 1 - 1000 records For 2nd run, Source table has: 1 - 1500 records Destination table has: 1 - 1500 records How I insert only the 1001th record - 1500th record, without touching the 1st to 1000th record Secondly, if there are any changes in values in the records 1st to 1000th record, how to I compare and only update the value that has changed Is there any particular configuration setting in sql that I can use Many thanks for any help provided. ...Show All

• daniel.ef Silly Query question

  I have been rewritting one of our applications to use SQL Express instead of Access. I am having a small issue that I cannot seem to resolve and have searched the forum thoroughly. My code is as follows: SearchPONo = Me.txtSearch.Text Set rs55 = New Recordset rs55.CursorLocation = adUseClient 'SQLSearchQuery = "SELECT * FROM POInfo WHERE PONumber LIKE '%SearchPONo%' " rs55.Open SQLSearchQuery, cn55, adOpenForwardOnly, adLockOptimistic Goto GetRecord GetRecord: If rs55.RecordCount() > 0 Then Me.DataGrid55.Enabled = True Set DataGrid55.DataSource = rs55 I am trying to get a PONumber from a user input textbox and if I replace the %SearchPoNo% with a partial of a PO Number ...Show All

• TiborK TSQL function to return numeric value of non numeric field

  I need to replace Access Val() functions with similiar function in sql. i.e. Return 123 from the statement: SELECT functionname(123mls) Return 4.56 from the satement: SELECT functionname(4.56tonnes) Any one with ideas please Thanks George this will extract the first few numeric chars from the string declare @data varchar(10) select @data = '4.56tonnes' select left(@data, len(@data) - patindex('%[0-9]%', reverse(@data)) + 1) ...Show All

• Enlikil inserting image in sql server

  Hi, is it possible to insert image file in sql server without using any widows or web application ..I mean from enterprise manager or sql query analyzer. thanks thanks guys Also refer to the books online about READTEXT, WRITETEXT, UPDATETEXT statements for more information. You could try to use SQL DTS from the Enterprise Manager which allows to load data from the file ...Show All

• Ramkumar Viswanathan Hanging Indent

  This one is probably very simple, but I'm not sure. I am using SSRS 2005, and I already have a custom assembly being used in the report, but I'm hoping I won't have to use it for this. In a table, a list of company names is being returned in a single column. Some of them are pretty long, so they wrap to the next line. If this happens I would to indent the next line. So, it should look like the following: Company Name Company A Company B with a really long name Company C Anybody know an easy way to do this The only I can think of to meet this requirement is handling this programmatically, e.g. by checking the field value length and breaking the text if exceeds the required width with vbCrLf concatenated with some padding and the ...Show All

• ruckuss SQL EXpress ADV. Services Full Text Search

  I have seenfound several posts about Full text Search and looked at the BOL but havn't found a simple how-to. If anyone could point me to or post instructions on configuring Full Text Search in SQL Express W/ Adv Services it would be great. So far I have completed the following: Created my database using SQL Expr w/ Adv Services. Database is monted in a SQL server instance not a user instance. In SMSE under database>properties>files checked the box "Use full-text indexing". What now. I have seen posts referncing using the template explorer in SMSE and the Full Text Index templates. I see four templates in my template explorer related to FTS . Create Full-text Catalog Create Full-text Index Start Full Population Stop Popul ...Show All

• Vladimir Chtepa Multiple DataBases single report

  Ok Here's the senario, I am currently designing a report which will be used in a production environment by multiple users. Now each of these users might be looking at a different production database, now i want to be able to create a single report that can be pointed at any one of these databases depending on which user calls the report. All the databases have the same structure but may contain different data, so in effect the query I am using can remain the same it is just the datasource connection info that needs to change dependant on the user and the database they are looking at. I could create multiple instances of the same report each with a connection to the different databases, but i would prefere to have only a single report. ...Show All

• Balwant Patel Update query runs very slow in SQL 2005 than SQL 2000

  Earlier I posted this query in SQL Server Database Engine forum. I am reposting it here. We have upgraded our database server from SQL 2000 to SQL 2005. To migrate the DB I attached the mdf file in SQL 2005. After migration website loads quicker than earlier but records updation ( no of records are 20k) got slowdown. I have found that update query run very slow in SQL 2005 as compared to SQL 2000. Although other select query and insert query run faster. Query is called from ASP (active server page) page. Changing of fill factor option from 0 to 70 also did not work. I also have set the competible leve to 90. OLD Sever Config: dual xeon 1GHz, 512MB RAM, window 2000, MS SQL 2000 New server Config: Dual Core Xeon with 2 CPU, 10 GB RA ...Show All

• TimStspry Error with Inserting data into DB2 database using SSIS

  HI, Inside SSIS's Dataflow task, i'm getting data using ODBC connection(in DataReader Source) for an iSeries library and trying to insert that into DB2 database (using OLEDB destination ). Mappings etc work absolutely fine,but on execution get error as given below: How do i resolve this error and load data in DB2 , Need help at the earliest. Thanks in Advance Amit S Here is the ERROR Message: SSIS package "Package.dtsx" starting. Information: 0x4004300A at Data Reader to DB2, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Reader to DB2, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Reader to DB2, DTS.Pipeline: Pre-Execute phase ...Show All

• Craig M Jackson Changing Reporting Website Language

  Hi We use English Server Operating Systems and Applications and German Client Software. When we use our for German language configured Internet Explorers the Reporting Website is displayed in somewhat horrible translations. How are we supposed to get the English website without changing the language settings at each IE we use You can remove the de driectory in the Report Manager\bin directory. This will disable the German translation. Just tried it myself and it works. Thanks, it worked :). ...Show All

• sxf select a tablename

  How can you get the tablename of the object you are selecting from to appear as a result of a query i.e. select tablename from table_'A' should return table_'A' I am creating a chronological list of activities using multiple tables and want to include the name of the table the record came from. Any help is appreciated. Yeah, agreed, You would just do: select 'tableName' as tableName, column1, column2 from tableName If you need this, and it is a reasonable need, I think... Hi, there is no way, you will have to use a static string to put this information in the resultsset. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- That's what ...Show All