dream coder (8/8/2008)

---

Thanks i saw that step, i would still like to know if u can use an "IF" in the WHERE clause of the SQL statement cause i dont...

Because nothing met the criteria specified in the WHERE clause??

I can't really answer this question as I have no data (tables, sample data, expected results) with which to test the...

Not sure, but would using a decimal (decimal(24,0)) instead of bigint help at all?

😎

Reformatted your code some so I could read it better, but really can't help you with the query as there really isn't enough information.

It would help if you provided the...

Check out this code and see if it provides what you the results you require. Also, when writing multiple table queries, you should use table aliases for all columns,...

This is another way to write the code above:

select @Records = count(*)...

This is what you are probably wanting to do:

DECLARE @Records INT

UPDATE STAGE..tbComm_3Months_Ago SET

Miss_Payment_Flag = CASE WHEN Missed_Instalment < 0.3333 THEN 1 ELSE 0 END

SET ...

Running 3rd party apps, we can't move to SQL Server 2008 for them until the vendors say they will support SQL Server 2008.

I will, however, look at moving our DW...

Although you may think you can't eliminate the cursors, I'd suggest that you look seriously at rewriting the process as a set-based solution. It may take time, but in...

You'd get a better answer if you posted your table ddl (create statements), sample data (in the form of inset statements that could be cut, pasted, and run in SSMS...

You may look at DENYing select access to the user through the SCHEMA's sys and INFORMATION_SCHEMA. If denied select access to those schemas they should theoretically not have access...

Using a cursor or while loop may not be the best answer. If you provide more details about what you are trying to accomplish, plus provide sample tables, sample...

Double posting your request isn't really going to get you help any faster. I am looking for an answer to your request for help, but it may be a...

With the exception of 1 company (2 if you include pre-existing conditions), I (and my family) have been eligible for benefits from date of hire (first deduction for benefits was...

I am thinking we need more information, tabble DDL (create statements), sample data (insert statements that can cut, paste, and run in SSMS), expected results based on the sample data,...