Answer Questions

• Scott Simms 64 Bit MSDASQL.DLL

  Is microsoft going to provide 64 bit version of MSDASQL ( OLEDB Wraper for ODBC) in future This was working great while accessing Data from IBM AS/400 on Iseries from 32 bit sql 2000. Now, it's all screwed up with rediculously slow OLEDB both from MS and IBM. I wonder if any of these guys really care! 64-bit MSDASQL (both AMD64 and IA64) will be released in Windows Longhorn Server Beta 3 and Windows Vista SP1. Pak-Ming Cheung, MDAC Team, MSFT. Interesting. It was my understanding that this technology had been deprecated. http://msdn.microsoft.com/library/default.asp url=/library/en-us/mdacsdk/htm/mdac_deprecated_components.asp +1 I need this as well... ...Show All

• i.eat.idiots.06 LinkTarget

  I’ve successfully used Link Target=_blank parameter to open drillthrough reports in SQL2000 sp2. After I published all my reports in SQL2005 it stop working : child report are opening in the parent report browser. Any idea why this happened (I’m using “jump to report “navigation) ...Show All

• chiraj Internal SQL Statement

  Need 1 SQL Statement to find out which databases have what tables with what Columns with what datatypes Jens, thanks a lot. regards matthias YOu can use the following statement per database: SELECT * FROM INFORMATION_SCHEMA.COLUMNS A per Database solution would have to include a variable changing the database context, which can be accomplished composing a string and executing it with the appropiate command for changing the database context and selecting the informationen with the query above with executing the statement using EXEC or sp_executesql. HTH, jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Hi, Sorry for c ...Show All

• killghost Flat file source nightmare

  I've been working 4 days non stop on this project, lost a complete weekend on it and I totally had it. Please have a look at this "simple" question: I have a for each loop that checks for csv files in a folder. The path of the file(s) is stored in a variable varFileName. So far so good. But then I start with a data flow task and inside that data flow task I need to access one of those csv files at the time whenever it loops. So my best guess is use a flat file source because that's the only task I see in the list that fits my question. But the thing is, you set up a connection to a....yes right, a flat source connection and there you have to select a flat file. But no, I don't want to select ONE file, I need to access them ...Show All

• Mohican same visual studio standard 2005 product key from the "ready to launch" dvd set

  Hi, I attended the Technet Ready to Launch event and obtained the dvd set, but when I tried to install the sql product, the software won't take the product key (the key is the same as the studio product).  Anyone experience the same Please contact our Support Services at 1-800-936-5800.  They should be able to help you now. Sorry for the delay.   Support has been set up to handle this very issue, and they have helped other customers with the same problem. Please contact them - they are aware of this issue and they can help you with your problem.  I unfortunately cannot. Chris I have the same problem. I participated both events (Visual Stuio and SQL 2005) an ...Show All

• trogdor2323 Drop down list for columns

  What is the best practice to build drop down lists for a database You know a drop down list so on the front-end a user has predefined choices instead of having to type everything in each time. You're asking about the best practices for the UI on the client side, then I think that depends on a coulpe of different things. If the query to generate the list is very simple, then I'd probably write code to retreive the data and populate the list each time the UI is shown. But there are some exceptions. If the data is likely to change (that is, other users are adding or removing things that would show up in the list) I would end up adding a "Refresh" pushbutton ...Show All

• deen dynamically resize a chart

  I am doing a report in SQL Server Reporting Services 2k5 , the report has a chart that displays data from a query. The question is: Is possible to dynamically resize the area occupied by the chart depending on the amount of information (variations of a category) to be displayed on it well, i have some kinda same problem, well in my pie chart, we have so many grous, so what happing , the lables which shows percentages, completely overlap each other, like if a chart is showing 20 groups percentages so they all overlap with each other, i hav data like 80%, and rest are arrround 2, 3, 5, 2, 1, 3, 4, percentages what should i do plz give us any suggestion Tanks Robert! I’ll try your suggestion ...Show All

• japt Move table from one filegroup to another?

  Hi guys, I'm in middle of database re-development as part of performance enhancement, I have re-group the tables to optimize query IO and created corresponding filegroups to house the data. Is there a way (or code) to move each table to their respective filegroups At the moment all the tables are on Primary filegroup. I have group the table into 6 section each to with the view to move each section into one of the 6 filegroups - each filegroup on different diskdrive I have looked at alter table command but can't find anything to allow me accoplished this task. Any ideas please thanks. Yes, it would move the data. There's a ON <filegroup>clause in the CREATE INDEX syntax. So, ...Show All

• bagjuice Passing a variable to the from statement

  Hi, I have the following sql that I execute against a flat file. The flat file has a fixed length header and trailer but variable length data section. I execute this sql to get the header and trailer details the data section is put through a process in integration services: SELECT substring ( bulkcolumn , 1 , 5 ) --<HeaderIdentifier, char(5),> , substring ( bulkcolumn , 6 , 10 ) --<SenderIdentifier, char(10),> , substring ( bulkcolumn , 16 , 10 ) --<RecipientIdentifier, char(10),> , substring ( bulkcolumn , 26 , 30 ) --<FileType, char(30),> , substring ( bulkcolumn , 56 , 8 ) --<CreationDate, char(8),> , substring ( bulkcolumn , 64 , 6 ) --<CreationTime, char(6),> , substring ...Show All

• MyKidsDad_62 How to handle report parameters of type DateTime?

  I have defined a report parameter StartTime of type DateTime. I would like to use it in my Chart as filter criteria for the date that is retrieved in my query to view the results beginning with the StartTime. So I defined in the Filter Tab: expression: =Fields!Date.Value operator: >= value: =Parameters!StartDate.Value A Preview fails because of different types string and DateTime. It seams to be the parameter that has to be converted to a string. The problem is that the query data are represented in the de-AT format: e.g. 31.01.2006 but even converting the date to a string using localizing formats do not end in a de-AT format but in 01/31/2006, probably because I am using english tools. Is there any easy solution to compa ...Show All

• Thunder2002 Problems with merging raw files opened as variables

  I have a group of parallel dataflow tasks that produce raw file outputs that I then want to merge together in a subsequent task. I use variable names for the raw file outputs because I want to the path to the files to be easy to configure for different deployment environments. Therefore, I've got a package scoped variable called pkgRawFileFolder and in each of my parallel tasks my raw file destination is derived from another variable scoped at the task level, called tskRawFileOutput which is evaluated as an expression equal to [User::pkgRawFileFolder]+"/RawFile_1" or similar (the name of the rawfile isn't important as long as each parallel task uses a different name). In the container task that performs the merge, I want a Foreac ...Show All

• Wilson Cheung trigger que

  All, I am confused what to do I have a parent table and more than 40 child tables for this table. I am tracking a change on these table, If a change is done on one of the tables either it is the parent or a child, I will update a column in the parent table Here is what I did, I defined a trigger on each table. when, when a change is made on the parent, the trigger will be fire and update a date column on it, that is fine with me. but the problem is this, when a child table is updated, a trigger on the child will be fired and update a date column in the parent table, and this fires the trigger defined on the parent table and update the column twice. I don't want this to happen. I want the triggers on the child tables update the date colu ...Show All

• PeterVrenken MSSQL 2000 -> 2005 - Schema stuff?

  Hi All, I imported a database backup with no problems. I can view the data using the Studio. However, I noticed that all the tables are now pre-appended with a Schema name. This also applies to Views. How do I get 'rid' of this as my application doesn't know about the Schema and claims that it can't find the Tables and Objects I'm referenceing in the web.config. Thanks, -Alon Hi, schemas were introduced in SQL Server 2005. if the object is no in the default schema of the user, SQL Server will search for it in the dbo namespace. So, there are several options for you to make it work: -Change default schema of the user which accesses the database to the schema the tables were imported. -Directly import the ...Show All

• Peter Mackay Inser Problem in the alternative of cursor

  Hi all I wanted to workout with while loop as an alternative of cursor. I am working in SQL Server 2005. I have a table TEST with following values tid tname 1 John 2 Sam 3 Peter I wanted to insert these records into same table or another table using following while loop. But I ended of inserting only last record in the loop, not each one above. --DELETE FROM test1 DECLARE @id int , @lc int , @rc int --SET ROWCOUNT 0 SELECT tid , tname INTO #Temp FROM Test SET @rc = @@ROWCOUNT --SET ROWCOUNT 1 --SELECT @id=tid FROM #TEMP SET @lc = 1 WHILE @lc <= @rc BEGIN SELECT @id = tid FROM #TEMP INSERT INTO TEST SELECT @id , 'ppp' FROM ( SELECT tid FROM #TEMP WHERE tid = @id ...Show All

• Mazzie Auto Reload of report on parameter selection??

  this might be a stupid question. I have a parameter which has a default value set to it. when a second value is selexcted is it necessary to click the view report button. Could it be set to auto reload on dropdown selection. I am using reporting Services 2000 Thanks. Hey guys, Would there be a runtime load function available for the above problem. thanks ...Show All