same query but skip - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

same query but skip

Author

Topic

jackhorror
Starting Member

1 Post

Posted - 2011-05-30 : 06:36:13

Hello everyone im new on this forum.

and i have question

i have .sql file with this query

i run this every week one time.

i control the output with vb

SELECT * FROM customers t1 INNER JOIN custhist t2 ON t1.id = t2.customer_id WHERE t1.custnr_id = '00001'",

to

SELECT * FROM customers t1 INNER JOIN custhist t2 ON t1.id = t2.customer_id WHERE t1.custnr_id = '08541'",

what i wont is that the system skips the specific custnr_id time if it flagged.

is this possible.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2011-05-30 : 09:30:33

How is it flagged ? Is it another column ? Could you present the DDL of the table - and we can define a SQL statement.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources