Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NWChowd

    Data Source Error

    andyoye, If you have the SSRSS database on a different server than the SSRS application, you might be having trouble with passing authentication information from the client to the SSRS application server to the database server. That was my issue, as we do not have Kerberos 5 on our network yet...
  2. NWChowd

    Data Source Error

    Hi, I am running SSRS 2000 on a Windows 2003 Server. I am having trouble running reports successfully on client machines. However, I am not having any trouble running the same reports on the Windows Server 2003 where SSRS 2000 is installed. I am using a Shared Data source with Windows NT...
  3. NWChowd

    Query Assistance

    Hi, I have a need to renumber or resequence the line numbers for each unique claim number. For background, one claim number many contain many line numbers. For each claim number, I need the sequence number to begin at 1 and then increment, until a new claim number is reached, at which point the...
  4. NWChowd

    Determining Data Types

    There are some alpha-numeric values, strictly numeric values, and strictly alpha values. ====================================== "I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside from the straight path of honesty and the convictions of my...
  5. NWChowd

    Determining Data Types

    Hi there, I have a situation in which I need to do one thing if the values of a field ("ServiceCode") fall within the range of 100-299, and do something else if the value is outside this range. The problem is that ServiceCode field has a datatype of char(6), and there are some non-numeric...
  6. NWChowd

    Same query returns differently ordered results

    Order by is not specified. I was under the assumption that physical order would be the same if a field was indexed. thanks for the clarification. ====================================== "I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside...
  7. NWChowd

    Same query returns differently ordered results

    Hi everyone, I'm looking for a clear explanation as to why some queries return result sets that are ordered differently each time the query is run. The result sets are the same, just the order is different. Thanks, NWChowd ====================================== "I wish that I may never...
  8. NWChowd

    Default Value in System Table?

    Hi George, Thanks for the comments. Regarding your confusion, the result I get for the ColumnDefaultValue is literally: "/****** Object: Default dbo.active Script Date: 3/1/2000 8:50:15 PM ******/ create default active as 1" In the case of this default, what I would like to have is the...
  9. NWChowd

    Default Value in System Table?

    In essence, I am trying to develop a rudimentary data dictionary. I would like the following information: Tables Table Description Primary Keys Foreign Keys Columns Indexes Data Types Allow Nulls Default Values Description I believe I...
  10. NWChowd

    Default Value in System Table?

    thanks. I am working on a vendor-developed database in which they used SQL Server Defaults for some columns. So when I use the INFORMATION_SCHEMA.COLUMNS view, I get (for example): /****** Object: Default dbo.active Script Date: 3/1/2000 8:50:15 PM ******/ create default active as 1...
  11. NWChowd

    Default Value in System Table?

    Hi There, I am looking for where the default value for columns is stored in the system tables. I can't find it anywhere, but probably just missed it. Thanks, NWChowd ====================================== "I wish that I may never think the smiles of the great and powerful a sufficient...
  12. NWChowd

    Problem moving location of master db data/log files

    Help! Using SQL Server 2000, I tried to move the master database from its default location to a data only drive, specifically, I used the MS help file located at: http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 Moving the master database 1. Change the path for the master data...
  13. NWChowd

    UNION Query: Error 8618

    you and me both, mr denny. I tried putting the replace command in the group by...still the same error. Back to the drawing board. ====================================== "I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside from the...
  14. NWChowd

    UNION Query: Error 8618

    so, I just noticed that the view seems to work if I change the following in the query: REPLACE(REPLACE(claimlin.claimno,'-', ''),'.','') AS 'ClaimNumber', ---- to LEFT(claimlin.claimno,2) + SUBSTRING(claimlin.claimno, 9,2) + SUBSTRING(claimlin.claimno, 12,2) + SUBSTRING(claimlin.claimno...
  15. NWChowd

    UNION Query: Error 8618

    Not that I am aware of. Is there anything in particular I should look for? ====================================== "I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside from the straight path of honesty and the convictions of my own mind."...
  16. NWChowd

    UNION Query: Error 8618

    Here's some info on field lengths: field datatype length claimlin.claimno char 20 claimlin.formcd char 1 claimlin.grpnum char 6 claimlin.membno char 15 claimlin.altclm char 30 claimlin.diagn1 char 6 claimlin.deneop char 3 claimlin.svccod char 6 claimlin.statcd char 1...
  17. NWChowd

    UNION Query: Error 8618

    Here's the GROUP BY clause: ----- GROUP BY claimlin.claimno,claimlin.formcd,claimlin.poscod,claimlin.grpnum,claimlin.membno,claimlin.altclm,claimlin.diagn1, claimlin.deneop,claimlin.svccod,claimlin.statcd, claimlin.poscod,claimlin.svcdat,claimlin.enddat,claimlin.pidate...
  18. NWChowd

    UNION Query: Error 8618

    I get the following error message when I try to use a view that contains 2 separate SELECT statements "UNION"ed together. Server: Msg 8618, Level 16, State 2, Line 1 Warning: The query processor could not produce a query plan from the optimizer because the total length of all the columns in the...
  19. NWChowd

    Read Only Database

    I was able to find the article regarding Read Only databases. http://www.sqlteam.com/item.asp?ItemID=127 Apparently, SQL Server will disable locking in the database, which may speed things up a bit. The caveat is that when the database is set to Read Only, statistics cannot be updated, DBCC...
  20. NWChowd

    Read Only Database

    I am wondering if anyone can tell me if setting a database will improve the performance of a database. I have a data warehouse which is only updated once a week. I've read a few articles that allude to improved performance by setting a database to read only. Thanks in advance. NWChowd...

Part and Inventory Search

Back
Top