Answer Questions

• deezer Creating a Subtotal of select Groups

  Hi, I am working on a new reporting system using reporting services, but I cannot figure out how to create a footer row which will only subtotal select group totals. If anyone has a method to do this please help! Nathan When running this selective sum, i get a scope error. I have tried giving it a group name and a dataset. What am i doing wrong here is my code: =Sum(iff(Fields!CardType.Value = "Visa/Mc" O ...Show All

• ray_ch Unexpected function sequence error when using SQL_CO_FFO on stored procedure

  Hi all, In my ODBC program, I try to execute a stored procedure returning a unique result set, by using a fast forward cursor (SQL_CO_FFO), but I get a "Function sequence error" when fetching the first row. FFC forces the ODBC driver to use sp_cursoropen, which is fine for me because I need multiple active SQL statements. I appears that the content of the stored procedure matters. When the procedure implements only a simple SE ...Show All

• TechieVaibhav Different Results With View Versus UDF

  I have two views, for various reasons I decided to wrap a Select * From View with two UDFs. When run on their own, the UDFs return the exact same resultset as their respective view (did a compare and stuff to make sure). However, when I join them together, what was once 130,000 records (when joining the views) skyrockets into millions of records, and the resulting resultset is filled with duplicates. What is going on ...Show All

• GerryH Database Sort Order / Collation

  I have an O2 Xda IIs Pocket PC running PPC 2003 SE, WWE (Worldwide English) edition. I want to create a database which contains all Chinese characters that have been mapped under the Unicode Standard. I already have a similar database on my desktop PC. On my desktop PC, I have used the collation Chinese_Hong_Kong_Stroke_90_CI_AS. However, on my Pocket PC, I do not see any Chinese or even Unicode sort orders. The best I get is "General". ...Show All

• Brent Neufeld Corruption of package?!

  I have done this twice - grrrr! Simple SSIS package contains the following tasks Control Flow 1. VB .NET Script to create a file name with "sometext" + mmddyy + ".xls" 2. FTP Task - logs into FTP site, finds file name created in 1) and downloads 3. Data Flow Task Data Flow 1. Excel Data Source - connects to and maps the Excel workbook/sheet columns 2. OleDB Destination - Inserts rows using the column mappings from 1) abov ...Show All

• Hannah SqlDeveloper/SqlExpress Conflict.

  Hi, Background: I'm on a Pentium 2.4 with 1024 mb Memory and 160 Gb harddrive, running XPPro with SP2. I started a project in VS2005Beta2 with Sql2005Beta. When the RTM versions came along I ungraded to VS2005Pro, and tried to upgrade the SqlDeveloper. This ran amuck, but I could still access my database, so after three attempts I gave up temporarily. When it looked as if I was actually going to finish my project, I decided to sort out ...Show All

• Tim.S IS_Member

  Hi, IS_Member function Indicates whether the current user is a member of the specified Microsoft Windows group or Microsoft SQL Server database role. If I want to test this for different user other than the current user, How I can do this Thanks It may or may not be a good choice. SETUSER is on the deprecated list, and is also not available to 'normal' users. --- quote BOL --- Important SETUSER is included in Micros ...Show All

• Susan22 ExecuteSQL Task with Parameters

  I have an insert statement that i am trying to parameterize based on a variable.  I have tried: INSERT MyTable(Col1, Col2, Col3) VALUES(1, @MyParam, 3) INSERT MyTable(Col1, Col2, Col3) VALUES(4, @MyParam, 6) as well as: INSERT MyTable(Col1, Col2, Col3) VALUES(1,  , 3) INSERT MyTable(Col1, Col2, Col3) VALUES(4,  , 6) The parameter is defined in the task.  It fails consistently.  The error in the output shows the SQL witho ...Show All

• lovely Access MaximumErrorCount From script Task

  Is it possible to get or set the value of MaximumErrorCount through a script task I tried to assign User variables to MaximumErrorCount but could not succeed. Any type of help will be appriciated. Thanks Gautam This seems like a silly question to ask, but I'm trying to do something similar, only how are you getting the count from the Foreach loop I'm using a Foreach loop with an ADO Enumerator. Honestly, I'd like ...Show All

• davenitup Foreach Loop Container in SSIS

  Could someone send me any links or information on how to loop through an ADO.NET dataset in SSIS I need step by step information please. Thank you, Shiva There are 2 ways, depending on your requirement. If you want to loop over the recordset and use the iterated value as some sort of parameter to something else then do the following: Load the data that you want to iterate over into a records ...Show All

• agarwaga SAN Replication

  I'm wondering if the technology exists to use SAN replication for sql server 2005 disaster recovery. I have a bunch of prod servers I want to add to a san, I then want to have another bunch of servers at a dr site connected to another san. Is there a technolgy ( non sql ) to enable full ( real time ) san replication of the data ( for SQL Server databases ). I don't need alternate suggestions, this solution has been proposed to my client ...Show All

• Computerma Potential workaround for SP1 failure

  SQL Server installation fails with the message: "A recently applied update, KB913090 failed to install" The last executed task was: Integration Service The last installation message was: Checking for lock files via Windows installer sqlrun_tolls.msp The error logs for this component can be found at %windir%\Hotfix\DTS9\Logs. DTS9_Hotfix_KB913090_sqlrun_dts.msp.log will most likely contain the error. Thank ...Show All

• Debi123 Stored Procedure taking too long

  I have a stored procedure that is taking too long to complete. I'ved narrowed the problem down to the following code. Is there any reason why this should take long to complete for about 40,000 records UPDATE Entries SET EntryStatus = 1 , reason = 'code entered more than once' WHERE TimeSubmitted > @StartOfPeriod AND TimeSubmitted < @EndOfPeriod AND TimeSubmitted <> @t and ShortCode = @ShortCode ...Show All

• El_Dibujante Is there a Fuzzy Lookup version of Leading/Trailing numerals?

  When using the Fuzzy Grouping component there are options to add significance to leading and trailing numerals. Is there a similar function/flag in the Fuzzy Lookup component or a way of achieving the same result without parsing the data into individual fields I've seen the MapFoldDigits, MapFoldCZone, etc flags in Fuzzy Lookup but I am not entirely sure what they do. I'm working with address data from multiple data sources and in some cas ...Show All

• Breetai7018 Can Enterprise Evalution Edition be installed on Windows XP SP2 Home Edition now?

  Thanks. No. I believe that only Developer Edition and Express Edition can be installed on XP Home SP2. Developer Edition allows you to test the behavior of Enterprise Edition.   Developer Edition is about $50 retail and is also available on MSDN (I'm not sure if all subscription levels include it).   Andrew Watt [MVP] < msibm@discussions.micro ...Show All