Answer Questions

• Don Miller Jr Help with Case Statement

  I have the following code in which I need to check something in the ELSE. The problem is how to form it correctly. I could use a cursor I guess to transverse through the records. In the Else, I want to: 1) Check the count of the results of my statement. IF > 1 then check to see if m.original is between lowlimit and highlimit for any of those records found 2) If m.original is between the lowlimit and highlimit, then select Fee1 from FeeSchedul ...Show All

• Eric Gagne Scripting question

  I have two Transact SQL scripts and I want to call the second script from the first – is this possible in SQL server I am trying to do a port from Oracle (where this is possible) but cannot find the mechanism to do so in SQL Server. Eg if Script1.sql is BEGIN PRINT (‘Inside Script1’) //Invoke Script2.sql – how do I do this END where Script2.sql is BEGIN PRINT (‘Inside Scr ...Show All

• IanTP Mass flat file loading

  Here is what I'm trying to do in SSIS: - I have hundreds of flat files that were dumped during last several month from a legacy system. All files have consistent naming including date/time stamp and a prefix that defines what table will it end up in. What I need is: - build SSIS package to load exiting files - build SSIS package to load files on daily basis in future What would be the best way to loop through the file folder I ima ...Show All

• WickedlNl How i could connecting to Analysis Services from BI Intelligence Studio with server authentication?

  Hi: I have been working at client work station with BI Intelligence Studio but i want deploy the project in server machine, but my windows credential don't have sufficient privilege for do it. However i know the server credential for do it but i can't find the project settings for do that. The account you connect to the AS server as will need permisions to deploy the database. In the Windows Start menu ...Show All

• mbutcher opinion xp_fileexist

  Hi all, Sorry for spamming you with this, I thought it might be the best way to get your opinion on the topic. OVERVIEW: We should not use MS internal procedures, since MS has the right to change/remove them at will. Given that, should the following code be allowed, or not. If not, how does anyone suggest, handling checking for the existance of a file that has been given as a parameter to some T-SQL. ...Show All

• Sanjeev K Purohit Reference Dimension causing long processing times

  I have a reference dimension that is linked to a regular dimension that is linked to the fact table. For some reason, when I process the database with some small sample data, it take about 5 minutes to process, where it should take 10 seconds. I am using a reference dimension because it is a child-parent hierarchy, and I don't think I can merge it into the regular dimension. My work-around is to just include the link to this reference dimension ...Show All

• sandra0000000000 Stuck between "Failed to generate user instance" and "An attempt to attach...failed"

  I wrote an application using Visual Studio 2005 beta 2 which uses a SQL Express .mdf file, included in the project, for the database.  After installing Visual Studio 2005 RC and the SQL Express that comes with it (I followed all of the uninstall instructions first) I can no longer add a SQL Express database to any of my projects, nor can I open the SQL Express database in my original project.  When I try either of these tasks, I get th ...Show All

• Scott Anderson Need a function to return a comma delimited string from multiple columns and rows

  Columns in a rows are ClaimID,LineNo, Code1, Code2, Code3, Code4 A claim id can have multiple detail lines. I want to return a comma delimited string for all the codes found for a claim id. I have not created a function before. How do I loop thru a table similar to this While Table.claimid = @ClaimID Set @MyString += Code1 +"," + Code2 + "," + Code3 + Code4 Loop   You do not need a UDF to g ...Show All

• John Landreth Maintenance Plans and dtproperties table

  After restoring database from a SQL 2000 instance to SQL 2005 and setting up a maintenance plan to do an on-line Index Rebuild task, the following error is generated: Failed:(-1073548784) Executing the query "ALTER INDEX [pk_dtproperties] ON [dbo].[dtproperties] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = ON ) " failed with the following er ...Show All

• emmarussell Report Builder Color Pallette

  The default pallette of the report builder seems to the light blue-based colors. How do you change the default pallette to say be my company's colors I would think that is would be an extremely common request as almost companies like reports to be branded with their companies colors. Besides setting the default pallette when you say create a table or chart. The color picker for all color customization only seem to have a fixed set of colors ...Show All

• sloch Grand Totals in Table

  Is it possible to create column Grand Totals in a table in an SSRS 2005 report   If I try to add a footer in my table then do a SUM on a Group's field above it, it tells me that it's not possible to reference fields that are not in the on same level / scope.  What is the right way to create column totals in an SSRS 2005 Report Table I have one group in my report's table follwed by a footer in the table.  I have 2 heades abov ...Show All

• Ron Carr Upgrading MS SQL Server 7 SP4 Standard to 2005 Enterprise (Eval Edition)

  Hello, you all, I did all the stuff necessary for the upgrading (the Upgrade Advisor didn't say anything special), but the Setup says the following: " Name: Microsoft SQL Server 7.00.1063 Cause: The update is blocked. You can obtain more informations in the online help "Versions- and editionsupdates". Editions problem: The update is blocked because of rules for the editions update. " Is it possible that an upgrade is not poss ...Show All

• Dan D9182 joining a table to a user-defined function???

  Suppose I have a SQL Server table named 'gadget'. 'gadget' has an integer field named 'gadget_key', which is the primary key of the table. Now suppose I have a user-defined function named 'udf_gadget_values'. This function takes as its input parameter an integer variable named '@nGadgetKey'. This function returns a table which will always contain exactly one record. This one record has one field named 'nGadgetKey', which contains the same value ...Show All

• DanTi Setting DTS Connction object dynamically

  Hi: I have posted concerning this-I don't mean to double post but I have isolated the problem and have new information. (and I'm desperate!!) Please direct me to a DTS forum if this is not the place for this, I didn't see one. I am trying set the data connection object (ODBC to Sybase) twice in the same package but the Data Pump Tasks that use this connection don't seem to be using the new setting in the connection after the second time it ...Show All

• Walter Smith Data-driven subscription error

  I'm using Windows 2003 server with Sql server 2005 June CTP. When I create a data-driven subscription for a report everything works fine, the query that gets the subscribers from a database is validated successfully. The subscription is time triggered, but when it should start and deliver the reports I get a logon failure error. I use credentials stored securely in the report server. I tried it with sa account and it still doesn't work. When I t ...Show All