Viewing 15 posts - 556 through 570 (of 3,221 total)
Lynn Pettis (3/26/2012)
Evil Kraig F (3/26/2012)
GilaMonster (3/23/2012)
SQLRNNR (3/23/2012)
GilaMonster (3/23/2012)
Lynn Pettis (3/23/2012)
Wants a primary key on fname and lname.
You say that like it should be obvious it's a bad idea. I...
March 26, 2012 at 2:09 pm
You did say previously:
Thanks for your reply....However, I have to create a new column based on this calculation and use that in a report. Your code is correct but I...
March 26, 2012 at 8:58 am
For those interested further may I suggest reading:
http://sqlblog.com/blogs/kalen_delaney/archive/2007/11/21/cloning-in-sql-server-2005.aspx
March 24, 2012 at 5:55 am
GSquared (3/23/2012)
L' Eomot Inversé (3/23/2012)
Brandie Tarvin (3/23/2012)
Gianluca Sartori (3/23/2012)
The Dixie Flatline (3/23/2012)
What is "google"?The working counterpart of Bing. 😛
What is Bing? :hehe:
Mr Crosby's christian name. 🙂
So, since Google is the...
March 23, 2012 at 12:27 pm
@min-2 is simply functioning as a "place holder" or intermediate value. You could alter the previous code to
SET @min-2 = CAST(SUBSTRING(@H1,CHARINDEX(':',@H1)+1,DATALENGTH(@H1))AS INT)+CAST(SUBSTRING(@H2,CHARINDEX(':',@H2)+1,DATALENGTH(@H2))AS INT)
INSERT INTO NewColumn -- Inserted new...
March 23, 2012 at 12:00 pm
Here is one way of doing what you want, but I must say it is not very efficient, but for the life of me I can not come up with...
March 23, 2012 at 9:00 am
Well you have stated your requirement, as strange as it seems, but what is your question ? What assistance are you seeking ?
Looking for a better method to store...
March 23, 2012 at 6:55 am
Hugo Kornelis
When I submit a question (and I have done so multiple times already - 22 times, to be exact), I go through great lengths to prevent any errors...
March 22, 2012 at 5:02 am
L' Eomot Inversé (3/20/2012)
Gazareth (3/20/2012)
sknox (3/20/2012)
Koen Verbeeck (3/20/2012)
When a view is created, information about the view is stored in the following catalog views: sys.views, sys.columns, and...
March 20, 2012 at 8:48 pm
Not fully aware of your situation, but have you considered creating a view(s) on those table(s), a view that does NOT contain the credit card column. That way you...
March 19, 2012 at 4:32 pm
Best quick and be no means complete explanation .. but think of a data base as say a book with an index. If you want to find something in...
March 17, 2012 at 1:21 pm
Jack Corbett (3/16/2012)
Brandie Tarvin (3/16/2012)
Book 2 of Latchkeys, The Ugly Little Bloke by Robert Greenberger is out. Links are below.
Preview the book at...
March 16, 2012 at 2:10 pm
bitbucket-25253 (3/14/2012)
March 14, 2012 at 12:59 pm
Now this is going to be slow and NOT the best solution, as others have stated the lenght of the data is too long. This might work for you.
DECLARE...
March 14, 2012 at 12:25 pm
Viewing 15 posts - 556 through 570 (of 3,221 total)