Yes and after I removed the commented line there WHERE clause worked fine....

Evil Kraig F (1/25/2012)

---

fahey.jonathan (1/25/2012)

---

SQLKnowItAll (1/25/2012)

---

Where is this query being executed from; i.e. a text file, SSMS, 3rd...

Thanks a lot for the help... I find it so weird too and I am sure I ran the query correctly as we tried several times and same query acts...

CREATE TABLE [dbo].[PEOPLE_PROJECT](

[BUSINESS_UNIT] [char](5) NOT NULL,

[PROJECT_NAME] [char](50) NOT NULL,

[PID] [decimal](10, 0) NOT NULL,

[COMPANY_ID] [char](10) NOT NULL,

[START_DT] [DATETIME] NULL,

[END_DT] [DATETIME] NULL

) ON [PRIMARY]

SQLKnowItAll (1/25/2012)

---

Can you please post the DDL for the...

Thank you.. Sorry Sql Server Management Studio... One query that had issue was:

UPDATE PEOPLE_PROJECT

SET END_DT = NULL

--SELECT * FROM PEOPLE_PROJECT

WHERE PID = 56408

AND END_DT >= '2011-10-12'

It updated all the...

in query analyzer not in any application...

The database is actually sql 2000 but using SQL 2008 R2 visual studio in the laptop.

I think we found the issue but do not know why it is happening...

The query had a line that was commented out with ('--') and very inconsistently the line after...

Wow Lowell... this is awesome... your comments on every line has made this code so clear. Thanks a bunch!

So Lowell I should make the user db_ddladmin and then create DDL triggers to stop users from altering, dropping objects?

Thanks a lot Lowell.

I tried doing this

sp_addrole 'db_alterview', 'dbo'

--Add member to role

sp_addrolemember 'db_alterview', 'testUser'

--grant permission to create view

GRANT CREATE VIEW TO [db_alterview];

GRANT SELECT ON SCHEMA::[dbo] TO [db_alterview];

I was able to select from table...

Comments I added for the forum...

This is the test server where we got the issue...

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005...

Sorry...

SELECT * FROM PROJECT

WHERE PID = '3850' --CHAR(10)

AND INDID = 8565 --DECIMAL(10, 0)

AND NAME LIKE 'Contract%' --CHAR(100)

The query above should have pulled Name starting with Contract for those PID and...

Hi GSquared,

Thanks for your help on this one. I wanted to check with you onething.. should I create function or SP for this... the data will be updated in off-hours.

Thanks,

Laura

GSquared thanks a lot... this worked. Awesome.