Recent content by NWChowd

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