Viewing 15 posts - 1,891 through 1,905 (of 2,469 total)
Rolus - have you tried playing around with the single quotes and double quotes in your t-sql ?! I don't have the means to test this but have you tried:
SELECT...
July 10, 2005 at 9:12 am
1) Why are you creating your table 'fquery' within the procedure - do you actually want to use a temporary table ?!
2) What data type is your ph_date ?
3) Have...
July 10, 2005 at 8:36 am
Here's my 2 Cs...if the applications are all being developed in parallel, it's great to have one database...but if you have different db versions...development, test, production etc.. and within those...
July 8, 2005 at 10:03 pm
oh no Mike - you fell for it! Remi's got "friends" that know all about this and will be sending Lenny TheLegBreaker to explain to you the full significance of...
July 8, 2005 at 9:53 pm
I was teasing....don't need icons to pick up nuances...only thing I have work on is how to keep off "ssc.com"....
July 8, 2005 at 2:38 pm
<:-)
"gonna have to have a litte chat" sounded too threatening....!
July 8, 2005 at 2:32 pm
losing your vision ?!
July 8, 2005 at 2:28 pm
quelle difference ?!?!
July 8, 2005 at 2:23 pm
ken - just to jump in and add my 2 cents - Remi's solution is the "only way to go"!!! There's no comparison at all....but if you still want to...
July 8, 2005 at 2:19 pm
Remi - my "one" against your "hundreds".....such an unfair comparison!!!
ps:I'm an absolutely fair person...so I'll grant you the fact that you DO have at least 30-40 posts more than I...
July 8, 2005 at 2:06 pm
You're right Surya - I have no idea why I've been saying scc when it is actually ssc...thanks for pointing that out!
July 8, 2005 at 1:55 pm
or this ?!?!
select P.Id, P.Product, D.ItemNo
from Product P
left outer join
(select Id, min(ItemNo) as ItemNo
from Details
group by Id) D
on P.id = D.id
order by P.Id, P.Product
July 8, 2005 at 1:18 pm
"when your boss is being a total ass you can not complain to your friends"...
yes you can Mike - count us amongst your friends - just let us know when...
July 8, 2005 at 12:45 pm
Mike - you LIVE in a permanent vacation spot - so stop complaining...as for heading to the mountains in October - brrrr!!!!
Let's you and I (as scc.com is our witness)...
July 8, 2005 at 12:27 pm
Brian - I believe he was talking about the one that I sent....I've included the URL as the link wasn't working...(don't know why!!!)
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=196330
July 8, 2005 at 10:50 am
Viewing 15 posts - 1,891 through 1,905 (of 2,469 total)