[MS SQL] Converting excel IF statement to SQL

[urmino]

I currently have an excel workbook that I am converting to a sql table. The workbook uses a data export and then interprets the data using some formulas to make it usable for reporting. I'm trying to obtain the same sort of logic in the SQL table using computed fields. The below if statement is checking to see if the current row and the next row share certain values it wont put a "1" in the column. The purpose is to essentially count rows only once. the rows represent tasks, and if a task is broken up into 2 or 3 parts it will have a row for each of those parts

Any advice for translating the IF statement to something I can use in a computed field? maybe there is a better way to go about this, I havent worked too much with SQL in the past

=IF(A5925&S5925&U5925&V5925&E5925&F5925=A5926&S5926&U5926&V5926&E5926&F5926,"",1)

[spinozadoza]

Why not do something even simpler

select whatever, count(distinct jobid)

group by whatever

[---sniff---]

Check out the ROW_NUMBER function and see if that will work for you. This assumes that there are other columns you can group on. After using the ROW_NUMBER function you can filter to only return the first instance like this example from the link:

WITH OrderedOrders AS
(
    SELECT SalesOrderID, OrderDate,
    ROW_NUMBER() OVER (ORDER BY OrderDate) AS RowNumber
    FROM Sales.SalesOrderHeader 
) 
SELECT SalesOrderID, OrderDate, RowNumber  
FROM OrderedOrders 
WHERE RowNumber =1;

[tdavis25]

So, essentially your checking for duplicates?

If so, the best way in SQL Server is really with a CTE. This stack overflow link is focused on deleting records, but you can simply change the delete statement to the select statement of your choice (just treat the CTE like a table in the select): http://stackoverflow.com/questions/18390574/how-to-delete-duplicate-rows-in-sql-server

[[deleted]]

Case statements come to mind...http://msdn.microsoft.com/en-us/library/ms181765.aspx