After some reformatting I figured the both queries used in the UNION statement are pretty much identical except for the join to BatchKeg and Keg and the ch.FlexTank = 'true'/'false'...

Please provide table def and sample data of the source table as described in the first article refernced in my signature. Also, please post your expected result based on your...

You could use

WHERE yourColumn LIKE 'A%' OR yourColumn LIKE 'B%' OR yourColumn LIKE 'C%'

or just create a view with an additional column

CASE WHEN yourColumn LIKE 'A%' OR yourColumn...

Since you obviously put it back where it was, everything's fine, Ki 😀

At a second glance: did you really COPY the 100-EURO bill??? Don't you know that's illegal?? 😛

SQLkiwi (3/7/2011)

---

An excellent suggestion. 🙂

I'm not going to flood...

You could either use a job to run every 5min or a sproc with WAITFOR DELAY.

duplicate post. no replies please.

discussion already started here

One reason you might not have an answer by now is the missing information.

Please provide table def and ready to sample data as described in the first link in my...

Did you try to google it?

I'm sure there are many solutions out there.

Duplicate post. No replies please.

Original post can be found here

Duplicate post. No replies please.

Original post can be found here

israel17_popeye (3/6/2011)

---

thank you sir here's my new attachment the whole mdf file

in the stored procedure you can see the ledger can you modife it if you want to! thank...

Table DDL and sample data in a ready to use format are still missing. Please reread the article I pointed you at.

As a side note: there are seveal people around...

What you could do is to search for the character string to be replaced automatically so at least you'll know what definitions you have to tackle. Search the script section...

The best article I came across so far: http://www.sqlservercentral.com/articles/Temporary+Tables/66720/