Hope someone can help with something so silly and that I feel quite ashamed
about asking, I am just doing some simple percentage calcualtions which I
have done in sql before without any problems, my query simplified is as
follows

Wonder if someone can help me I have written a very very basic sql (NOT IN)
Statment which was returning results fine but is not longer.  The table
sructure is as follows
Table A

I added a field to the middle of an existing query.  Another query that
referenced the changed query had data in the wrong columns.
For example, the original query had
  TaskID, division, CostID, Amount

I need to query between todays date +14.  Any suggestions on code.  Thanks.

How do you write a sql statement to update a column to be of <null>?
What is the syntax?
If have tried "null"   and    \0
thanks

I found a bug about SQL Query Analysis, if u write a sql statement like this:
SELECT Tmptable.col1
table.col2
FROM TEMPDB..[Table] AS Tmptable

Is it possible to execute two stored procedures and create one table based on
the data in both of the SPs?  If so, can someone explain how?
Thanks

I've got something, but I can't get all of my columns shown. I've got a
table with a few columns and in one columns there are records with duplicate
values, so I use a distinct to get all the duplicates out of the result set,
but this only works for 1 column, I also want to show ...