Viewing 15 posts - 4,816 through 4,830 (of 5,590 total)
Try this. Also, see the first link in my signature.
-- first, make a table and populate it with some sample data.
-- when you do this, all of the volunteers on...
February 4, 2010 at 9:29 am
Ruprecht (2/3/2010)
I'm working with a third-party SQL database that uses a single varchar column to store multiple values separated by a semicolon. For instance, I have a column...
February 3, 2010 at 8:37 pm
lmu92 (2/2/2010)
WayneS (2/2/2010)
And yet, if you look at the last line of the OPs original post, this is exactly what he wants.... for now.
So, do you think having a persisted...
February 2, 2010 at 12:22 pm
And yet, if you look at the last line of the OPs original post, this is exactly what he wants.... for now.
February 2, 2010 at 11:54 am
whouston (2/2/2010)
February 2, 2010 at 11:52 am
Paul White (2/2/2010)
GilaMonster (2/2/2010)
http://www.sqlservercentral.com/Forums/Topic856902-145-1.aspx#bm857286
http://www.sqlservercentral.com/Forums/Topic475163-146-1.aspx#bm856344
http://www.sqlservercentral.com/Forums/Topic855771-360-1.aspx#bm855992
Am I...
February 2, 2010 at 11:13 am
Angela S. (2/2/2010)
February 2, 2010 at 10:55 am
san43 (2/2/2010)
February 2, 2010 at 9:29 am
Jeff Moden (2/1/2010)
Another good idea. Thanks Wayne. Just curious though... have you ever used it that way?
No, but I read about it and realized it would work pretty...
February 2, 2010 at 9:26 am
Angela, what language is this code even written in? I don't recognize it. And while you might be requiring a reason for why a field was changed for audit purposes,...
February 2, 2010 at 9:22 am
BrainDonor (2/2/2010)
Roy Ernest (2/2/2010)
BrainDonor (2/2/2010)
This thread is going to get interesting.
I've been waiting for weeks for this one to show their head over the parapet.
BrainDonor.
By seeing your last post...
February 2, 2010 at 9:18 am
sql_ques (2/2/2010)
Here is a query,
SELECT LASTNAME FROM CPM.dbo.T_CANADIAN
WHERE '678567Z' BETWEEN '673001P' AND '679000P'
It should not display any result as the where value numerials fall in between '673001P' AND...
February 2, 2010 at 9:14 am
Roy Ernest (2/2/2010)
Would this work in all cases? Why dont you try to use the functions that we re hinted to you by others?
Those were hints? Heck, IMHO, those were...
February 2, 2010 at 9:09 am
paucann (2/2/2010)
That field holds many values depending on table joins.
Paul, are you saying that sometimes it holds a date, and other times something else? Jeez, this is a horrible design!
February 2, 2010 at 8:32 am
sql_ques (2/2/2010)
Please tell me how to do it.
Look in BOL at the LEFT, RIGHT and SUBSTRING functions.
It looks like the root issue here is a single data field with multiple...
February 2, 2010 at 8:15 am
Viewing 15 posts - 4,816 through 4,830 (of 5,590 total)