Viewing 15 posts - 46 through 60 (of 345 total)
Steve Jones - SSC Editor (6/4/2012)
Seriously, that's important. Get up, even for 5 minutes.
Do some stretches. Google for the various ones for your wrist. Adding some strength/muscle...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 4, 2012 at 9:02 am
How about
declare @Shape varchar(20)
set @Shape = 'oval'
select Material from #ITEM where ISNULL(Shape,@Shape)=@Shape
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 30, 2012 at 10:02 am
Maybe you don't need to create temp tables? Something like this will show the differences:
SET @SQL = '
SELECT *
FROM
OPENROWSET(''SQLNCLI'','''+@Conn1+''', '''+@SP1+''')
EXCEPT
SELECT *
FROM
OPENROWSET(''SQLNCLI'','''+@Conn2+''', '''+@SP2+''')
'
EXECUTE(@SQL)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 29, 2012 at 7:46 am
Those are all single quotes ('), not apostrophes (`). I replace all single quotes with apostrophes on input and don't have to worry about double (triple, quadruple?)-single quoting again.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 22, 2012 at 9:52 am
Sean Lange (5/21/2012)
toddasd (5/21/2012)
Select ISNULL(Item, ' ') from ITEMS
Or are you trying to find...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 22, 2012 at 9:02 am
If it is already a space why change it to a space? Wouldn't this get everything:
Select ISNULL(Item, ' ') from ITEMS
Or are you trying to find values that are...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 21, 2012 at 1:22 pm
Eugene Elutin (5/15/2012)
..., but this is forcing the sort.
Yeah, but it will only work for known values.
It's as well as doing it manually...
Not at all. It's sorting by...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 15, 2012 at 12:32 pm
I'm sure someone may find a more elegant way, but this is forcing the sort.
with c (doc_name) as (
select 'OO27k' union all
select 'OO27l' union all
select 'OO27m' union all
select...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 15, 2012 at 10:47 am
Your table DDL and insert statements columns don't match, but it looks like you simply need something like this in the WHERE clause:
WHERE (origin_code = @origin_code OR origin_code = 'ALL')
AND...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
May 8, 2012 at 7:37 am
The code I wrote for you worked just fine. Why are you trying to rewrite it?
Actually, there's a typo in the original which probably threw him off.
DATEADD(dd.t.N,Date)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 30, 2012 at 12:13 pm
markpc2009 (4/30/2012)
INSERT INTO mytable
...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 30, 2012 at 7:49 am
opc.three, couldn't the where be combined like so (not checked for syntax):
select a.year, a.month, a.product, b.sales, b.units
from all_dates_and_products a
left join my_sales b on
a.year = b.year
and
a.month = b.month
and
a.product = b.product
where...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 19, 2012 at 3:11 pm
You can't join or select from a variable like that. Build the string then EXEC that like
EXEC ('Select * from ' + @FOC_SQL_1)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 19, 2012 at 11:05 am
Fear Naught (4/18/2012)
Now this may sound like a stupid question to some of the "guru's" on this forum. Why is there a need for a master table and...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 18, 2012 at 6:55 am
Rank1_nj (4/17/2012)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 17, 2012 at 10:14 am
Viewing 15 posts - 46 through 60 (of 345 total)