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...
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
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"....
**ASCII stupid question, get a stupid ANSI !!!**
July 8, 2005 at 2:38 pm
<:-)
"gonna have to have a litte chat" sounded too threatening....!
**ASCII stupid question, get a stupid ANSI !!!**
July 8, 2005 at 2:32 pm
losing your vision ?!
**ASCII stupid question, get a stupid ANSI !!!**
July 8, 2005 at 2:28 pm
quelle difference ?!?!
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
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!
**ASCII stupid question, get a stupid ANSI !!!**
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
**ASCII stupid question, get a stupid ANSI !!!**
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...
**ASCII stupid question, get a stupid ANSI !!!**
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)...
**ASCII stupid question, get a stupid ANSI !!!**
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
**ASCII stupid question, get a stupid ANSI !!!**
July 8, 2005 at 10:50 am
Viewing 15 posts - 1,891 through 1,905 (of 2,469 total)