-
- 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.