Answer Questions
firegod slq reporting 2005
is there any sampel web site where i can learn how to create a reports in sql server 2005 i'm interested in: 1) how to pass parameters to report thanks. i have .aspx page and in that page i have reportviewer control and i able to connect to report server i need a good way to pass the parameters, what i mean by that, i have 3 parameters (age, zip, phone) that will pass this info to report.rdl and based on my param my report will execute. so my question is how do i pass this paramters from .codebehind (c#) thanks Hi, Here is some info to get starterd: http://msdn2.microsoft.com/en-us/library/ms155917.aspx Greetz, Geert Geert Verhoeve ...Show All
Greg D Clark ex.Message in debug mode is much shorter
Exception ex.Message I am getting in debug mode calling AcquireConnection is much shorter than the logged message in run time because all the errors come to output window in debug. Is there any way to get all these errors description from exception object in debug time to be able to parse it Thanks. What you are saying does not make sense. The exception details will always bee the same debug or otherwise. The exception will only have one message, but you suggest there should be more. You could check the InnerException property of the caught exception, that may give something. I really do not understand how you are describing the two modes, with all errors or otherwise. Is this perhaps to do with a UI If so try the IErrorCol ...Show All
him19010 placing norms on a bar chart
Maybe someone can help. I'd like to do one of two things, depending on which is actually possible: Place one chart on top of another so that, in addition to having a simple bar chart, I can also have a way of tracking comparison data on the same chart. (My preference is a line chart with diamond markers on top of a bar chart.) Within one chart, have one of the series be a different chart type. Once series could be a bar and the next could be a line with diamond markers. The catch is the diamonds would have to be placed right on top of their corresponding bars. These are both things that I've been able to do in Excel, but am finding out that I've taken for granted just how versatile Excel is. Thanks in advance! Krdjis ...Show All
2162 SET IDENTITY_INSERT tablename ON
I know there has already been a thread on this, but I want to push some about it. In SQL Server, there is a command " SET IDENTITY_INSERT tablename ON". That allows you to update IDENTITY columns, or do INSERTs that include IDENTITY columns. Although a work-around was given for this in the other thread (reset the IDENTITY seed to the desired value before each INSERT), that is a major pain. In my database, I have a table that tracks charitable donors. They have a donornum, that is an IDENTITY column, and a year. Together, the donornum and the year form the primary key. Each year end, a copy is made of all donor records in one year, to form the next year's donors. They have to keep the same donornum, but they get a new ...Show All
sagittarian DTS 2000 Package Error(s)
From MS SQL Server Management Studio 2005, I register and connect to MS SQL 2000 (SP4) running on another server. I can see the list of 2000 DTS packages on the other server, but when I try to open them I first get: Error Source : Microsoft Data Transfformation Services (DTS) Package Error Description : The DTS host failed to load or save the package properly. I click the OK button and get: The selected package cannot be opened. The DTS Desiger has been closed. I click this OK button and get to now famous: SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer. ...Show All
drcairo Can I somehow subscribe to SQL upgrade notifications??
Well, it's happened again. An upgrade to SQL server was released without my having any idea about it. SP2 came out today and the only way I knew it was I happened to see a headline on Yahoo. Similar things have happened in the past with HotFixes or security rollups. Sometimes it's rather embarrassing, especially when your boss challenges you on the most recent security updates for SQL. Is there any way which we can be notified of new upgrades/updates to SQL Server I need to know when there is a new hotfix, update, service pack, or whatever so that I can install it as needed. So far, the only way I've found these was by accident. I'm signed up with the Microsoft Download Notification email list, so I was able to see that SP2 CTPs were relea ...Show All
Karlo Occurs in a field
Hi, How do find out how many times a character occurs in a field thru an expression Like the occurs() function in FoxPro Thanks Any suggestions ...Show All
gavin_1724 Want to log CLR exceptions in SQL table
So I have some SQLCLR stored procedures, that use some .NET classes. I have a table in the database for exceptions, and I want to log all exceptions (except SqlExceptions of course) to that table. I have the following example: public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server. SqlFunction (FillRowMethodName = "FillRow2" , DataAccess = DataAccessKind .None, SystemDataAccess = SystemDataAccessKind .Read, TableDefinition = "fld_colname NVARCHAR(4000)" )] public static IEnumerable ExceptionTest() { // Some example from a website List < string > names = new List < string >(); using ( SqlConnection connection = new SqlConne ...Show All
Can-Ann Multiple sources - single destination
There are two EXCEL sources one destination table. Each record in the destination should be populated with 2 columns from one source and 2 from other source. Source 1: ID Name 1 abc Source 2: Address Location 232/2 xyz Destination: ID Name Address Location 1 abc 232/2 xyz I tried using UNION ALL transformation but it fetches 2 seperate records (assuming that one record in each source). How to achieve this without using SCR ...Show All
Ametis MDX query based on a subquery
Hi, I hope that some can help me with a small problem I have got. I am new to data warehousing and MDX and am wondering if it is possible to construct a query based on a subquery (something like a T-SQL IN Clause). Want I want to do is take all the customers who has looked at one product category (ex Dairy products) and see what else they have looked at. I guess what I want to do is create some sort of a filter to be able to only take those users from the measure and slice them by the product dimension again. I am using ProClarity and will also need to be able to use it in there. I am thankful for any help or any pushes in the right direction :-). Kind Regards Stefan Ghose Thank you soo ...Show All
saint168 How to Schedule and Run a SSIS package
Hi Does any one know how to run How to Schedule and Run a SSIS Package for certain time intervals I have created an application which will do some data transfering from one database to another databse based on the start time and end time values(Which is been already configured in some tables). What I am exactly looking is that my application should do data transffering Based on only the time intervals(Startime and End Time) I wanted to execute my package only these time intervals. How to do this Can any one help please. Thanks & Regards Deepu M.I It sounds like you have a custom application that runs the packages at certain intervals. If that's the case, t ...Show All
James Cubbage Error viewing report created in Report Builder
Using the report builder, I created a simple report based on a report model. This report runs ok in the report builder. I proceeded to save the report to the report server, but when I want to view this report in Report Manager, I get the following error: An error has occurred during report processing. Query execution failed for data set 'dataSet'. Incorrect syntax near '<'. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The la ...Show All
tovarish SSIS package
Guys I've migrated a SQL Server 2000 DTS package over to SSIS (which seems to have worked), its a really simple package with just one item, it first checks for a tables existance and deletes if necessary, then recreates the table and then inserts data from a selection of other tables, except its only creating the table no data is being inserted, yet the script to insert data works as I've tried it in a query. Any ideas Thanks inadvance Hi Jamie After some investigating I discovered that it was the drop object first option, technically the table didn't exist, I had thought it would have been a check statement like if it exists..... obvisouly not, anyway I've managed to sort that, so thanks gu ...Show All
jasse_91 Stacked bar chart with two bars grouped
I have a simple production table with contents like this: Date Shift GoodParts BadParts Target Id 2006-10-27 06:00 Day 640 0 800 6 2006-10-27 14:00 Evening 460 0 600 7 2006-10-27 20:00 Night 234 7 1000 8 2006-10-28 06:00 Day 503 5 1200 9 2006-10-28 18:00 Night 630 9 1200 11 2006-10-29 06:00 Day 382 2 1200 12 2006-10-29 18:00 Night 333 6 1200 13 2006-10-30 06:00 Day 123 0 800 14 2006-10-30 14:00 Evening 356 3 800 15 2006-10-30 22:00 Night 463 13 800 16 2006-10-31 06:00 Day ...Show All
Ram&#38;&#35;243&#59;n T&#38;&#35;233&#59;bar Urgent: MSSQL2005(64-bits) MDAC
Hi, MSSQL2005 is installed in a 64-bits OS. And I tried to installed MDAC2.8sp1 in it. It seems that the copy in MS is 32 bits. Any MDAC will be applicable to 64-bits Also I found in MSDN that MSSQL2005 requires MDAC2.8sp1 or higher. Any method for MSSQL2005 64-bits to connect to other datasource via Linked server Thanks in advance! I need to export the data from a Paradox 5.X db file to a table in Sqlserve 2005. I was able to do that using SSIS In XP but when trying to do the same in windows 2003 32 bit system it gives errors which point towards Microsoft jet 4.0 drivers . It just does not accept the connection manager at all. My biggest concern at this point was that even ...Show All