SQL Server

Page 1728




  • Topics
    Replies
    Last post
  • Stopped running SLQSERVER and SQL Server Agent
    by shamen
    5 Replies
    Last post by shamen
      • Hi All, I was working on some reports on SSRS. Now I cant view those reports coz I can not open report manager. I noticed that SQLSERVER and SQL Server agent has stopped running in my local machince. But Other services are running properly (SSIS, SSRS, SSAS). When I go to SQL Configuration manager and try to run them, I get the following error massege. " The request failled o
  • Help! How can I get group chronlogical dates
    by Randaldtb
    14 Replies
    Last post by Randaldtb
      • Hi , I have the following table id SHC member start_dt end_dt 1 100-002-304 LOZANO M.D.,MARTHA E 1/1/2004 0:00 8/22/2004 0:00 2 100-002-304 LOZANO M.D.,MARTHA E 8/23/2004 0:00 9/30/2004 0:00 3 100-002-304 LOZANO M.D.,MARTHA E 10/1/2004 0:00 10/31/2004 0:00 4 100-002-304 WALT
  • String constants must end with a double quote.
    by raj416
    10 Replies
    Last post by raj416
      • i got this error when i was trying to deploy the report... in the preview mode report is working good.... D:\report1.rdl The expression for the query ¡®dataset¡¯ contains an error: [BC30648] String constants must end with a double quote. can any one gimme the solution
  • Newbie to CE 3.5 evaluation question
    by skitron
    2 Replies
    Last post by skitron
      • Hello - I'm a CE newbie evaluating 3.5 for use in a desktop app and have sifted thru the documentation, but still looking to find if this is possible: Insert into server2005_tbl select * from opendatasource (ce3.5 connection\db.sdf).ce35_tbl I've tried it with ce3.5 connection as: ( 'Provider=Microsoft.SQLSERVER.OLEDB.CE.3.5' , 'data source = "C:\...\db.sdf"
  • process cube but leave transaction open?
    by furmangg
    6 Replies
    Last post by Mosha Pasumansky
      • We have a massive cube. All but one of the fact tables are by 3am. But the final fact table isn't loaded in the SQL data warehouse until 11am. The users want the cube processed and available as immediately as possible. But the cube can't show ANY updated data until it shows ALL updated data including the fact table from 11am. Any thoughts on making this happen One option would be to pro
  • Report Builder - Data Model Filter
    by SQL713
    3 Replies
    Last post by David Leibowitz
      • I have built a data model in visual studio that I am using with report builder in reporting services. The data model is using data from a view in SQL Server 2005. I am trying to apply a filter to the data model to restrict the data available in report builder. I know that I could change the code for the view and filter that data that way, but I would rather creates two models each one producing di
  • Help with using spMSforeachtable
    by acmcdba68@hotmail.
    5 Replies
    Last post by acmcdba68@hotmail.com
      • I need to occasionally drop some table within a database that is has a naming convention of a datestamp... EX: tb_trans_20070516 The following is what I have written but and I am able to select the correct tables that I wish to drop leaving only the most recent "keep two days worth". exec sp_MSforeachtable @command1 = "select ' '", @whereand = "and name LIKE 'tb_trans_2%
  • how do I specify the order of results?
    by rknowles
    3 Replies
    Last post by rknowles
      • I have a query that returns a result set which includes a column named "CLASS_ID". If I want to specify that the results be ordered by CLASS_ID using the following order (210, 105, 302, 117), can that be done (assuming that those numbers are valid class ids) Or, are we limited by ordering in either ascending or descending order Thanks in advance for your help. roger
  • Job Fails on Linked Server
    by R3dD0g
    7 Replies
    Last post by Rajesh Basa
      • I've got a job running on a SQL2005 box (server07) that modifies data on a SQL2000 box (server05). The databases on the 2005 were imported from an older box running SQL2000. The step that is failing is: update server05.xtender.sysop.ae_rf4 set field3 = sname from server05.xtender.sysop.ae_rf4 x inner join allscholarships..studentsindb_table s on x.field1 = s.ssn where x.field3 is null or len(fiel
  • reporting service upgrade to 2005
    by mandand
    0 Replies
    Last post by mandand
      • Hi Our team¡¯s Reporting Service is still on Version 8.00.1038.00 and we are looking at upgrading this to 2005. I would just like to inquire on the steps taken to facilitate a seamless 2005 installation (process, configurations, how long it took, etc.). Kindly inform me if there are any existing guides/documentations which you think would be helpful. Thanks in advance for any response.
  • Any embedded tool in win2003 or SSIS for extracting the files from ZIP
    by daijun
    3 Replies
    Last post by Phil Brammer
      • Who knows whether exists embedded tool in win2003 or SSIS for extracting the files from ZIP Thanks in advance.
  • IRR Function Syntax?
    by benwa73
    7 Replies
    Last post by Punita Desai
      • I have a question about the syntax of the IRR function in reporting services 2005. Basically I have a table with 5 rows. I'd like to plug a column of data into the IRR function as an array (which is what it takes). Not sure how to convert a column into an array in an expression. Any help would be appreciated... thanks! Ben Lieb ben.lieb@tekelec.com
  • Any Data Cleansing Enhancement or features in Kaitmai?
    by Joseph Ollero
    1 Replies
    Last post by Jamie Thomson
      • Hi All, Are there any data cleansing enhancement or features that is included in KATMAI Something more in the line of householding, data catagorization and such Regards, Joseph
  • "Select Distinct..." statement
    by Scott_Wolter
    2 Replies
    Last post by Manivannan.D.Sekaran
      • How do I write a SQL statement that accomplishes the following... Select the contact, email, company, city, and state columns from the table named excel_imported_data and order the results by the state then the city BUT only show distinct email addresses. I don't want the distinct keyword applied to any column except the email column. So far I have select distinct email, company, contact, city, st
  • Connecting and Getting data from 8 tables in one sql statement
    by den2005
    8 Replies
    Last post by den2005
      • Hi everybody, I like to get data from 8 tables to be loaded in a dropdownlist or combobox control. Desired Result is need to be filtered by Region, Company, ProjectOffice, Country, and Location and still get all rows from 3 tables after applying filters. How can this be done in one single sql statement I have 3 separate sql statements which needed to be only one. Select C.CompanyID, C.[Na
  • Strange Exceptions with views usings casts on 2005 (worked fine on sql2k)
    by fatboy563820
    9 Replies
    Last post by fatboy
      • I have views that cast the data into data types. On 2005 when retrieving the views using a where clause i get errors. I have put together an example below that illustrates the error. CREATE TABLE TestData ( Id VARCHAR ( 10 ), [Description] VARCHAR ( 20 ), [Type] INT ) CREATE TABLE TestTypeLookup ( [Type] INT , [Description] VARCHAR ( 20 )) GO INSERT IN
  • Writing UTF-8 data to SQL Server
    by Ziad1397
    2 Replies
    Last post by Ziad1397
      • Hi, I am working on a project where data is stored remotely in a Postgres database. I need to download some of the postgres data and store it in the SQL Server. The data in PG is in UTF-8. I use another application to write the data to the PG database. To talk to the PG database I am using the npgsql data provider (http://gborg.postgresql.org/project/npgsql/projdisplay.php). The data I am trying t
  • Issue with UPDATE CUBE allocation
    by SureshYadav
    0 Replies
    Last post by SureshYadav
      • Hi , I am using the UPDATE CUBE statement in an excel macro(accessing Msas 2005 via pivot table) for allocations in a forecast cube, using the weighted allocation method . I have noted issues when allocating values at the parent level twice. For instance this is the initial value at the Product A total level - 1050.66 PRODUCT A CUST A 302.08
  • Reliability during synchronization
    by the_chad
    13 Replies
    Last post by Mahesh Dudgikar - MSFT
      • I am using SS05 64 bit standard edition, SP2 on a 2.8 GHz dual core Xeon 2 GB RAM box with a 146GB RAID 10 data partition and a 36GB mirrored OS partition. I have 13 publications over 5 databases. Some of these publications are transactional, some are merge with updating subscribers. I have 35 pull subscribers that use Windows XP SP2 and Sql Express SP2, and connect through wireless
  • SSIS Deployment and Removal issues
    by hlj16
    10 Replies
    Last post by hlj16
      • I created a setup package and installed it on my SQL2005 server. I cant seem to find anywhere on the server where they are installed, but I can access them from the Job schedule tool, which work for me. However, now I have to upgrade the deployed SSIS and I cant seem to install on top of an existing one (gave me no errors but after testing it i realized it is still running the old version.) My q
  • Reporting Services Advanced Features
    by Anonymous552645
    3 Replies
    Last post by jwelch
      • I am looking to find more information regarding advanced filtering/report parameters available in SQL Server 2005 Reporting Services. From what I can see, the user can set values for each report parameter and the query defaults to "where x = (param 1) and y = (param 2)" etc. Is there a way that a user can pick parameters that structure a more complex where clause For example, say I want
  • dtutil and xml configuration file
    by GROTH
    4 Replies
    Last post by jwelch
      • Hi, Im loading the packages with a dutil-batch from the file-system into the sqlserver. All the packages have xml-configuration-file. for %%f in (*.dtsx) do dtutil /FILE %%f /COPY SQL;%%~nf /DestServer server /QUIET When I try to run the packages in the sqlserver environment there is no configuration file found. Is there a possibility to transfer also the link to the
  • SSAS2005 Changes Schema Design for Aggregates, i.e. Employee Headcount?
    by Ian Mansell
    4 Replies
    Last post by Anonymous
      • Hi All, I will apologize upfront for my lack of knowledge and a lengthily post, I¡¯m a C#, COM+, SQL developer, trying to make sense of this SSAS stuff¡­ What I need to achieve is a cube based around employee data with emphases on reporting / drilling down employee headcounts by date (month, quarter) plus other KPIs like ¡°churn rate¡± e.g. employees hired, retired and terminated, etc
  • SQLServerCe Engine error
    by Jon Stroh
    2 Replies
    Last post by Ravi Tandon
      • I have successfully converted a MSVS 2005 Winforms Application into the MSVS 2008 beta 2. I am however having trouble getting the winmobile data tables to fill. The ODBC Paradox tables fill fine. When I converted the application I had to re create the win mobile datasource for the project. So I used the datasource wizard in 2008, it opened the winmobile5 database and told me that I would need to c
  • Calculated member (summing quarters)
    by GHano
    4 Replies
    Last post by PedroCGD
      • Hi, I have a minor problem. I need to make calculated member because of reporting in Quartal basis. I have fiscal month, fiscal year and fiscal quarter. I'd like to sum those figures like: where fiscal year is 2006,2005 and fiscal month on 1 and quarter is Q1 Thanks for your help.