Answer Questions

• DevInstinct Set initial sort direction using Interactive sort.

  How can we change the initial sort direction from being ascending Some reported columns logically require initial sort to be descending. Short of creating a custom sort parameter, and using the sort the old style (sql 2000 rs). Thanks. Sam The closest you can get is to use a regular sort expression to get the initial sorting. -- Robert ...Show All

• NavneetSharma Question about Aggragation in Measure Group?

  Hello, I am working on a project using SQL Server BI Developement Studio 2005.  While designing a cube, I would like create a Measure Group that shows me a count of students grouped by department or school.   However, I am not able to see an aggragate function under Measure Group's properties that would take care of this   For a while I was thinking about using "ByAccount" function but my dimension doesn't h ...Show All

• BrianNoyes can anyone guide me

  i'm very new to SQl server, even i know nothing about it, all what i know about is Ms Access, i want to ask that :- 1) what is the differences between the queries and the stored procedures, i don't know till now i see both of them are the same thing. can anyone please till me what is the difference 2) i downloaded sql server express edition and it doesn't has interface , in the same time i can't install the managment studio , every time i ...Show All

• Bruno Estrozi using English query in sql server 2005

  Hi, Our application is based on sql 2000 which uses English query. we are planning to migrate our database to new sql server 2005 so that we can use many new enhanced features. But it is found that new version doesnt support English query. ( http://msdn2.microsoft.com/en-us/library/ms143754.aspx ). Could you please some one tell me how can i re-distribute my english query component with sql server 2005 are there any work arounds Thanks in ...Show All

• Eugene_B UPDATE statement via stored procedure

  Hi, I have a question regarding updating a record with SQL 2000 or SQL 2005. Imagine the following scenario: - A database table "Customer" with the following fields: id, firstname, lastname - A stored procedure : ..... @Id uniqueidentifier, @LastName varchar(20), @FirstName varchar(20) UPDATE Customer SET ID=@Id , firstname=@FirstName , lastname=@LastName WHERE ID=@Id .... Imagine that in the paramet ...Show All

• singhhome Looping through rows in flat file

  I'd appreciate some guidance on how to solve a problem. I have a flat file of the format Header1 Header2 Header3 Data Record Data Record ... etc. ... Data Record Trailer1 Trailer2 I want to loop through each data record. I want to take a column value (string) from each row, and call a stored procedure passing in that value. The s/p will return another string which I want to use to update the original column value from the flat file. If I can't u ...Show All

• A* AdventureWorks db for 101 Samples

  I'm not sure if this should be asked here.  If it's the wrong place, let me know and I'll correct. I've just downloaded 101 Samples for Visual Studio 2005 .  But the data access samples require AdventureWorks database which is not included in the C# sample.  Who know where I can get this database   It is a SQL 2005 database, I think. Thanks! gaile- Thanks for your quick response. Specifically, from CreatingMast ...Show All

• Geetanjali Logical functions in SELECT clause

  Hi, this ought to be elementary: I want to select the logical inverse of a bit type column. The online help tells me Syntax [ NOT ] boolean_expression Arguments boolean_expression Is any valid MicrosoftR SQL Server Boolean expression. Result Value NOT reverses the value of any Boolean expression. The way I read this I should be able to then simply SELECT NOT bit_col, yet I get a syntax error when I try to do simply ...Show All

• MrNoBody Where is the Northwind SQL scripts for SQL server 2005

  I am looking for the northwind install script in my SQL server 2005 directory and cannot find it. The introduction to VB 2005 uses it for an example and I would like to walk thru it. Does anyone have the sql If so could you send it to me. I am going to see if I can get it off a 2000 install. Thanks. No, we did not update the Northwind or pubs sample databases for SQL Server 2005. Instead, we created a new samp ...Show All

• cbnicholson Get the return code of "Execute Process Task"

  I am running one .Net console application through "Execute Process Task". In case of error I want to trap the return code of this "Execute Process Task", so that I can put some meaningful error message. Is it anyway possible to trap this return code ...Show All

• Sander_G Passing datetime parameter to a stored procedure

  Hi, My report has a datetime parameter and my stored procedure has also a date parameter. Is it possible, from the report, to pass the datetime parameter to the stored procedure without converting it to a string Thank's Eric ...Show All

• DataCorrupt Command USE with variable

  Why I can’t use the command USE with variable declare @banco varchar(20) select @banco='xpto' USE @banco I have try in other way without success DECLARE @banco varchar(50) declare @SQL varchar(50) select @banco='xpto' print @banco select @SQL='USE '+@banco print @SQL exec(@SQL) Help me, please. Rodrigo It is executed at both compile time and run time, so I presume that is the reason. Not all com ...Show All

• raveIndia Advice on a process

  I'm looking for best-practices advice. I have a flat file that gets produced by a mainframe system every day. I need to import this data into a relational database each night. I will use the data to do some numerical optimizations (generallly it will be a knapsack algorithm) for scheduling of machine and personnel resources. The file is a "rolling" list of our back orders. By rolling, I mean that when a job is complete it drops off the ...Show All

• Nate Dogg28871 SubTotal

  can you explain further any sample data with desired output will help anyone something like a GroupSum() function.   icemart525 wrote: I'm using a table, my total returns the Total of the column and not the group. I have not tried a list or a matrix though. Okay, for this scenario just put your table inside a list, and apply the group expression to the list. The list (with its table) then gets (automati ...Show All

• plavun FREETEXTTABLE

  This is my proc... ALTER PROCEDURE [dbo] . [IT_GetKBFreeText] @Search Varchar ( 8000 ) AS BEGIN SELECT KEY_TBL . RANK , KB_TBL . KNOWLEDGE_BASE_UID FROM dbo . INFOSYS_KNOWLEDGE_BASE AS KB_TBL INNER JOIN FREETEXTTABLE ( dbo . INFOSYS_KNOWLEDGE_BASE , ( KNOWLEDGE_BASE_SHORT_NAME , KNOWLEDGE_BASE_TEXT ), @Search ) AS KEY_TBL ON KB_TBL . KNOWLEDGE_BASE_UID = KEY_TBL . [KEY] ORDER BY K ...Show All