Viewing 15 posts - 34,306 through 34,320 (of 59,102 total)
vilonel (4/11/2011)
nigel. (4/11/2011)
Run this in a query window:
SELECT...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 11, 2011 at 5:38 am
paul.knibbs (4/11/2011)
Jeff Moden (4/10/2011)
How about spending more time and dollars on really cool stuff like designing a 350HP engine that gets 50MPG without batteries?
Because it's impossible? Petrol and diesel engines...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 11, 2011 at 5:33 am
I checked in Books Online and found Prefix-Terms where you can use a trailing asterick but no place where you use a leading asterick.
I'm not 100% sure but I don't...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 11, 2011 at 5:22 am
Sorry. I only looked at the query and not the question. My mistake.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 11, 2011 at 5:08 am
martin.edward (4/4/2011)
I have 3 different tables that I would like to query data from and put it in the following format
ConsignmentValue ...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 11, 2011 at 1:33 am
Gosh, folks... we don't need a Cursor for this and we certainly don't need a While loop.
Using the given data, the following works a treat and can easily be changed...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 11, 2011 at 1:24 am
a.ghasemi (4/10/2011)
is there any system or catalog view which I can use?
Yes. It's in Books Online.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 11, 2011 at 1:11 am
Anders Hansen (4/10/2011)
Not to ruin your wind shield story -...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 11, 2011 at 1:08 am
UMG Developer (3/5/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 11, 2011 at 12:39 am
I think people have really gotten silly with computers. I mean, c'mon! Why would anyone connect a bloody washing machine to the internet?
More silly stuff... I heard that...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2011 at 11:03 pm
lleemon13 (4/10/2011)
if my product_name values are:
articles
sunny valley
monster truck
wii sports
black eight ball
what's the equivalent to:
select * from product where (product_name like '%nste%')...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2011 at 10:53 pm
Read the following...
http://www.sqlservercentral.com/articles/T-SQL/63681/
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2011 at 10:49 pm
sharonrao123 (4/10/2011)
But you have suggested creating a generic function is not a good approach why is that?Thanks, Shilpa.
First, how would you make it generic without using dynamic SQL which cannot...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2011 at 10:44 pm
medwar19 (4/10/2011)
I got given 10GB of data in flat files which I imported into SQL and normalized.
Everything works fine but I'm now...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2011 at 7:53 pm
sharonrao123 (4/10/2011)
How are you guys doing?
I am hoping I get some inputs into how to create a generic user defined scalar function which will take in a column of...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2011 at 7:47 pm
Viewing 15 posts - 34,306 through 34,320 (of 59,102 total)