SQL Server

Page 3259




  • Topics
    Replies
    Last post
  • Derived Columns Expressions Evaluate Incorrectly
    by David C Baldauff
    9 Replies
    Last post by Bob Bojanic - MSFT
      • All, I have seen it happen frequently that I type in a perfectly valid SSIS expression (this is easy for me since I am an old hand at C++/C/C#) in a row in a Derived Column transformation, and it turns red. Or sometimes, I will have an invalid expression that I correct, but it stays red. Finally I have also seen it happen that I make some change in the data flow pipeline and suddenly a Deri
  • How Does one Save a Stored Procedure
    by grbourque
    3 Replies
    Last post by grbourque
      • I have had the same problem. In the past I had the sql commands in the code. Last project was with SQL2000 and I decided to add store procedures part as a learning tool and part to better control the code. With the current project I am using SQL2005 and have a ummm fun time with the learning curve. Below is my stored procedure. USE [AdventureWorks] GO SET ANSI_NULLS ON
  • Passing multi value parameter between reports
    by km6589
    1 Replies
    Last post by km6589
      • I've seen some theads on this but cant seem to get this right. Report A has 5 parameters 2 of them are multi value-- when I click on part of Report A I want to jump to report B and pass all parameter values from report A. The single value ones work but multi value only passes on value and not all values selected-- what am I missing here Do I need to pass the values in the multi value parameters i
  • Database Mirroring
    by CharlieEvans
    1 Replies
    Last post by gaile
      • Can you give me some details or links on the improvements to database mirroring in SQL 2008
  • Text always truncated in update statement
    by Higgs Boson
    2 Replies
    Last post by Higgs Boson
      • I have a very simple query: -- ============================================= -- Author: ######### -- Create date: ######## -- Description: -- ============================================= ALTER PROCEDURE [dbo].[###########] -- Add the parameters for the stored procedure here @quoteid int = 0, @useraccepting nchar = " " AS BEGIN -- SET NOCOUNT ON added to prev
  • Name of Tables and Columns
    by gutelade
    4 Replies
    Last post by gutelade
      • Hi, i just migrated an database from oracle to sql server 2005 with the migration tool from microsoft (v3). the migration tool works only with uppercase table and column names, but i need them in lower case. is there a way to modify the names of tables and columns with t-sql to lower case Thx Frank
  • Unable to install SQL Server 2008 on Windows Vista
    by Robert_W
    8 Replies
    Last post by spidermake
      • I am unable to install the latest CTP of SQL 2008 on my Windows Vista machine. It gets through all the things that happen before the install starts, but when it tries to install I get the following error message: "The installer package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Instal
  • I Need My Dynamic MDX Expression in Reporting Services to Return the same Column Names For Reporting
    by Orville
    2 Replies
    Last post by Orville
      • I am building a dynamic MDX expression that returns a different columns based upon the user selected parameters. However, I want the name of the columns to be fixed regardless of the dimension/attribute being queried. Below is an example of my MDX expressions. I would like both expression to return a column called "DisplayMember" . In Standard T-SQL. I could do this by use a field ali
  • SQL script to change output to file
    by Wasabi_Sushi
    16 Replies
    Last post by Wasabi_Sushi
      • This has probably been asked before and I am having a hard time finding an answer for my question. What I'd like to do is create an SQL query script file that exports the records of a select statement to a delimited file. I used to know how to do this in Oracle but I can't find any way to do this in SQL Server. In Oracle I used to call a command from the script to change the output t
  • Elegant merging of XML fragments?
    by ArtusKG
    0 Replies
    Last post by ArtusKG
      • Hi there :-) Which is the recommended way to merge two xml fragments I have several variables containing xml adhering to the following sample "schema": <Info attrib1="some", attrib2="data"> where the Info element may occur several times. Now I want to merge these xml fragments / documents to one larger xml document containing all Info
  • Export to PDF and print in landscape
    by indersunny
    3 Replies
    Last post by bobby_macnair
      • Hello I have a report which I can print on legal paper, once I choose the landscape settings on print menu. When the same report is set to export to a file share in pdf format, it renders in portrait format. Is it possible to have the pdf document look like the landscape view so that the user can just hit print. Thanks Inder
  • Date formatting
    by Frank The Tank Carty
    3 Replies
    Last post by Arnie Rowland
      • Is there a function to return the date in the format of "4 July 2007" instead. I am returning rows which contain dates in the format "20/07/2007 10:48:16". Is there any function that convert, or will I have to write the code myself I dont mind writing the code, but its a friday evening, and I am lazy and tired :-)
  • Scripting Service Broker objects using a remote connection
    by Rob Hammond
    1 Replies
    Last post by Rob Hammond
      • Hi I have recently upgraded several of our SQL2005 servers to SP2a :) version 9.0.3050 and find that I can no longer script the Service Broker objects from a remote connection. The error I am getting is: Script failed for MessageType 'MyMessageType' (Microsoft.SqlServer.Smo) Additional Information Either the object or one of its properties is not supported on the target server versi
  • Computing and assigning a value to a textbox from other data regions
    by DotNet_Guy
    5 Replies
    Last post by DotNet_Guy
      • I am new to SSRS, so perhaps its a trivial question. I was wondering that since all controls have names in the report, is it possible to programatically access values of different textboxes, do some computation and then assign to another text box I know how to do it using the Aggregate functions and operators, but am not sure if I can access values from textboxes within two different tables and as
  • sp_spaceused Question !
    by JaguarRDA580842
    4 Replies
    Last post by JaguarRDA
      • name rows reserved data index_size unused Table1 2553136 294424 KB 293176 KB 1072 KB 176 KB When I run sp_spaceused on a table called Table1, I get numbers as shown above. I have a clustered Index on a datetime column AND that is the only index on the table. So according to my calculations Index Size should be 255
  • Fail to read entire table in .NET
    by TomAtAbilities
    1 Replies
    Last post by TomAtAbilities
      • The problem that I am having is that I am not getting the results from an entire table, just a small subset. The sql command is "Select * from login", which has always implied to me, get everything, to end of table, or, until I tell you to stop. I am getting exactly, 10 items as input, and then it stops. I am including the code below in the hopes that someone can spot what it is that I a
  • Is there a way to have list of NOT words with containstable (especially begining with NOT)?
    by pats2kdynasty
    2 Replies
    Last post by pats2kdynasty
      • This works when @searchString is used in containstable (provided searchString has value)... set @searchStringNoneOfWords = 'not(Airplane)' SET @searchString = @searchString + ' AND ' + @searchStringNoneOfWords This does NOT work when @searchString is used in containstable... set @searchStringNoneOfWords = 'not(Airplane)' SET @searchString = @searchStringNoneOfWords I understand it is because the
  • resultset from proc as inline view?
    by Bjorn D. Jensen
    9 Replies
    Last post by Bjorn D. Jensen
      • Hi! I have some stored procedures returning resultsets. You can store this resultset in an table (table variable, permanent table or temp. table), but this would require additional code, which has to be maintaned when called code is changed (typical added columns in resultset). I would like to avoid this, if it can be done with minimal overhead. I looked at openrowset
  • SQL Server Reporting Services 2005 group expression
    by Barb Viola
    1 Replies
    Last post by Robert Bruckner MSFT
      • I have an expression in a group that calculates a percentage of sales: =iif(Sum(Fields!BOOKD.Value)=0,0,IIF(Sum(Fields!NET.Value)=0,0,((Sum(Fields!BOOKD.Value)-Sum(Fields!NET.Value))/Sum(Fields!BOOKD.Value))))*100 If there is a 0 balance for both the book dollar and the net dollar the expression returns #Error. I have made sure that if the value is null it should return a 0 in the init
  • AS/400 DB2 Driver Not available
    by Pubudu
    1 Replies
    Last post by soanfu
      • Hi Sorry for troubling you.I have stucked on this. I tried to download but not exist in the IBM site. If u r already having it can u just send it to me to this email. pubudu_nt@hotmail.com or publish the web link. Thanks. Pubudu
  • Wildly different results from queries on the same database on different servers
    by Henry Lafleur
    6 Replies
    Last post by oj
      • Hi, We have a client who runs SQL Server 2000 queries on one database server and performance is approx. 4 seconds. If the database is backed up, no tables in the query or indexes on these tables are modified (we may run a small script that affects stored procedures, views, etc.) the query can run virtually forever. The customer is runing a cluster and we are running a stand-alone. Al
  • Execute SQL outputting to a file
    by Mike Caprio
    14 Replies
    Last post by Mike Caprio
      • I continue to try and find "easy" solutions to what should be a straightforward problem of outputting the results from a stored procedure to a file. I tried using both XML task and file system task with the thought that one of those would actually be able to output a file from a variable, but both of those tasks threw fits when I tried using different variable types (file system r
  • Foreach loop runs out of memory
    by ADG
    14 Replies
    Last post by ADG
      • Hi I have a for each loop which steps through an ado recordset (approx. 5,000 rows), this passes two variables to an SQL statement which populates a second recordset (normally 8 to 10 rows). I use the second recordset in a dataflow task which was a simple Script which returns approximately 30 rows for inclusion in my destination table. The package runs for a while OK, although the loop appe
  • Queries going to Suspend state with wait type ASYNC_NETWORK_IO
    by knvdssr
    5 Replies
    Last post by oj
      • Recently we observed a problem. We are running stored procedure through our c# code. Three machines access the server and update or insert in the required tables in the server. If there is no data in the server, on installing first time our application usually our database is clean. then stored procedure works fine, it takes around 10 to 15 sec to execute. Next time if execute the time goes up to
  • SQL Server 2005 Samples???
    by dbayona
    3 Replies
    Last post by dbayona
      • when I install the example of the SQL Server 2005, the following one does not install ˇ°Simple AS Sampleˇ± that is a program of example of C# that shows the use of the Objects of analysis administration (AMO) to create complex cubes OLAP and the use of ADOMD.NET to obtain access to the content of the cubes. According to documentation it must be in this predetermined location ˇ°c: \ program files \ Mi