SQL Server

Page 6197




  • Topics
    Replies
    Last post
  • The script threw an exception! URGENT
    by CraigL77
    3 Replies
    Last post by CraigL77
      • I have a very simple SSIS package which I execute from VB.NET using the ManagedDTS namespace objects. I am getting a very sporadic error saying "The script threw an exception. Object reference not set to an instance of an object" All the package does is insert rows from a filename that I pass into the package from code, and then rename the file in a script task. The script task is
  • SQL 2008 and 2000 Incompatibility
    by LeFromage
    4 Replies
    Last post by LeFromage
      • Currently SQL Server 2008 (July CTP) can not run on a computer that already has 2000 (or MSDE) installed. Has there been an official statement on whether or not the two instances will be able to run together on the same machine for the official release
  • Eventhandlers don't work if a package is started from a checkpoint - BIG NASTY BUG (I think)
    by Jamie Thomson
    6 Replies
    Last post by Jamie Thomson
      • All, I'd like someone from MS to confirm something for me if possible. I've just come across a situation where a package that is restarted from a checkpoint fails to execute any of its eventhandlers if those eventhandlers are scoped to a parent container. Is this a bug or by design Either way I'm VERY worried about this because this is not in the least bit intuitive. This is the most dang
  • QUERY WITH COUNT
    by sowree
    3 Replies
    Last post by Louis Davidson
      • I need to create a drill down report with counts at each level, I cant use matrix, i need to implement this using SQL query..The format looks like below I need to get count of the field employee id for each region 1 through 8 and for each status value *, 0, 1 ,2 ,3 ,4 STATUS * 0 1
  • can Profiler display port number?
    by Kevin6
    1 Replies
    Last post by Jens K. Suessmeyer
      • Where - in SQL Server Profiler - can I see the port number that someone has used to connect to a database e.g. given the connect string "tcp:MACHINE1\INSTANCE7,3045" - where in Profiler does it tell me that the connection is using port 3045 I looked at "audit login" and "existing connection" but I don't see a port number... Any other SQL/Windows tools that I ca
  • Report Security
    by Luis Simões
    2 Replies
    Last post by Luis Simões
      • Hi, I have a certain report that contains information about a company structure... I want to allow only certain users to run the report (the easy part) but i also want the users to only see their own information (the hard part). How can i achieve this Do i have to enable row based security over SQL Server 2005 table Best Regards
  • Need Help with Query To Calculate a Ratio
    by tabdalla
    8 Replies
    Last post by tabdalla
      • Hello Everyone, I'm having difficulty putting together a query that would count the total number of rows in one table (Table B) and divide the total number of rows in Table B by the total number of rows in Table A + Table B. So, I put together the query below to try and achieve getting the ratio of rows in TableB to the overall number of rows in both tables (Table B Rows/Table A Rows+ TableB Ro
  • Footer not printing
    by Roy2331
    7 Replies
    Last post by adolf garlic
      • Hi everyone, For some odd reason the footer of my report never gets printed. The footer contains the page number and report name and is very important to my report. I made sure the margins are 1 inches for all sides, made sure Footers printing in first and last pages are checked in the properties section, and gave it a large amount of space around the textbox. Is there anything I am doing
  • Crosstab result
    by Vivek2
    5 Replies
    Last post by Vivek2
      • Hi there, I'm using sql2005. I've got a table in tabular form and I need to convert it to crosstab format. I've tried to use pivot operator but i can't get the result i want. Because pivot operator needs to aggregate a field but what i need is Dim values as column names and DimCode as values within those columns as it is, no aggregations. For example : This is tabular table.
  • Merge join: nr of output rows unchanged when amount of input changes
    by Albert R. de Ruiter
    3 Replies
    Last post by Albert
      • Dear all, I created a package that seems to work fine with a small amount of data. When I run the package however with more data (as in production) the merge join output is limites to 9963 rows, no matter if I change the number of input rows. Situation as follows. The package has 2 OLE DB Sources, in which SQL-statements have been defined in order to retrieve the data. The
  • Cross assembly or cross domain calls not supported
    by furmangg
    11 Replies
    Last post by furmangg
      • If I compile a simple .NET DLL with the following function and register it as an assembly in Analysis Services: public static int MyFunction(object o) { return 99; } When I run the following query I get an error which reads " Execution of the managed stored procedure failed with the following error: Cross assembly or cross domain calls not supported!. Execution of the managed stored pro
  • One-To-Many Table Relationships Causing Duplicates In Results
    by pbd22
    12 Replies
    Last post by pbd22
      • Hi. I am getting duplicate rows in my SPROC results. I think I know why - I am guessing that there are some one-to-many relationships involved in my joins. I am having problems getting rid of the duplicates. Am I right that GROUP BY on the primary key of the derived table will eliminate the duplicates I am guessing that grouping should happen on the emailAddress column of the Users table but I cou
  • Strange Convert behavior
    by SteffoS
    10 Replies
    Last post by Arnie Rowland
      • Hi! I am no SQL expert so this might be a easy one. I am trying to convert a nvarchar value to a numeric(28,12) value and i get some behavior that i do not really understand. The following query results in a Error converting data type nvarchar to numeric: SELECT ItemID, ConfigID, CONVERT(NUMERIC(28,12), VALUEID) FROM viewConfigs WHERE ISNUMERIC(VALUEDID) = 1 AND INVENTITEMFIELDID = 5 However, the
  • SQL 2005 to SQLCe
    by Sreenaiah
    2 Replies
    Last post by just david
      • Hi, Could some one guide me hot copy tables/Data from SQL 2005 to Sql 2005 Compact Edition Thanks
  • Parameter passing in SQL Server 2005 Integration Services (SSIS) 2005
    by Rupesh Kumar
    4 Replies
    Last post by Rupesh Kumar
      • Hi All, Parameter passing in SSIS 2005 sometimes appears to be a cumbursome task. I have been digging into this topic for quite some time and here i note down some simple steps to demonstrate parameter passing at Package level. (1) Create a SSIS project using Business Intelligence 2005 Or VS 2005. (2) Create datasource (.ds) and Data Source View as required. (3) A default SSIS Package
  • Offline cube cannot open
    by grmohan68
    14 Replies
    Last post by grmohan68
      • I built a cube by Microsoft SQL Server 2005 Analysis Services and deploy into the server. The deployment was successful. I extract the cube by Microsoft Excel 2007 to view data. That also successful. Then I built an offline cube from there. I can successfully create the offline cube. And store into a thumb drive and open the offline cube by another pc through microsoft excel 2007/2003 both. I cann
  • IDENT_CURRENT questions
    by smturner
    11 Replies
    Last post by smturner
      • I'm using visual basic and SQL Here's my string: SELECT intD1 = IDENT_CURRENT(ServerLogID)FROM ServerLog I'm trying to select the primary key of the last record from a table and place it in the variable 'intD1' I think I'm missing something, but I'm not quite sure what!
  • Setting Null values will '0'
    by AlucardHellSing
    4 Replies
    Last post by Jiju
      • How do I set those null values in mdx query to a default '0' count as I want to display those empty cells in my report,thanks. Regards Alu
  • [DBNETLIB][ConnectionWrite (send()).] General network error. Occurs when SQL times out on new Windows 2003 sp2 server
    by garrytman
    14 Replies
    Last post by mitre
      • We just replaced an older Windows 2000 sp4 server with a new Window 2003 Standard Edition sp2 server to run our batch processing. We noticed that when the SQL command times out we now get the following error in the ADO command object error collection. [DBNETLIB][ConnectionWrite (send()).] General network error. Check you network documentation. Native Error: 11 SQL State: HY018
  • Autofit table within a table
    by ajhuddy
    8 Replies
    Last post by ajhuddy
      • Hello, Does anyone know of a technique to 'autofit' the rows of a table within a table Once you start to add extra rows to the 'child' table, the rows start to shrink, making it fairly annoying, and manually resizing takes a while.
  • Simulation of report parameters in T-SQL
    by Martin Christian
    4 Replies
    Last post by Martin C.
      • Hi! I hope this is not a stupid question ... I'd like to "simulate" multivalue report parameters in t-sql. Background is, that I'm developing statements for report datasets with management studio for convinience. The statements need to apply a filter based on a report parameter like this: select a, b, c from datasource where a in (@listofitems) Which works grea
  • Custom Annotations on SRS 2000 charts
    by Mary S
    2 Replies
    Last post by pipodyer
      • I would like to be able to put custom annotations on charts. Specifically I have a line chart I want to annotate. I don't want to indicate all plot points, just areas of interest. For example, on one of our line charts there is a value for a week (weeks are the x-Axis) that is way out of whack with other weeks. I would like to be able to display only that value, circle that location on the chart a
  • MDX Named Member - is there such a thing?
    by Carl Daniel
    5 Replies
    Last post by furmangg
      • In MDX, I can write with set [X] as { ... MDX set expression ...} to define a named, constant set that's used by a subsequent select statement. I'd like to be able to define named members - not a calculated member, but a symbolic name for a member chosen through some logic. The same result I'd get if I defined a set as above and used [X].item(0).item(0) in the query.
  • Report server not inizialized after installation
    by ajhuddy
    4 Replies
    Last post by ?®€?§Q?
      • Platform : SQL Server Express SP2 with advanced services I have an install script that installs all of the services and features with the exception of management studio express. My install script is very basic, the only addition was to have RSSQLOCAL=1, and I set RSCONFIGURATION=Default. After the installation, when I navigate to localhost\Reports$SQLEXPRESS or localhost\ReportServer$SQLEXPRESS, I
  • How to filter results for 'All Periods'?
    by Helen999888
    7 Replies
    Last post by Helen999888
      • Hi, all, How could we filter the results to exclude 'All Periods' E.g. I would like to see sales amount for year of 2001,2002. etc, and I dont want to see the results retured for 'All Periods', thus how could we achieve this Thanks. With best regards, Yours sincerely,