Try using case statements instead? ... CASE WHEN Q.QueueId= 'Pass Validation' THEN 1 ELSE 0 END AS 'PassedVerifier', CASE WHEN A.fundingMethodId = 'Cash' and Q.QueueId= 'Pass Validation' THEN 1 ELSE 0 END AS 'CashFunded', ...

ThanksPmar, however, I have used "Rollup" in the SP itself thus the calculation. The result is table[1]. However table[0] counts the transcation based on a different criteria. I got all the information I need from the DB, however it can not be done in single query. All I need is to display the dat from the dataset. Skan If you knew it would not compile why didn't you tell me?!?!?!

A System.Data.SqlClient.SqlException has an Errors array which contains the specific error(s). I search it for 2601 (unique index violation) or 2627 (primary key violation), and if present I wrap it in a custom exception. You can take a look at my DatabaseAccessor article which contains an enum of the code I support.

You are totally right and that's what I thought was happening but was not sure how to validate a "Void" method since nothing is ever returned. What is the best practice and how would you re-write this code to evaluate if all values have been assigned? Skan If you knew it would not compile why didn't you tell me?!?!?!

Thanks for your response. I figured it out, using the code below. UPDATE dbo.EmpWorkHours SET Emp_Timeout = getdate() where RecordNum = (SELECT TOP 1 RecordNum FROM dbo.EmpWorkHours WHERE FK_Emp_Login_ID = 'MDoe74' and Emp_Timeout IS NULL ORDER BY RecordNum DESC ) What was wrong with it you may ask? Well, I was selecting the Emp_timeout field which was null. I was then telling to update a record where getdate() equals the value in the Emp_Timeout field. That would never happen because at the time of the query Emp_timeout field is NULL thus it will never equal getdate(). Hope this helps. Skan If you knew it would not compile why didn't you tell me?!?!?!

Mark Nischalke wrote: It's a common homework assignment. Which is what this would seem to be. Deja View - the feeling that you've seen this post before.

Dude you are a Genius. I modified the script a but and it worked like a baby. Thnks dude.. I owe u a beer. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[sp_MS_IssuesReport_Num2](@PeriodName varchar(50), @BeginningDate datetime, @EndDate datetime)AS BEGIN SELECT dbo.RPT_GetPeriod(@PeriodName, A.PeriodDate) AS Period, SUM(A.IssueReceived) AS IssuesReceived, SUM(A.IssueClosed) AS IssuesClosed FROM( SELECT CreateDate AS PeriodDate, 1 AS IssueReceived, 0 AS IssueClosed FROM Ms_threads WHERE CreateDate BETWEEN @BeginningDate and @EndDate UNION ALL SELECT StatusDate AS PeriodDate, 0 AS IssueReceived, dbo.RPT_IsInquiryCompleted(CurrentStatusID) AS IssueClosed FROM Ms_threads WHERE StatusDate BETWEEN @BeginningDate and @EndDate ) A GROUP BY dbo.RPT_GetPeriod(@PeriodName, A.PeriodDate) -- Added the date floor function. ORDER BY dbo.RPT_GetPeriod(@PeriodName, A.PeriodDate) end Thank Code Project....This deserves a 10 not a 5...hehehehe!! Skan If you knew it would not compile why didn't you tell me?!?!?!

DISTINCT used as an argument of a SELECT clause does not eliminate rows due to a single duplicate column. It eliminates rows when all columns are equivalent. The whole row would have to be the same for it to begin its removal process. DISTINCT can be used as an argument in an aggregate like AVG(DISTINCT price). Here it will eliminate duplicate prices before calculating the average. I think you need to re-examine how you have coded your store procedure. It seems a little over done. Not sure what your desired end result is but, I would think a much simpler LEFT JOIN would handle most of the work.

dan neely wrote: Tell us who you're building the site for so we can all make sure to avoid it. :laugh::laugh::laugh: Laughing at myself for not immediately recognizing that! led mike

