I can't find the exact video right now. It's always been difficult to refind it because it's not a mainstream doctor type video, but this guy out in the woods....

Steve Jones - SSC Editor (6/4/2012)

---

Take lots of breaks.

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 about

declare @Shape varchar(20)

set @Shape = 'oval'

select Material from #ITEM where ISNULL(Shape,@Shape)=@Shape

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)

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.

Sean Lange (5/21/2012)

---

toddasd (5/21/2012)

---

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...

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...

Not at all. It's sorting by...

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...

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...

Actually, there's a typo in the original which probably threw him off.

DATEADD(dd.t.N,Date)

markpc2009 (4/30/2012)

---

This is the code which i am using, but i am getting incorrect syntax near 4 which is on the cross join line...

INSERT INTO mytable

...

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...

You can't join or select from a variable like that. Build the string then EXEC that like

EXEC ('Select * from ' + @FOC_SQL_1)

Fear Naught (4/18/2012)

---

Mmmm.

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...