Answer Questions

• ieligazit Order by clause in View doesn't order.

  I have created view by jaoining two table and have order by clause. The sql generated is as follows SELECT TOP (100) PERCENT dbo.UWYearDetail.*, dbo.UWYearGroup.* FROM dbo.UWYearDetail INNER JOIN dbo.UWYearGroup ON dbo.UWYearDetail.UWYearGroupId = dbo.UWYearGroup.UWYearGroupId ORDER BY dbo.UWYearDetail.PlanVersionId, dbo.UWYearGroup.UWFinancialPlanSegmentId, dbo.UWYearGroup.UWYear, dbo.UWYearGroup.MandDFlag, dbo ...Show All

• Creative URGENT: PARAMETER ISSUES WITH SQL TASK

  I have read all the post about passing parameters from sql task in and out and have tried them all with no anvile. Frist of, they are too many types to deal with now, db types, SSIS types. Why the hausl. Can we make data type flow a bit more easy. Well, enough about the complain. I have been trying to dynamically set my sql query statement for my datasouce component using a variable set by a sql task. The tried a couple of methods. Method 1 Usin ...Show All

• venkydshow Invoice Pagination - How do I start next costomer on new sheet when needed?

  Someone has to have asked this question before but I could not find the answer.  I did find some places, not on this site, with the question. Basically like the title says, I'm just doing for a different purpose but figured invoicing would be the most popular reason.  If the last page of a group prints on the front of the sheet then I need to advance past the back of the sheet and onto a new sheet to start the next group.  ...Show All

• fgatorbit .TMP Files in OLAP folder

  Hi,   I found that there are a lot of .tmp files in OLAP folder (ex : C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data)   What do the .tmp files do   Could I delete these .tmp files thanks, ...Show All

• Mike Hull Changing collation in SQL 2000

  I have a database in SQL 2000 on which I am trying to convert the collation to case insensitive from case sensitive.  I am trying to use DTS to do this.  The master database is already case insensitive.  I have created a new database on the same server with the proper collation.  I am then trying to use the DTS to import the data by replacing all objects.  I am essentially trying to copy all the database objects changing ...Show All

• AdLearning.Net Problem installing sql 2005 express ---cannot start service etc.... :(

  2006-03-26 20:33:09.42 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4) 2006-03-26 20:33:09.42 Server (c) 2005 Microsoft Corporation. 2006-03-26 20:33:09.42 Server All rights reserved. 2006-03-26 20:33:09.42 Server Server process ID is 2068. 2006-03-26 20:33:09.42 Server Logging SQL ...Show All

• vpsivam Reporting Services Query designer toolbar disabled

  Hi to all , i'm trying to modify an mdx generated by query designer in "Design" mode. I would like to switch to query designer in "Query" mode but the query designer toolbar and its button "Change Type" appears to be disabled. In this project i use a shared data source and the data source type is Analysis Services. In another project I followed the first basic Tutorial on Reporting Service ("Sales Order" report) so data source it's SQL Server an ...Show All

• Prajakta Send report to mail

  Hi, Is it possible to send report to mail You mean inside an email I was wondering if it is possible to render and send a report inside the body of an email instead of attaching it to the email so that when it is sent the users can see the report. Can this be done without writing my own delivery extension Hi, You can create subscriptions which send reports by email to receivers. You can determine ...Show All

• dan123 Pipe Dream : SQL Express access from VB6

  I know this is a long shot, but does anyone have any code for accessing a SQL Express database from VB 6.0. I have an app that uses COM extensively to communicate with several 3rd party products. I haven't taken the plunge of translating it to .net yet because some of the 3rd party products only have COM based SDK interfaces and I'm not into self-abuse. Now I'm thinking about adding an interface to DotNetNuke 4.0 which uses an SQL Express dat ...Show All

• christian p Whats the business value of Postbacks in Parameters??!!!

  Dear Anyone, I fail to see the business value of the postbacks that happens on report parameters. Say for example we have a report that has 12 parameters. All parameters uses 3 different data sets to set their respective contents. 3 of those parameters are cascading parameters. It is understandable to have post backs that would involve those 3 parameters. But instead, all of the data sets in the report parameters section refreshes themselv ...Show All

• Gorav User Defined Number Generator

  Hello all! I have a windows forms app and I'm trying to add functionality that would allow the user to enter a number into a textbox control on a setup form and then that number would autoincrement by one each time a new record on another form is inserted into the DB . I've searched high and low and can't seem to find much information on how I can put this together. I'm sure I'll need a "numbers" table in the DB that stores the n ...Show All

• iliketoeaticecream Visual Studio 2005 - "Generate Create Script" for SQL 2000 stored procedure

  Hello. I have noticed that "Generate Create Script" feature changed in VS 2005 (compared to 2003). In VS 2003 this feature was displaying dialog window where I could choose some options on what to include in script and where to place it. In VS 2005 this feature just creates SQL script in "Create Scripts" folder, without any intermediate dialog, and now it uses sp_executesql procedure in a script. Is there any way to change this ...Show All

• CSharpDavid Filter a Model Table?

  I am using  RS 2005. I am setting up a Model for use within Report Builder so our clients can write their own reports. A 2 part question, simple question first: 1. How can I filter the records in a Model Entity I thought this would be possible from a Perspective but it is not. 2. How can I filter the records in a Model Entity based on the locale of the person who is logged on And also based on their permissions TIA Is the ...Show All

• Glen Profeta Issue with URL Encoding report's hyperlink value.

  Hello, I've created a hyperlink in a report.  The hyperlink action is 'Jump to URL'   The URL is http://ServerName/SomePage.aspx AccountCode=####&InvoiceLevel=1 The hyperlink works just fine in the designer, it's value becomes http://ServerName/SomePage.aspx AccountCode=%23%%23%%23%%23&InvoiceLevel=1 , however when I run from the web the report's URL is not properly URL encoded.  It's value is http://Server ...Show All

• lagu2653 Clarifications on Queue Service and Queue Readers

  Hello, This is info that I am still not certain about and I just need to make sure, my gut feeling is correct: A. When a procedure is triggered upon reception of a message in a queue, what happens when the procedure fails and rolls back 1. Message is left on the Queue. 2. is the worker procedure triggered again for the same message by the queue 3. I am hoping the Queue keeps on triggering workers until it is empty. My scenario is that my queue r ...Show All