This one line of code solved it all. Thanks guys. return Decimal.Round(months/12M,1); Skan If you knew it would not compile why didn't you tell me?!?!?!

Your guess was right...................it is a microsoft press book and I have to admit that I had found several error in there ASP.net book too but I di not know C# enough to identify the errors. Wow...............I guess there are a lot of people who use these book just to find out how erroneous they are. Skan If you knew it would not compile why didn't you tell me?!?!?!

select userid,ipaddress, count(1) as[number of unique ipaddress] from AU_commontable where result=1 and actiontaken='firsttimesignon' group by userid,ipaddress having count(1)>1

why you want to put this condition IF NOT GOSSearchRS.BOF AND GOSSearchRS.EOF THEN This condition reads if recordset is not BOF and recordset is EOF then do the execution. If recordset is already EOF the from where u will get the new record. try this IF NOT GOSSearchRS.EOF THEN cheers, Akhilesh Yadav

Skanless wrote: 1. If you are new to a database, is there a way that you can quickly find out relationships between the tables? There are diagrams that you can create to see the relationship between the tables. Skanless wrote: 2. I need to retrieve information on all the tables in a database to find out which tables have a rowcount of more than 50,000 records then delete some record which thus reducing the table to 50,000 rows so as to make space. Is there a way to do that? and if so, what is the syntax to obtain this? You can use the sysobjects table that can return the tables existing in your database, then query each table to check how many records it has and delete the ones over 50,000. I can't remember the correct syntax, I'm sure a bit of googling will do. Skanless wrote: 3. How can I cascade constraints when deleting records from a specific table? You need to specify the necessary constraints to the tables before deleting the record, and it will automatically trigger the deletion of child records. "A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin Edbert Sydney, Australia

Never Mind, I got it working. What I did was I ran the "print" script, pulled copied the result and rn it in Quer Analzer. It ran just fine and created all my Articles. PS: I could not believe I was such a dork. But then again no where tells you that you need to run one script to create another. Thanks guys. OBTW: It would be nice if someone can explain wh I can not add a variable name to a stored procedure dnamically. Greg Coding makes the world go round!!!

When the application is run first time on the user machine, which is on a remote location, the application asks to download the activeX controls. This will initiate the process of installing the cab file related to a particular control to the user machine. All the information related to the control is downloaded in the form of cab file, which is used later to access the control. The OBJECT tag in HTML file identifies the ActiveX control. If the control has been stored in a .cab file, OBJECT must include a CODEBASE attribute that specifies the URL for this .cab file. The following sample HTML file demonstrates how the OBJECT and CODEBASE attribute are used. Example: Microsoft Internet Explorer 4.0 or later versions handle the OBJECT and the CODEBASE attribute in the following manner for accessing controls stored in cabinet files. • Parses the OBJECT and searches for the CODEBASE attribute. • Locates the .cab file identified by the CODEBASE attribute. • Expands the files found in the .cab file. • Copies the expanded files to the user's computer (the default directory is \windows\occache). • Registers the objects and/or files that require registration. • Calls the Component Object Model (COM) CoCreateInstance function to create an instance of the specified object. For eample Following is a Textbox Object created using the tags in the XYZ application. The Classid, which is the universal id, which specifies the physical location of the library, is used to refer the date Object in to the ASP pages. This date TextBox object is having a standard input format and all the attributes are set using the tag. Example ....... But please note, here the story does not end. Because in your case, we need to find out which Activex control is creating problem. But definitely above things can be good start point for you. Amit

Put tempdb on a seperate diskdrive if possible and this will also improve performance. Look where you want to go not where you don't want to crash. Bikers Bible

I restarted and before I knew it was up and running fine with service and everything. Thanks PS: I was using XP. Greg Coding makes the world go round!!!

Thanks for all your help guys. I restarted and before I know it..........Walla.........my MSSQL server was up and running. I am really glad to a part of this forum and really grateful for you guys. Thanks. Greg Coding makes the world go round!!!