Search results for query: *

I have a sp that I would like to convert into a view. Any Ideas on this? Thanks MikeD TP_ProcLU ( @AllCovered char(1), @PayorPlankey int ) AS If @AllCovered is null OR upper(@AllCovered)='T' OR @PayorPlankey is null Begin select p.IntProcCode,p.CPTCode,p.Descr,p.Prockey from bil_procedures...

I have designed a process that has 4 stages that would run overnight on a server. There are about 4k new transactions every month added to about 256k current transactions. Stage 1 -Check for any unyet processed transactions. Sort/Update them into 3 different categories...

Working on a large Report that has 76 queries of demographics on a quartly basis. I don't want to requery a quarter if it is completed so we only recalculate the current quarter and write it to a table that has these columns, Year, Quarter1,Quarter2,Quarter3,Quarter4,ID I need help with a...

We have a rather lengthly quartly report that requires 85 queries aggregating demographics. I built a dynaminic query where the variables change for the quarter but I can't get the assignment @QtrCnt to work. Any Ideas?? Thanks in advance. This code is shortened to focus on the problem...

SQL 2000 works fine, SLQ7 doesn't recognize this format. Any body recognize the problem for SQL7??? Create function mmddccyy(@indate datetime) Returns Varchar(8) AS Begin --strip out the seperator ... End Thanks MikeD

I'm using this select statement, how do I account for nulls? select SUM(CASE c.Gender WHEN 'Male' THEN 1 ELSE 0 END) AS Male, SUM(CASE c.Gender WHEN 'Female' THEN 1 ELSE 0 END) AS Female, SUM(CASE c.Gender WHEN 'Unknown' THEN 1 ELSE 0 END) AS Unknown, SUM(CASE c.Gender WHEN null THEN 1 ELSE 0...

We would like to have two DB's that connected at runtime. One for the Users and the other for Our System Developers. These SD tables are large and heavly indexed since they hold relations to our document management system that the enduser uses. Is ther a real big hit when attaching DBs??? Has...

Is this the proper placement for the Begin/Commit/Rollback for following Insert code snip which also does an update to the same table. In the Update trigger, I have the same Begin/Commit Structure wrapped around the 2 updates it does. I'm concerned about this second Begin/Commit Block in the...

I'm trying to get the SQL Server version incorporated into some SP and I need to know what the exact use of xp_msver. I'm looking to evaluate 8.xx or 7.xx TIA Mike Davis

I'm working on a Attendance Management Solution for our clients. I record values for Sunday - Saturday in varchar(7) format. If a class was on Mon and Wed at 10 am, it would requite 2 records CLASS1,01/01/1900 10:00:AM, 'FTFFFFF' CLASS1,01/01/1900 10:00:AM, 'FFFTFFF' I do attendance for each...

Trying to build a rather large SQL statement dynamically. How do you embedd the data with single quotes whithin a string. Thanks Here is a snip.. Declare @Sql varchar(100) Declare @Monday char(1) Set @Monday='T' Set @SQL='Declare Csr as Cursor For Select * from ABC' ***@Monday needs quotes Set...

We have to deploy a new 3rd party program build to 300 machines. Is there a way to do this without logging on as System Adm. The program is installed already and is can be updated from the server? Thanks for any help on this issue Mike Davis

I have a report that uses a stored procedure. One of the parameters is a datetime. I really only need a date, but there is no way to change the parameter field in crystal since it is grayed out. Any suggestions?? Thanks

I need to pass a TableName to a SP so that I can build a cursor and traverse the given table. MySp(@TblName varchar(30)) AS Declare myCsr Cusor for Select * from @TblName .... Can this be done? Thanks In advance MikeD

I've created a FileDSN using a MS SQL Server. When I point to it in CR it won't use the correct driver. Crystal V8 thinks a File DSN is always FoxPro Driver Crystal V8.5 thinks it is an Excel Driver Any Workaround??? Thanks MikeD

I'm trying to count 'Page x of Y' in a Group. Most groups have one page, several have 2 to 3. I have inserted a running total(count) on the group that is working ok. I need the Total pages for the group to calculate. This is in a monthly statement where multiple pages are common for a client...

I tried creating a Report (V8x) that uses a File DSN and received a message that the Fox-Pro Driver couldn't read the File. No Wonder: I've created a FileDSN that uses a SQL Server driver. CR seems to be losing its marbles when it comes to linking a ODBC FileDSN. If I create System or User...

Have a simple request to do a mail list. Join the Client with the Client Address Table No Problemo. Almost. What if the are more than one address for a client? Say that the Client address table stores the addresses and has a change_date field. I would want the top/bottom record sorted by...

I'm trying to make some company wide programming standards regarding CR and the way we link to db/tables. Our target markets have an 80/20 mix of MSsql and Oracle back ends respectively. I'm leaning towards a ODBC file DSN that is distributed with our Installation Package. Can anybody...

I'm getting the above error using the Native SQL Driver in CR v8 each and every time I have memo fields that have nulls in this report. If I remove the fields every thing is fine(if you can call it that) So I switched to an ODBC driver and what do you know? The report runs each and every time...