SQL Server

Page 3529




  • Topics
    Replies
    Last post
  • Please help me to clarify my Doubts related to report builder
    by polachan
    6 Replies
    Last post by polachan
      • Dear Expertise Please give me a solution to my general question. 1. How can we Impliment the report builder in client machene. 2. What is the diffrense between Report Server and Report Builder.
  • How to group the retuned query!
    by Luke Sayaw
    6 Replies
    Last post by oj
      • Hello, I am wondering how can I group the returned results from the sql query. For example, the following sql qurey retrieved data from a few tables from the database on conditions using "inner join". The returned results are not grouped or organized into groups. I would like to group the retrieved data based on three different tables such as "Overall", "Spectograp
  • how to get user name of the person loged in to the system in SQL
    by Gaya_3
    3 Replies
    Last post by Gaya_3
      • Hi, I have written a trigger for audit trail of one table in SQL and it has to get the user name who is doing the changes from the application(.net) I have used the SQL user name and password while connecting the .net application to the database, and because of this whoever log in to the application and make changes on that table data, in the audit trail it still shows as the database us
  • Memory Allocation Error with XMLA Script
    by SallyOLAP
    2 Replies
    Last post by SallyOLAP
      • Hi All, I am attempting to execute an ALTER cube script against my analysis services database. When it executes I receive the following error: Memory error: Allocation failure : Not enough storage is available to process this command. My server is running Windows Server 2003 and has 3.5 GB ram. I am tempted to tweak the memory settings in AS2005, but I was wondering if someone has already
  • Polar Charting with Reporting Services
    by KMuhlbach
    1 Replies
    Last post by BobP - BIM
      • Does anyone know if you can do polar charting with Reporting Services I have a need to report the polar coordinates of an element and show the polar chart of the data elements. If I can't do polar charting with Reporting Services, does anyone know of a third party product that I can utilize Thanks KM
  • Unable to initialize reporting service after installing SP2
    by HonFui
    4 Replies
    Last post by PWilly
      • hi, I have problem initialize report server after upgrade to SP2.. It keep saying Could not locate entry i sysdatabases 'myDatabaseName'. while i'm sure my database existing. Here's the log <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.3161.00</Product> <Locale>en-US</Locale> <TimeZone>Malay Peninsula Standard Time</TimeZone
  • The peer prematurely closed the connection error
    by TomWhite_jr
    4 Replies
    Last post by Darren Gosbell
      • When I tried to Access the 2005 cube through the ADODB "The peer prematurely closed the connection error" error is coming the line con.Open(conn,"sa","",0) and the connection string is string conn="Provider=MSOLAP;Data Source=.;Initial Catalog=Adventure Works Dw"; Thanks in advance
  • Creating my Db on another server
    by tattoo
    1 Replies
    Last post by Sankar Reddy
      • I want to re-create my entire database on another server. Using SQL Server Management Studio I went to my database and right clicked on it. Then Tasks and then Generate Scripts. Then using the Scipt Wizard I created a script which looks like it is creating all my tables. Then I saved it as an ANSI File and sent it to my production machine and tried to run the script h
  • SQL Server 2005 and SQLMAINT.EXE with no output
    by Uwe Keim
    2 Replies
    Last post by Satya SKJ
      • When starting SQLMAINT.EXE from the command line on a SQL Server 2005, I get no useful output at all:
  • Code Profiler is executing for requested trace
    by JJKusch
    1 Replies
    Last post by Jens K. Suessmeyer
      • Afternoon, Is there a way in SS2K5 Profiler to see what the code looks like for the trace being executed And then further, is there a way to copy the code and rework it in an SP Thanks ALL! J Kusch
  • concatenate dateparts
    by mkhines
    2 Replies
    Last post by Arnie Rowland
      • Hi there, We are storing dates in a SQL table as dayPublished, monthPublished, yearPublished because sometimes not all the values are available. I thought something like select dbo.Resources.monthPublished + '/' + dbo.Resources.dayPublished + '/' + dbo.Resources.yearPublished as fullDate but it doesn't like my slashes, and if I leave them out it simply adds the three fields together. Boo!
  • Reload report on parameter selection
    by Kiranvukkadala
    0 Replies
    Last post by Kiranvukkadala
      • I have a parameter which has a default value set to it. when a second value is selected is it necessary to click the view report button. Could it be set to auto reload on dropdown selection. It is possible tyo drive a parameter off another paarmeter through the SQL query but would it be possible to reload the report through the query I am using reporting Services 2000 Thanks. Kiran
  • which is faster reporting services 9 or crystal report 11?
    by Jocker23
    6 Replies
    Last post by Jocker23
      • hey i m startint in reporting services 9 and i find it so interesting but kinda slow, which is faster reporting services 9 or crystal report 11 best regards Joseph
  • Parameterized Query Using Wildcards in VS2005
    by lvance1611a
    14 Replies
    Last post by FixBo
      • Hey everyone, I have a smart device project in Visual Studio 2005 that has a SQL Mobile data source. I am trying to create a parameterized query that utilizes 'LIKE' and wildcards. My query is below: SELECT LocationID, StreetNum, StreetName, rowguid FROM tblLocations WHERE (StreetNum = @StreetNum) AND (StreetName LIKE '%' + @StreetName + '%') However, when I test this on my PDA, I get the
  • Find the most recent date of the past
    by Cactus77
    14 Replies
    Last post by Cactus77
      • Hello, I've a table which contains the nest following data: Date Sales Price 01-01-07 5,00 31-03-07 6,00 16-04-07 5.75 26-04-07 6.25 For example, today is 18-04-07. In my report I want to show the most recent Sales Price, but not the price of next week. I want to see the SalesPrice of 5.75. How can I get it Thx!
  • AcquireConnection throws COMException (0x80131904) in custom component
    by lasa
    4 Replies
    Last post by lasa
      • We have built a custom component that is run in a dataflow contained in a sequence container, which in turn is contained in a loop. Transactions are enabled on the sequence container in such a way that if one step in the loop fails, that step is rolled back but the loop continues. Now, whenever anything happens causing a rollback in one of the iterations, sometimes the call to AcquireConnection in
  • Changed Datatypes not Propagated to View
    by likethesun
    3 Replies
    Last post by Arnie Rowland
      • I changed a datatype on a table column. I expected this revision to be reflected in the table view column but the old datatype shows. I'm using SQL Server Express. Is there something I should specify when editing the column so I don't have to drop/add the view (btw, column has an alias in the view)
  • update query
    by arkiboys
    1 Replies
    Last post by ManiD
      • Posted - 01/16/2007 : 07:01:40
  • Insertion values into table1 slecting value from same table table1
    by AK Dwivedi
    5 Replies
    Last post by ggciubuc
      • Hi! All, I Need help All of you. I am going to insert clone of a particular record into same table but there is a primary key Identity on , Thats create problem to insert data using following code INSERT INTO SERVICE_PLACEMENTS_SOS SELECT * FROM SERVICE_PLACEMENTS_SOS WHERE ID=1, "Anil", "24" here Also I need some my values inserting into this table, Means some field value
  • Reuse existing data flow components in a custom data flow component
    by yoann chaine
    13 Replies
    Last post by John Saunders
      • Hello, Is it possible to use existing data flow components (Merge Join, aggregation,...) in a custom data flow component Thanks, Yoann
  • Accessing Data Fields in Page Footer
    by Galaxy
    3 Replies
    Last post by Shyam Sundar
      • Hi All, How do I access data fields in page footer. Although Page Header and Page Footer can't contain data fields. What is alternative or other other solution for the same It would really nice if somebody can help me out. Thank you Regards, Palak Shah
  • SqlCe not for productive use?
    by Stefan Z.
    1 Replies
    Last post by ErikEJ
      • I'm still having trouble deploying my Compact Edition application. The installation on other computers works, but if the program tries to start, i get the error message (translated from german): " This Version of SQL Server 2005 Mobile Edition is not licencensed for productive use " I always thought that there are no licence restriction with SQL Compact Edition. Strangely the the program
  • Trigger with access to remote server
    by jakub78
    6 Replies
    Last post by jakub78
      • Hello, i have two server connected to internet S1 and S2 (connection between both is only internet too). I need write trigger on S1 which send update or another command to S2. Is it possible, and how (without using .NET methods only by using Transact SQL) Thnx, jakub.
  • Case Statement Problem
    by Rgoal
    2 Replies
    Last post by Ranigoal
      • I am trying to convert this to sql syntax SELECT [2007_hours].proj_name, [2007_hours].task_name, [2007_hours].Employee, IIf(Mid([task_name],1,3)='PTO','PTO_Holiday', IIf(Mid([task_name],1,7)='Holiday','PTO_Holiday', IIf(Mid([proj_name],1,9) In ('9900-2831','9900-2788'),'II Internal', IIf(Mid([proj_name],1,9)='9900-2787','Sales',
  • Aggragate transform with "WHERE" condition
    by fasttrack
    4 Replies
    Last post by Jamie Thomson
      • Hello, I am new in SSIS. I have to Load a table with aggregate data, I can do it using Aggragate transformation, but other the "GROUP BY" I need to make a filter on input records with "WHERE" condition. In TSQL it should be: SELECT col1, SUM(col2) FROM T GROUP BY col1 WHERE col3 = value. But in SSIS How can I do it Thank