Viewing 15 posts - 1,681 through 1,695 (of 2,469 total)
Mark - you can get it to work with char(10) because char(10) is ascii linefeed whereas '^p' is a literal string that is shown as a graphical representation to indicate...
July 24, 2005 at 10:03 am
Artie - you may want to look at this other post to see if there are any solutions to your problem...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=140147
July 23, 2005 at 10:52 pm
Mark - try this:
SELECT advert.AdvertID AS VehicleID,
RTRIM(REPLACE(advert.DescriptionDetails, '^P', '')) AS Description,
advert.SellingPrice AS Price,
...
July 23, 2005 at 10:46 pm
I am not sure I understand your question but it seems to me that you're looking for a "computed column" - something that automatically defaults to true if customer name...
July 23, 2005 at 8:56 am
Kyle - I'm not at all sure I understand your ultimate goal...but if you select some fields based on certain criteria and store them in one table and then select...
July 22, 2005 at 8:03 pm
Could you please explain your problem a little more clearly ?!
You seem to have 2 tables - are they not linked by any key at all ?!
also - what is...
July 22, 2005 at 3:56 pm
greene - not sure if you're asking how to get the name etc..but if you are, then the query would be:
select name, crdate from sysobjects
where xtype = 'p'
order by crdate...
July 22, 2005 at 3:08 pm
do you mean the scripts of the stored procedures or just a list of all the procedures in the database - if it is the former, you can use enterprise...
July 22, 2005 at 2:48 pm
LOL...since you started with the food theme, here goes nothing..
Being passionate to the point of zealous fanaticism about food and cooking I would love to see an "F"IA World Factbook...
July 22, 2005 at 2:22 pm
why don't you have a stored procedure return the value to you so you can reduce the number of trips to the db ?!
July 22, 2005 at 2:14 pm
don't lie noel - YOU're not here looking for help and knowledge...I've yet to read a single post to which you have not responded with "been there, done that...." -...
July 22, 2005 at 12:53 pm
yes - @@IDENTITY will give you the last inserted id in an identity column in the database - but this could be any identity column in the entire database -...
July 22, 2005 at 12:03 pm
ram4tech....usually with alphanumerics there's some company/business rule that dictates that the alpha part must be (eg: first 3 letters of dept.; first name initial+ first 3 chars of last name...region...
July 22, 2005 at 11:53 am
I'm with scking....except that I would import the csv file into a "regular" table and then select from it...
just a note...there are places when these markers occur 2 at a...
July 22, 2005 at 11:38 am
Mike - who's one-armed and why ?!
Ray - yes indeed - everyone has a distinct t-sql style - I recognized yours' even though you hid behind the innocuous "M" didn't...
July 22, 2005 at 7:06 am
Viewing 15 posts - 1,681 through 1,695 (of 2,469 total)