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

Just to be sure, does this mean anyone hired in February isn't eligible for benefits until 4/1?

😎

Just a guess, but is this what you are looking for?

SELECT TOP (5)

ShipCountry,

SUM (OrderTotal)as [Total Order],

SUM (OrderTotalExVat) as...

This is what you are probably trying to do:

declare @SQLUpdateCmd varchar(max);

set @SQLUpdateCmd = 'UPDATE EDW_STAGE..tbComm_3Months_Ago SET ' +

...

The following is code from one of our jobs that looks for a name change and send an email if appropriate. Look at the logic, and see if you...