Answer Questions

• LucMorin How to achieve rowid of Oracle in SQL Server

  Hi: How can I get the same function of rowid of Oracle in SQL Server. thanks Hi: How can I get the same function of rowid of Oracle in SQL Server. thanks Link Just use MSSQL 2005. ROW_NUMBER() function (see ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/82fa9016-77db-4b42-b4c8-df6095b81906.htm) is presented there. ...Show All

• Toby Russell Full Text Search in RB

  Dear Anyone, If full text search possible in RB If so, how do we do this Thanks, Joseph If you mean a high-level way to search all text fields for a given string, no, this is not supported in RB. For a single field, you can use the Contains filter condition operator. Hi Bob, I am using "contain" operator but when seach box is empty i would like to return "All" rows instead of no rows. Is there a wildcard I can ...Show All

• kmax Query Designer in SQL 2005 is total %#%!@

  What happened to the Query Designer   It's a modal window that doesn't allow you to drag tables from other databases into the query.  SQL 2000's verion of Query Designer was so much better than 2005.  What happened   Are the developers at Microsoft completely retarded   Also, why do I have to log into my database servers everytime I open "Server Management Studio"   Who thought up that nice feature   Probabl ...Show All

• P.Alex Advantages of Multiple Instances

       Where can I find advantages of Multiple Instances on a single Server.   I'm moving this thread to the database engine forum for expert comment. Are the bulk load and other applications accessing the same table or different tables Is the bulk load consuming a large percentage of CPU or disk throughput Paul Instances are fairly well isolated ...Show All

• TarPista Top 20 ordered and rest grouped into 'others'

  Hi guys.   I want to create a top 20 product list from a few thousand products. I want the rest of the products to be grouped into 'others'...   I also want the products to be ordered by the facts in the cube. Thus the product dimension would dynamically change depending on the Time dimension thats being selected.   is this plausible   Thanks Tom Hi. I'm not sure if pivot tables s ...Show All

• rocklandusa Display a datagrid using the dataset as the source??

  I am not sure how to display this in my report. I have dataset that queries the database to find a list of ingredients. I would like each ingredient listed in a grid. Under each individual ingredient is its amount, which is found from the database, using the Product and Ingredient name discussed above. The ingredient dataset has a list of ingredients. So I need the first one displayed in the first field, the second in the second field and so on. ...Show All

• luchtcm BCP IN column limit

  I am encountering a limit when attempting to import/load/read a file using the BCP functions in SQL Server 2000. The import fails when I have around 200 columns. Is there a similar limit in SQL Server 2005 Stated differently, what is the maximum number of columns I can import with bcp Are there other maximums I should be investigating My incoming record length is about 2K. No success so far. The proj ...Show All

• Eric Schnepp - MSFT Mapping UDF Parameters to Variables

  As mentioned in a previous posting, I have an in-line table valued UDF with three input parameters. I can set this up as an OLEDB Datasource  SQL Command Text with parameter markers (i.e. " ") and test it successfully in the Generic Query Builder. The parameter markers are correctly associated with the input parameters of the UDF and the parameters can be entered at execution time into a parameters table. So near and yet so far. Whe ...Show All

• capslocker Management Studio Express - open table with query

  Is it possible to open a table for editing directly with restricting SQL Select query Now I have to open the whole (!) table first, and then edit the SQL Select query. There was such choice in Enterprise Manager (Open Table - Query). You can do this by creating a new T-SQL editor instance (right click on the database in Object Explorer and select New Query), then right click on the editor and select Design Quer ...Show All

• Col3456345 The multi-part identifier "alias.field" could not be bound???

  Hi, When I try execute one query in SQL 2k5, with alias in order by clausule, I retrieve the follow message: Server: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "alias.fields" could not be bound. Where alias is a any alias and, fields is a field of the table with alias. Already exists one fix to patch this Thanks Send the SQL that is causing this. I think you are ...Show All

• Paurav Chudasama How can we improve the cover rate of the model?

  Hi, all here, I found that in my case when I trained the data mining models, the model cover rate is very low (in my case, the train data set has 82 rows but the case occuring in the models I trained is only 25). How can I improve the cover rate to improve the quality of the models (if it is possible in SQL Server 2005) I am using SQL Server 2005. Cheers. Hi, yes. my training data set is quite small which is some university marks data ...Show All

• Ronald S. Replicating Schema only

  Hi, I have a database that is being set up for merge replication (Sql 2005), but there is one table that I only want the schema replicating, not the data - I never want the data to be replicated in either direction. I can see from sp_addmergearticle that you can do something like this for sp's or functions but is it possible to do this for tables Regards Graham I'd just script out the object to a file ...Show All

• nils_gate Creating a generic package to import a variable number of columns

  Hi, We are building an application with a database that contains Jobs. These Jobs have properties like Name, Code etc. and some custom properties, definable by the application admin. For bulk import of Jobs, we want to allow the import of an Excel sheet with the columns Name, Code and a variable amount of columns. If the header names of these columns in the Excel sheet match the name of a custom property in the system we want t ...Show All

• Sudip Guha901 Installing the SQL server 2005 beta tools problem

  Hi everyone,  I do not have any issues with the installation of the server itself, or reporting services etc... but im having trouble installing the tools like the management studio, etc... I get an error syaing tat I need to do this from the add/remove programs, but its not there. Its like it thinks that its installed but its not... Any ideas would be gratly appreciated Kramish Thanks for the reply. I ...Show All

• Syed Zishan Kalam "Dynamic" relationship between one table and many other tables

  Hello all.  I'm hoping someone can help me with this problem. I have a lot of experience with sql server and as the years have progressed, I have gotten much picker about my relational design. I enforce referential integrity whenever possible.  However, I'm running into a pattern in my current project that seems to defy referential integrity, or at the least, cause me to have to write a lot of extra code to allow sql server to enforce ...Show All