SQL Server

Page 502




  • Topics
    Replies
    Last post
  • 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
  • padding property RS 2005
    by steveareno
    5 Replies
    Last post by actinium.ga
      • Anyone notice that the padding property doesn't seem to work as nice as RS 2000 When I select more than one cell or row, and try to set the padding to 1,1,1,1, by typing the values in the property field (as opposed to expanding it and entering it in each side), it sometimes it gives me the following error: 'RptPaddingConverter' is unable to convert 'Microsoft.ReportDesigner.Drawing.ReportPaddi
  • Select GetDate() Just the month or year
    by Lawrence 007
    11 Replies
    Last post by Arnie Rowland
      • I wonder if someone can help me with getting JUST the month and year from SQL DB. Using the Select Getdate() Statement. If I need to use another one that would work that would be appretiated as well. Thanks!
  • No Error but Export to Excel does not finish
    by JIM.H.
    3 Replies
    Last post by Shyam Sundar
      • No Error but Export to Excel does not finish When the report has 2 pages with total 500 rows exporting to Excel is not a problem. If it has 100 pages 5000 rows exporting to excel does not end and it does not return any error but the process does not end either. What might the problem be
  • How can I get a row count of CTE recordset?
    by Emongii
    3 Replies
    Last post by Emongii
      • Hi everybody, I want to get a row count of temporary CTE recordset. My query is like this: With SQLPaging As (  Select Row_number() Over (Order by Row_num) as RowNumber,  Row_num,  Column_A,  Column_B From OriginalTable ) Select * from SQLPaging Where RowNumber between 21 and 30 Let's assume SQLPaging definition contains 1,000 rows. If I use @@rowco
  • Problem Displaying Japanese Characters
    by Theodore C
    2 Replies
    Last post by Praveen Sadhu
      • We are a software developer here and ran into a problem trying to get SQL Server to display Japanese Characters through a linked server properly. Does anybody have any similar experiences The following configurations were able to display Japanese characters properly: =============================================================================== 1. Write a C# application to get Japanese character
  • RS Database Schema?
    by HerbD
    4 Replies
    Last post by BobP - BIM
      • We have a RS 2000 server with a over a hundred reports, and about half as many weekly and monthly subscriptions. In reply to my request to upgrade to RS2005, the boss asked me today for a compete list of the reports, who subscribes to them, and their delivery frequency. He was not interested in paying for a VB or C# development effort with the SOAP API that it would require to obtain a s
  • How do you set the article processing order for an RMO application?
    by JR-J
    3 Replies
    Last post by Mahesh Dudgikar - MSFT
      • Hi there, I have an RMO application and I would like to force the processing order of the articles. I can see in the documentation how to do this for a topology managed by sql stored procedures but I can't see how / where it says in BOL how to do this in RMO. I am pretty new to RMO and c# generally so please excuse me if I am just being thick! Cheers, James
  • Creation of a subscription to deliver reports via e-mail to individuals
    by Chandan Koushik
    1 Replies
    Last post by Pedro Pimentel Figueiredo
      • Hi all, how can standard subscription or data driven subscription be used to deliver reports to specific email address. the standard subscription or data driven subscription can be used to delever reports using Windows file share ,but how to make it work for delivering to emails.. can anyone help me out
  • MS Access and Sql Server Permissions
    by GEM1204
    1 Replies
    Last post by Steven Gott - MS
      • I have created an adp, and have created stored procedures for all of my forms. In the SQL Server database I have given my users permissions as db_datareader and db_datawriter, however they were unable to open any of my forms because they didn¡¯t have execute permissions on my stored procedures. I finally had to give them permissions as db_owner so they could use my forms. Do I have to give them db
  • Processing one 'fact partition or measure group' weekly, while others are daily?
    by tee_user5
    4 Replies
    Last post by tee_user5
      • Is this possible to have done in 2 different (or 1 intelligent) AS deployment script(s) Sunday would be the full processing day, while other days would just handle the smaller fact areas.
  • Format Decimal
    by plengski
    9 Replies
    Last post by Adam Tappis - IMGroup
      • A simple questions for you guys..how can i format a decimal from the result of my average Avg(Fields!myFields.Value) Thanks!!
  • set variable value at runtime
    by HuangBo
    3 Replies
    Last post by MatthewRoche
      • I'm trying to create a custom data flow transformation, I need to set the value of a user variable which will be used by a downstream component(for example: a data flow destination) at runtime, is this possible If possible, in which method should I do that Thanks.
  • SQL Browser Error
    by Santhosh Kumar
    3 Replies
    Last post by Satya SKJ
      • I have a two node cluster and X64 with OS windows 2003 SP1. I have like 8 instances of SQL Server running on it. I am running SQL 2005 SP1 and I am seeing the below errors in the windows event log. Event Type: Warning Event Source: SQLBrowser Event Category: None Event ID: 3 Date: 4/9/2007 Time: 3:06:13 PM User: N/A Description: The configuration of the AdminConnection\TCP protocol in the SQL inst
  • I cant get the xml data type
    by momibutt
    3 Replies
    Last post by MRys
      • I have just installed SQL server 2005 - Developer edition and the problem i get is: i dont have xml datatype available to me. I was able to use the xml datatye as long as i was using SQL server Express edition on a different machine. Please note that i have also applies SQL server 2005 SP-1 aswell but found no change in the datatypes available. I need urgent help in this regard. During the install
  • Please verify this SQL fragment
    by pwomack
    4 Replies
    Last post by pwomack
      • Will someone please help verify this SQL fragment I want to ensure that it produces the same results as the 'Group By' clause of the MS Access fragment below. T-SQL: Group By Case When r . LICFAC In ( 'CR' , 'GC' ) And f . SOPNO < 38 Then - 1 Else 0 End , Case When r . LICFAC = 'MU' And f . SOSTS <> '05' T
  • Total on a conditional field
    by Els001
    2 Replies
    Last post by Els001
      • I have to 2 texboxes in the detail line of a table TextBoxA = IIF( Fields!Total_Amount.Value >0, Fields!Total_Amount.Value,0) TextBoxB =IIF( Fields!Total_Amount.Value <0, Fields!Total_Amount.Value,0) I would like to total thoses textboxes in the group footer (Loan_Group1) I tried this for =Sum(IIF( Fields!Total_Amount.Value > 0, Fields!Total_Amount.Value,0)) Or =Ru
  • Basics
    by Alastair Q
    2 Replies
    Last post by Microsoft_TommyTP
      • Hi there, I've recently bought Visual Studio 2005, and I got SQL server 2005. I have no idea how to work it. I can't even find where you make a table. Any basic help about SQL server 2005 is needed. Thanks, AliQ
  • PDF rendering bug in SP2
    by gsherratt
    2 Replies
    Last post by JrDevRon
      • We just upgraded to SP2 and some reports now fail to render in PDF format. They render successfully as HTML within IE, but exporting to PDF gives the following error: An error occurred during rendering of the report. (rrRenderingError) An error occurred during rendering of the report. Non-negative number required. Parameter name: value The log gives the following traceback:
  • GACUTIL.exe Not Available
    by cdun2
    2 Replies
    Last post by cdun2
      • Hello, I am going through some examples on how to build custom tasks, and apparently, I don't have the gacutil.exe utility. I guess it does not come with the .NET Framework 1.1 or 2.0. How do I get this utility Thank you for your help! cdun2
  • Redbrick and Teradata OLE DB drivers for SQL 2005
    by Carlton Fong
    2 Replies
    Last post by Anton Klimov - MSFT
      • Anyone know where I can find these drivers
  • Trying to import an Excel worksheet to Sql
    by Vicki1027
    3 Replies
    Last post by Hemantgiri S. Goswami
      • I am trying to import data from an excel worksheet to sql mgmt studio express..Everyone has told me to right click my database, select tasks, select import but the problem is there is no IMPORT option..What did I do wrong
  • Report Model missing some fields
    by craiginscotland
    6 Replies
    Last post by Bruce27
      • I hope someone can clarify what I observe below. When I add a certain Table into my report model, one of the fields is not automatically converted into an attribute, but I'm not sure what the exact pattern is. This table has 3 fields as its key, two of them get included and one does not. The one that does not, is also added as a Role as it is used in a relationship within the DSV (Data Sourc
  • Bulk insert into an IDENTITY column
    by swg
    3 Replies
    Last post by swg
      • I have this table in my SQL2005 DB CREATE TABLE StringTable ( StringID int, LanguageID int, Category smallint, String nvarchar(max) ) I also have an Excel spread sheet that contains the above columns. I can insert the rows from the spreadsheet into the table using the sql client class SqlBulkCopy. No problems so far. However, I have now changed the above table so that the StringID
  • Accessing query execution plan results programmatically
    by Mitch Tishaw
    2 Replies
    Last post by Mitch Tishaw
      • Does anyone know if it is possible to access the execution plan results programmatically through a stored procedure or .NET assembly I have the code sample SET SHOWPLAN_XML ON ; query... SET SHOWPLAN_XML OFF ; but it can only be run from the interface. I have tried a couple of solutions including dynamic sql to try to capture the results in a variable or file with no luck. Does