Answer Questions

• Sebaste problem with Displaying Data

  Hi,       I have data in the following format in my database, COL1       COL2 ------------------ MSDN      20 MSDN      30 MSDN      40 FORUM    50 FORUM    60 FORUM    70 NET        80 NET       &nb ...Show All

• Richard Timbers Adding an Image

  Hello: I have an Image control on my report . I have a Class for example : public Class Class1 private _MyPic as System.Drawing.Image public property MyPic as System.Drawing.Image ...... end end the Dataset Of My Report is Class1. i Drop an Image from toolbar in My Report and set Source to Database and set value to =Fields!MyPic.value befor showing the Report i Create an object from Class1 and ...Show All

• AlExtjAi Reading and writing same variable to a script

  It looks like its not possible to both read and write the same variable from a script using the conventional Me.Variables.<variable> syntax. I can only assign a variable as Readonly or ReadWrite and not both. If I assign it ReadOnly I can only access it in the PreExecute subroutine. If I assign it ReadWrite I can only access it in the PostExecute subroutine (in fact doesn't this just make it WriteOnly in fact ). So I can only either rea ...Show All

• Belzicool Sql stored procedure call hangs from .net

  Hello, I'm really stuck on this one, so if anyone can help it's much appreciated. I've written a stored procedure that takes about 3-4 minutes to run in testing. However, when I call the procedure from a C# application the procedure call just hangs..eventually timing out causing an exception. I set the timeout to 60 mins just to check but it just hangs all the way. Does anyone have any ideas why this would be happening As I say, the stored proce ...Show All

• PaliKE Window identity of SQL Server

  My .NET application use SQL authenication. One function of the app is to backup database to a user specified folder using SQL statement. However, there is problem saying that there is no right to write to the folder. What window identification(any default account ) does my app use in the write action If my application will be distributed and installed by user, what should I do to make the backup success for all location Many many thanks! ...Show All

• ShadowRaven SSIS: JOINING TABLES FROM TWO SERVERS - BETTER WAY THAN SORT -> MERGE JOIN?

  Setup: I need to run an Insert query which pulls data from a table located on server A database AA Table AAA conditional on (or JOINED with) Table BBB in database BB sever B. In SQL 2000 it could be done as: From Server A: sp_addlinkedserver B INSERT dbo.ResultsTable SELECT SourceTable.* FROM B.BB.dbo.BBB SourceTable INNER JOIN A.AA.dbo.AAA ConditionTable ON SourceTable.RecID = ConditionTable.RecID sp_dropserver B In SSIS one of the pos ...Show All

• Paul Chapman - MSFT Displaying huge heirarchial data in reports

  I need to display huge data around 1 million records in report. Data needs to be represented as heirarchial. So there is somewhere around 6 level of grouping of data. Can somebody suggest a solution to get the data and display the data in a faster way. Thanks in advance. SSRS What about using sub report Hi, I don't knw if I understand your problem but you could use ...Show All

• Rocksie ISNUMERIC function

  select isnumeric('-') returns 1 indicating valid numeric value, but select cast('-' as numeric) returns Arithmetic overflow error Could someone explain this behaviour of SQL server Anand ISNUMERIC will return 1 for input values that can be converted to any of the numeric data types in SQL Server including the integer, float, decimal and money data types. So if you want to only check for specific conversions you need to roll your own check ...Show All

• TFink Matrix Help with Columns

  sql server 2005 Hi all, I have a finacial report that I need to show all periods 1-12 (columns) regardless if there is data or not. what i am getting is account-----1-----5-----6 a#1235-----#----" "----# a#2346----" "----#-----# what i want is account--1--2--3--4--5--6--7--8--9--10--11--12 even if the accounts 1235 and 2346 only have data for a couple of periods i want all periods to show on the report ...Show All

• virgy SQL Update statement

  Hi all, Sorry for this super newbie question, but I am purely a mysql developer. I am trying to update a table using Query Analyzer and am having problems with the sql syntax. This is what I'm trying to do: update table set column1 = 'test data', column2 = 'test data2' where column1 is NULL and column2 is NULL I receive 512 errors, stating that the subquery cannot return more than 1 record. I understand that most of the table has ...Show All

• sonj Import variable fixed length file

  I have a requirement to import a file of rows containing fixed length data. The problem is that each row can be one of 5 different formats (i.e. different columns) -- where the "type" of row is indicated by the first two characters of the row. Each row gets inserted into its own table. Could I use a simple Conditional Split to route the rows Or is the split for routing similiar rows Anyways, problems are never this simple... In a ...Show All

• George W Bush Database 'msdb' cannot be opened

  Anyone help I opened SQL Server management studio and tried to connect with the local database and received the error message: Database 'msdb' cannot be opened. It has been marked suspect..... I have pasted the only error from the event log I could find below, but it doesn't mean much to me. In the event I can't find what the problem is, and not being a database administrator, can anyone tell me what I can do to get back in working o ...Show All

• flaviu Exporting a Cube into MS Excel

  Hello, I am wondering if it is possible to import hierarchies established in a SSAS 2005 cube into MS Excel. Right now, when I import a cube into MS Excel (Office 2003) through the following path in Excel: Data/Import External Data/New Database Query/Olap Cubes/"MyCube".cube, I am able to see cube's dimensions and measures but I cannot see my hiearchies. I would like my users to be able to drill down to the lowest level in a giv ...Show All

• fdgrau Using WebService Task

  Hello, I'm trying to use this web service : http://office.microsoft.com/Research/Providers/MoneyCentral.asmx WSDL i get an error : "This version of the Web Services Description Language (WSDL) is not supported" What's wrong Did you receive any answer outside the forum to this question What address are you providing in your HTTP connection manager Are you providing the URL exactly as you typed it in your question, above -Doug ...Show All

• jiggs Consistent Deadlock, need to identify the rogue PAGE lock

  I'm having trouble tracking down a deadlock in a large multi-threaded application. I have been able to gather some information, but not quite enough to identify the two queries at fault. I collected the following by turning on the -T1204 and -T3605 parameters: Deadlock encountered .... Printing deadlock information 2006-04-13 09:13:48.70 spid3 2006-04-13 09:13:48.70 spid3 Wait-for graph 2006-04-13 09:13:48.70 spid3 2006-04-13 09:13:48.70 ...Show All