SQL Server

Page 3257




  • Topics
    Replies
    Last post
  • Creating a new measure that only sums data in specific part of cube
    by Jeff Roedel
    10 Replies
    Last post by Bryan C. Smith
      • I have a cube with about 6 dimensions but only two are important right now. My main fact table is called MRSTATS. The dimension tables are Dim_Client#, and Dim_Test. I would like a measure called HospVol that only aggregates rows where MRSTATS.[Client#]=2. Then I need a measure called HospRVU that multiplies HospVol Measure by Dim_test.RVU. How do I got about configuring this Let me know if
  • More information about replication
    by Finkster
    3 Replies
    Last post by Mahesh Dudgikar - MSFT
      • I am looking for a whitepaper or webcast which outlines the changes made to SQL Server 2008, in terms of mobile data consumers. I am interesting in learning more about SQL Server CE 2008 (or whatever the name is) and how SQL Server 2008 manages data replication.
  • smo column
    by Newguru
    1 Replies
    Last post by Allen White
      • how can i get default values from smo column object
  • Average in Matrix
    by plengski
    5 Replies
    Last post by plengski
      • Just want to gathr some ideas.I have a matrix where i retrieve Fields!Amount.I used the subtotal property to get the total amount per quarter.But how can i get the average of the 3 months.I tried using the Avg(Fields!Amount.Value) but it's results is unexpected or wrong. ________________________ | Avg(Fields!Amount.value) | | Jan | Feb | March | -
  • MDX problem with parameter
    by R D
    3 Replies
    Last post by R D
      • Dear all, I've created a report in VS2005 Report Project with following MDX, I've one parameter to pass in the MDX for filtering. There is no problem when i click "Prepare Query", but when i preview the report, it show errors listed below. But when I replace the parameter to a string (e.g. "abc"), there is no error when I preview the report. How can I solve it. Thanks ve
  • Embedded text qualifiers
    by peter feakins
    3 Replies
    Last post by Lzitro
      • We have text files that are comma delimited, use double quotes as text qualifiers and sometimes have embedded double quotes. The embedded double quotes are escaped with an additional double quote like: below. "123","product q" "124","product ""a""" DTS 2000 had no problem with this- it correctly parsed the files. The 2005 SSI
  • Value and Date filter in Excel 2007
    by kirank_gh
    4 Replies
    Last post by vidya_084
      • Hi, I am developing reports in Excel 2007 connecting to Analysis services cube. I have the following scenario Report has one Date attribute and a metric. When i apply Date filter option and value filter in Excel 2007 only one is applied to the data. Ex: If i apply date filter on Date attribute date between 1/1/2007 and 1/2/2007, data is filtered out properly but when i apply v
  • Combine raw files using range
    by ccote
    7 Replies
    Last post by ccote
      • HI, I have a dataflow that has two raw files as source and I would like to merge them upon a range condition: RawFile1.Date <= RawFile2.Date Usually, using tables, I would have used a lookup with partial cache to achieve it. Now, since we cannot use lookup transform with raw files, I was wondering how I could achieve this using raw files as source. Is it possible to merge raw files using
  • Strange SMO behavior
    by llkoolj
    3 Replies
    Last post by Andrea Montanari
      • I am have the following code below on a standalone computer and it worked perfectly. Suddenly, without any significant changes to the code there were no Servers instances found on my local computer. I know there are several server instance on the computer. Why is it acting so unpredictable The same thing happened when I tried SQLDMO. // Get a list of SQL servers available on the networks
  • Can't install 2005 SQL Server Management Studio, it doesnt show up. What a joke!
    by AliRaz
    5 Replies
    Last post by Andy.E
      • Hello I have wasted several hours on this simple problem and I'm ready to give up. I simply want SQL Server Management Studio on my laptop so I can connect to our 2005 servers and manage them. I have several different versions of 2005 from our MSDN subscription including but not limited to: SQL 2005 Enterprise Edition (MSDN Library DVD) SQL 2005 Workgroup Edition SQL 2005 Standard Edition
  • Unable to connect to SQL server database
    by Silver Haired Newby
    4 Replies
    Last post by Xinwei Hong - MSFT
      • I recently installed VS2005 Prof edition and SQLExpress 2005 and have been teaching myself C# using the book Microsoft Visual C# 2005 step by step. I have done all the examples including the examples on databases without problems up to chap 27 which is trying to demonstrate adding security to a web site using the ASP.NET Web Site Administration tool. After opening the tool and clicking on
  • Date Formatting
    by DotNet_Guy
    2 Replies
    Last post by DotNet_Guy
      • How can I format the current date as yyyy-mm-dd and display it in a text box on the report. The FormatDateTime function only allows certain NamedFormat for the short and long dates but does not satisfy the above requirements. Any ideas
  • Displaying data into a report just by mapping Dataset and not indivisual fields
    by Digant Desai
    0 Replies
    Last post by Digant Desai
      • Hi. I have a master Report from which I am callling a subreport which basically have to show 200 columns(it will be a single row) every time. Is there any way,I can show this data in a column,with the help of reporting service If not,Can I show all this data without mapping it to the table Your thoughts to make this up will be appriciated -Thanks, Digs
  • INNER JOIN Help
    by moflaherty
    2 Replies
    Last post by Manivannan.D.Sekaran
      • OK, I admit it. I am a little old fashioned when it comes to transact sql programming. However, I figured it is time to learn the newer INNER JOIN syntax. Maybe it is just me, but the new INNER JOIN syntax seems so convoluted when dealing with complex queries. INNER JOIN statements make sense to me when dealing with simple two table joins. However, I am stumped on this query (which should b
  • can i transfer data from two tables to a single table at a time (row wise)
    by B L Rao
    13 Replies
    Last post by jwelch
      • i need to transfer the data from allbase (old database) to sql server 2005 . moreover the structure is different say in allbase we may have 10 tables but now we want more tables .and some tables may have more fields than the previous table's fields for ex: productdigit (previous table name) have 2 fields and present table productline have 4 fields (while using export/import wizard those are set
  • How do I use a parameter in field using MDX.
    by Roger K
    8 Replies
    Last post by Roger K
      • Let me simplify. The value of my dataset field Dimension_1 is [SOB Year].[Yr Id].[Yr Id].[MEMBER_CAPTION] I want to use parameters for SOB Year and Yr Id like I do on the query. But if I use =" ["& Parameters!dimension_1_table.Value &"].["& Parameters!dimension_1_column.Value &"].[" & ["& Parameters!dimension_1_
  • looking to write my own simple SQL Client via TCP/IP
    by Scooter&amp;#33;
    3 Replies
    Last post by Il-Sung Lee - MSFT
      • I'm looking to write my own simple SQL Client via TCP/IP. We have some hardware that does not run an OS of sorts, but I can create TCP Connectons. We's like to be able to Query our SQL Server with this hardware. The SQL Servers we are talking to are MS SQL2000 and MS SQL 2005 both via TCP port 1433. We can telnet to the port of the SQL Server. Any resources to the SQL Protocol you could pass al
  • ReportViewer-winform
    by mpetanovitch
    3 Replies
    Last post by AmitdotSingh
      • Is there a way to make the data selecatable. For example, a user runs a report and wants to copy the applicationId onto their clipboard so they can use it to search in another application. Currently they have to remember or write down a 9 digit number. Not very user friendly... I am currently using a data table as the container for the data in my rdl file. Then I use reportviewer for winforms
  • When Export to to PDF it gives Japanese Char as ???
    by Bhudev
    7 Replies
    Last post by Lisa Nicholls
      • Hi, I have an issue in SSRS 2005. We have reports having data in multiple lenguages. Suppose I've a report where some columns are in Japanese and some are in English. And Rports are build on English OS. When I export it to PDF then Japanese Characters comes as What to do Urgentely Need help. Thanks in advance Bhudev
  • Dynamic Form Letters
    by k2sarah
    1 Replies
    Last post by ECSScott
      • I would like to design a 'mail merge' type of letter, whereby some of the paragraphs will be conditional on parameters. Can anyone direct me to example of mail merger letters using reporting services thanks ken
  • Dynamic subreports
    by the_joric
    5 Replies
    Last post by the_joric
      • Hi all! I need to create a report with a number of subreports. The problem is that those subreports might be different for each datarow. Is it possible to set the report name for the subreport in some dynamic manner, e.g. extract it from the data
  • Checking to see if a record exists and if so update else insert
    by Phil Brammer
    14 Replies
    Last post by bkallich
      • I've decided to post this as a sticky given the frequency this question is asked. For those of you wishing to build a package that determines if a source row exists in the destination and if so update it else insert it, this link is for you. http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx Thanks Jamie! If you
  • Problem in Configuring ASPState DB for .NET 2.0
    by Sivaraman
    3 Replies
    Last post by Sivaraman
      • Hi, In the current production environment we have web applications running in asp.net 1.1 (win 2003 server) which uses ASPState DB for the session management. We are in the process of migrating few of the web application in asp.net 2.0. We would like to use the same ASPState DB for both 1.1 and 2.0 applications for maintaining the session. Problem that we are facing: After going through cou
  • problem with retreving a excel data through excel source component.
    by Dhivya.S
    4 Replies
    Last post by Mehdik
      • Hello, I have a problem with retreving a excel data through excel source component. I have source component as Excel Source which will connect to my .xls sheet. To retrieve the values from the sheet i am using a query as, "SELECT F14,F3 FROM [Charac Defn & Assgnment$]" The column F14 is not formatted so that the format of the cell is "General" I hav
  • Table Column Comparison Transform
    by J.A.J.
    11 Replies
    Last post by Jamie Thomson
      • Is there a transform available which allows you to specify two different tables (same primary key) and compare columns (you identify which column(s) values need to be compared in the transform) between those two tables thanks