Viewing 15 posts - 1,786 through 1,800 (of 5,502 total)
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...
March 7, 2011 at 1:00 pm
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?? 😛
March 7, 2011 at 12:54 pm
SQLkiwi (3/7/2011)
Stefan Krzywicki (3/7/2011)
Just send him money! If he gets enough he may feel guilty and decide he has to write a book.
An excellent suggestion. 🙂
I'm not going to flood...
March 7, 2011 at 12:39 pm
You could either use a job to run every 5min or a sproc with WAITFOR DELAY.
March 7, 2011 at 10:06 am
duplicate post. no replies please.
discussion already started here
March 7, 2011 at 8:55 am
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...
March 7, 2011 at 3:39 am
Did you try to google it?
I'm sure there are many solutions out there.
March 7, 2011 at 3:36 am
Duplicate post. No replies please.
Original post can be found here
March 7, 2011 at 3:33 am
Duplicate post. No replies please.
Original post can be found here
March 7, 2011 at 3:33 am
israel17_popeye (3/6/2011)
in the stored procedure you can see the ledger can you modife it if you want to! thank...
March 6, 2011 at 9:02 am
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...
March 6, 2011 at 5:29 am
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...
March 6, 2011 at 1:57 am
The best article I came across so far: http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
March 6, 2011 at 1:52 am
Please help us help you by providing ready to use test data, including table def and sample data (especially if your request is "urgent"...). For the best way on how...
March 6, 2011 at 1:48 am
SQLkiwi (3/4/2011)
Ok, so the first part of my parallelism article went out a couple of days earlier than I expected :blush:Link: http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
What a fantastic article!!! GREAT job Paul! Thank you...
March 5, 2011 at 4:01 am
Viewing 15 posts - 1,786 through 1,800 (of 5,502 total)