mister.magoo (10/9/2015)

---

Lynn Pettis (10/9/2015)

---

I tried posting the hard way to do it but can't from here. So, replace the call to dbo.GetInvoiceIDFromBillID with the following to see what I...

Pitcher

This might seem weird, but have you tried to recreate the table?

I kept getting an error which seemed to be replicating your problem saying that the column couldn't be indexed...

I couldn't find the explanation on why does the TRY...CATCH would reset the value of @@ROWCOUNT.

From BOL

Statements such as USE, SET <option>, DEALLOCATE CURSOR, CLOSE CURSOR, BEGIN TRANSACTION or COMMIT...

The ORDER BY clause is not valid in views, inline functions, derived tables, and subqueries, unless either the TOP or OFFSET and FETCH clauses are also specified. It hasn't been...

I'm not sure if this helps.

I sure had fun replicating the SOUNDEX function which I then changed it into the DIFFERENCE function, all by keeping it as an inline table-valued...

I guess you could at least post your sample data in a consumable format (CREATE TABLE & INSERT statements) if you want some coded help.

If not, I can tell you...

I have no idea on the rules to get to the output. Where does the FormOrder comes from? Are the 2 input tables related? or are they just 2 set...

And by the way, the CREATE VIEW must be the first statement in a query batch. The IF and any other things that you might want to include must be...

Why are you using a BEGIN with your view? Views are a single statement and they can't include a BEGIN...END block.

You've got basically the same answer twice in different threads. Have you tried it?

This was the original thread: http://www.sqlservercentral.com/Forums/Topic1726364-2799-1.aspx

I just wanted to add, as a suggestion, that you should use table alias in your queries. It will make your queries shorter and easier to identify column names. And...

You could use the Quirky Update to get the desired result. If you don't want to mess with it, another option would be to use a well written cursor (not...

If you're going to work with timezones, you need to use the datetimeoffset data type. This means that you can't rely on GETDATE() because you won't be giving enough information.

That...

After reviewing the code, I found that you are referring new_projecttasksBase which isn't included in the query. If you're referencing it, you need to add it to the JOINS.