SQL Server

Page 3558




  • Topics
    Replies
    Last post
  • Query problems - Group By and Latest date
    by GS80
    5 Replies
    Last post by Grant Swan
      • Hi all, hopefully someone can suggest the best way of implementing the problem i am trying to resolve. We have a table which contains rows relating to tests run on our product. This table is populated from an SSIS job which parses CSV files. There are multiple rows per serial number relating to multiple tests. The only tests i am interested in are the ones with an ID of T120. Here is the query i h
  • Reporting Service Cache
    by chan_sivaram
    14 Replies
    Last post by Teo Lachev
      • Hello Techies i have SSRS 2005 report the source data from oracle views i simply select * from the view and display data for a particular entity say empID using filter in the reports which is passed as parameter the question is whether SSRS will cahe the data and for subsquent request it will take from Cache instead of going back to database even if i change the parameter say empID 1
  • Newbie Parameter Problem
    by Dan Rooney
    4 Replies
    Last post by VDeepak
      • Hi, I have 3 parameters on my form. StartDate (datetime), EndDate (datetime) and CompanyName(string). The default values are: StartDate (Non-queried) 1-1-2005, EndDate (Non-queried) 1-1-2008, CompanyName (From query) DataSetBelow, Value field (AccountFamily): SELECT DISTINCT AccountFamily FROM CallDataRecords The table on the form contains the following DataSet: SELECT Salutation, Inbou
  • Backup Database
    by rehan15
    3 Replies
    Last post by Madhu K Nair
      • HI i have created job which executes following Store Procedure, my Qs is after 1-day has passed shldnt it overwrite , i mean i have 1-GB Database my job runs for 3-times a day so end of day i have 3-GB so wen time goes past 12.00 am shldnt it becomes 1-GB again Alter Procedure sp_DBBackup as BACKUP DATABASE [XYZ] TO DISK = N'D:\Office Purpose\Database\Backups\XYZ\Backup-Method (Append-
  • RESTORE DATABASE
    by AlexBB
    14 Replies
    Last post by AlexBB
      • I need to restore a database. I have never done it before. I get an error on this command: Syntax Error. What is wrong with it RESTORE DATABASE [intraDay] FROM DISK = 'J:\SqlServerBackUps\IntraDay\intraDayFullRM.BAK' WITH RECOVERY , TO 'C:\intraDay.mdf' ; -- this is just to try the RESTORE in principle. I will restore the DB to a different folder. GO
  • problem with recursive cte query
    by gswartz
    3 Replies
    Last post by viral@excellenceinfonet.com
      • I am running into 2 problems with this cte query. First off, it's not returning the results in the right order. What I mean is that, as you can see from the graph, the first row (tabid=4) should be followed by rows 3,4 and 5 but it's throwing in a row between. No matter how I try and order the results, it's not working as it should. The tabindex field is a user defined field as to what order the t
  • Request for feedback - Aliases have been deprecated for some time and will be removed soon
    by Raul Garcia - MS
    14 Replies
    Last post by Joe Webb
      • As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release. We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.
  • Help with cupe partitioning/processing
    by JOER_DK
    1 Replies
    Last post by Dave Fackler
      • Hello guys I have an issue with one of our cubes which i hoped someone could help me with... The problem is a historical cube which is currently growing quite drastically, and includes daily history from 2004 until today. The cube is just processed full every single day, and this means processing 80+ million rows every day, when actually most of the data is not changed at all. I decided I want
  • Problem running SSIS from C#
    by agentf1
    5 Replies
    Last post by jwelch
      • have one script that works fine. I am doing the exact same thging with this new script and it runs fine from C# on my desktop and runs fine from SS on the server but comes back with a failure when trying to run from C# on the server. Is there any additional info I can retrieve about the problem All I am getting right now is "Failure" from the result field. if (result == DTSExe
  • MDX Sum distinct across specific dimensions
    by Clayton DuVall
    4 Replies
    Last post by Clayton DuVall
      • I have a measure group that has a few measures that are not addittive across all dimensions. I need to be able to get the sum distinct across specific dimensions and am having problems getting it to work. I tried specifying that the aggregate function should be semiaddittive, but it complains that it is missing a time dimension. I have tried many variations and combinations of MDX functions inclu
  • OleDB Source and Parameters
    by skrewed
    4 Replies
    Last post by jwelch
      • Hi, Firtsly - I am new to SSIS if my approach could be improved then I welcome suggestions. Scenario : I have a large SSIS package that consolidates / summarizes work week information from several data sources. Currently each data flow task in the control flow calculates the from and to date that is filtered on, for example: DECLARE @FromDT AS DATETIME SET @FromDT = CAST(FLOOR
  • searching similar records within a table
    by vidkshi
    6 Replies
    Last post by DaleJ
      • Hi, I have 4 tables : Code Block Create Table #Request ( [requestid] int , [stateno] nvarchar ( 5 ) , [cityno] int , Callid int , UniqueNo int ); Create Table #RequestDetail ( reqdetailid int , [customername] Varchar ( 20 ), [customerage] int , requestid int ); Create Table #Call ( Callid int , Calltype int , callDetailid int )
  • How to Create Assembly function using dll files in SQL Server 2005???
    by Pratik Kansara
    11 Replies
    Last post by nielsb
      • Hiiiiiiii all I have to make a user defined function in c# as the class liberary and create a dll file, now i want to use this function in SQL Server 2005 as a part of CLR Integration I have tried like this CREATE ASSEMBLY abc FROM 'C:\abc.dll' WITH PERMISSION_SET = SAFE but it gives me incorrect syntax error so plzzzzz anyone help me wht to do in
  • Database user and Corresponding login
    by L Arvind
    4 Replies
    Last post by Laurentiu Cristofor
      • Hi everyone, I have a simple question regarding the database users on sqlserver 2005. When i run a 'sp_helpuser' stored procedure in a database to know the usernames and their corresponding loginsName, i find there are some usernames with corresponding loginName as null.I know for sure that for 'Guest' username the corresponding loginName will be Null, but i find many normal database us
  • Error while changing Custom Resolver between 2005 Publisher and 2000 Subscriber
    by Arni06
    2 Replies
    Last post by Arni06
      • Hi all, here is the context of our problem: - Publisher : version SQL Server 2005 SP2 table in SQL Server 2000 (80) compatibility level publication in SQL Server 2000 compatibility level - Distributor : SQL Server 2005 SP2 - Subscriber : SQL Server 2000 SP4 + hotfixes (version 8.00.2187) There is only one article in our publication (a simple table with a GUID
  • Question on Row Count Transformation
    by minority80
    13 Replies
    Last post by minority80
      • Hi all, i'm using Row Count Transformation downloaded from http://www.sqlis.com/93.aspx to generate surrogate key. in my data flow, i have OLE Data Source connected to Row Count Transformation connected to SCD. i've configured ok and the package ran without error. my problem is my surrogate key column won't generate the next increment number if i run the package the 2nd time and there
  • SQL Server SP2 Command Line Upgrade Switch and Express Version Detection
    by PismoPat
    1 Replies
    Last post by Samuel Lester - MSFT
      • Our application installation setup needs to be able to detect: Is SQL Server 2005 Express Installed If false, run the SP2 Installation Is SQL Server 2005 Express or SQL Express SP1 Installed If false, run the SP2 Installation with Update Switch Is SQL Server 2005 (not Express) Installed If true, abort installation with a mesage. Can you direct me to some documenta
  • Datetime format for dimension Please help me
    by polachan
    4 Replies
    Last post by polachan
      • Dear All, How can I format a dimesion datetime column . for example while browsing a cube, the value of the dimension column 'DateOrder' shows like that 2002-11-01 00:00:00. I wan to get 01/11/2002 dd/mm/yyyy. What I have to do. When I changed their cell value property as dd/mm/yyyy it doesnpt working ..Please to crrect my problem with regards Polachah
  • Accessing variables using file connection in Execute SQL Task
    by Yongpil
    3 Replies
    Last post by Yongpil
      • Hi there, I need some help on how to access variables using a file connection... if that's not possible even direct input. I made a variable for the server name, and now I only need to know how to call the variable in the script. any help is appreciated. thanks
  • Custom Assembly Security
    by MSDN Student
    9 Replies
    Last post by MSDN Student
      • Hello Everyone, When I run my report from report manager, I get the following error message Failed to load expression host assembly. Details: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. My report uses a custom assembly. I have already done the following
  • inflation factor in Analysis Services 2005
    by IsaacBS
    1 Replies
    Last post by Bryan C. Smith
      • Anybody knows how to apply an inflation factor depending on the date to a measure in Analysis Services 2005 The Inflation Factor is (Current Month Rate / X Month Rate) So lets say for current year the rates are Jan 121.64 Feb 121.98 March 122.244 April 122.171 For example If I want to calculate for March I would show a column for January F
  • Error
    by Lovericky
    10 Replies
    Last post by Lovericky
      • I am getting the following error "An error occured during local report processing.Error during processing of 'Validate' report parameter " Any idea about this error
  • Advice on dimension-dependant KPI Goals
    by AlanKohl
    2 Replies
    Last post by AlanKohl
      • We have KPI goals that vary based on the country or state. For instance for US Stores, the goal is 2, and for stores in NY the goal is 2.8 I can create an SQL table with KPI_Name, Country or State, and KPI_Goal. I can also generate a view that will provide the proper KPI goal for each store. What is the best practice to implement this kind of KPI I just don't know where to start.
  • Merge replication error on the subscriber - call sys.sp_MSmakegeneration timing out
    by almondelm
    16 Replies
    Last post by almondelm
      • We are running on SQL Server 2005 SP2. Merge replication is on for one publisher and one subscriber. Merge replication is throwing following error "The process is waiting for a response from the query '{call sys.sp_MSmakegeneration ( )}" It is hung on there for atleast couple hour or so. I decrease uploadbatches and downloadbatches settings as recommended but no positive res
  • Moving ReportServer Databases
    by ApologetixFan
    4 Replies
    Last post by Jarret
      • Followed the steps in Books Online to move the Reporting Services databases from one server to another. After resetting all the keys and configurations, the site comes up. However, all my shared datasources have lost their connection strings, and have reverted to requesting login information. Is this how it is supposed to work If not, how do I fix this easily (as I have about 25 data sources)