General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2000
It's a bracket thing, try this:
(0>(SELECT COUNT(*) FROM pos_s_invoice WHERE (doc_no IS NOT NULL and pos_is <> 899)GROUP BY doc_no HAVING (COUNT(*) > 1)))
>Hi Jon,
>
>thanks for you reply. I tried the code but i still have the same problem. In fact i don't see any difference between your code and mine except for the table and field names. Where are you inserting this code ?
>Is it when you do a right click on your table, than choose design table,right click check constrains and then new ?
>
>thnx
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only