Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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."...

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...

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...

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...

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...

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...