Viewing 15 posts - 451 through 465 (of 621 total)
Ron (7/18/2008)
select i.itemname from item i where i.item_id = 12 and p.pagename like '10_001%'
Ron, the first of your four queries work fine with the data you provided, but the fourth...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 18, 2008 at 9:12 am
Ok, I think I get it. Its just saying where b.id = any part of a.id, starting at the beginning of a.id. So, I am trying to figure...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 18, 2008 at 8:41 am
Chris Morris (7/18/2008)
ON b.keyid LIKE a.keyid + '%'
Chris, that looks like a nifty little trick, what exactly is the '%' doing?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 18, 2008 at 8:18 am
[/quote]Kipp, you're still stuck on this? Based on the mock up that I did, what results do you expect to get?[/quote]
Yesterday he said he won't be back until...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 17, 2008 at 6:44 pm
Ok, not really what I meant. Please take some time to read Jeff's article on how to post a question and data in order to facilitate someone's helping you.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 17, 2008 at 10:47 am
Kipp, if table a.id *always* has periods, you could try this:
SELECT
a.*
FROM TableA a LEFT OUTER JOIN
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 17, 2008 at 6:43 am
GilaMonster (7/15/2008)
The concatenation problem I'll leave for someone else.
Concatanation should be easy, if you provide table structure and sample data.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 16, 2008 at 12:59 pm
If it does not matter which one you see, then why not just exclude ProgramID from the results altogether?
SELECT DISTINCT
a.Term, b.shortname
FROM...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 16, 2008 at 12:42 pm
Well it wasn't really missing, but rather was turned into the yellow face when I pasted the code in the block. I did not know how to get rid...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 14, 2008 at 8:12 pm
John, I might be over simplifying this, but it seems to me a function would work nicely here. You should be able to change your table names, and make...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 14, 2008 at 2:06 pm
"Everyone probably knows that anyway... hope I don't insult anyone".
Jeff, as long as I am around, you needn't worry that everyone already knows anything.
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 5, 2008 at 1:30 pm
Jeff, same thing with DATALENGTH. Its not a big deal, just one of those things I don't get. I don't know if it matters, but when I copied...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
April 14, 2008 at 7:52 am
Thanks mrpolecat. That does seem much simpler. I can never think of what seems like the obvious, simple solution.
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 25, 2008 at 3:47 am
Jeff, I have found that information helpful to a format file newbie is hard to come by. Maybe you know of an article that explains it a bit better...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 14, 2008 at 12:19 pm
Richard Lesh (12/7/2005)
I can do it thru Enterprise Manager, but what is the proper SQL DDL statement to change it?
If you can do it through EM, instead of...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 25, 2008 at 7:12 pm
Viewing 15 posts - 451 through 465 (of 621 total)