Forum Replies Created
Viewing 15 posts - 2,521 through 2,535 (of 7,429 total)
-
RE: select from sp
quote:
quote:
I suggest personally use the reusable SP as base concept and create new... -
RE: How would you handle this and why??? (Common Data)
quote:
Well I'll step in a little late here...I would go with the single phone table but I wouldn't bother with the tbl_from...
-
RE: SPs and OUTPUT parameters
quote:
I am wondering why nobody mentioned UDF's. Since we can get a returned value as a table or scalar value ..... -
RE: weird concatenation problem
quote:
Antares,You're right, I missed this point... It really is interesting, because simple switching of the two values makes the query run OK...
-
RE: Creating pivot table view
quote:
quote:
quote:
I am totally fascinated by this... -
RE: How would you handle this and why??? (Common Data)
quote:
I'm all for empowering the user. As long as it is in a controlled environment.Hehehe,...
-
RE: weird concatenation problem
quote:
Antares,thanks, that brings some light into the problem, but anyway - LTRIM is in the ELSE part, so while you have WHEN...
-
RE: Creating pivot table view
quote:
It's also in BOL. Search for "cross-tab reports".Jeremy
PS Antares - you must had told Bill G how to do it.
-
RE: How would you handle this and why??? (Common Data)
Performance and no this is not the way it is, a lot of junk over the years got added after initially built and I know it is not up to...
-
RE: Creating pivot table view
quote:
I am totally fascinated by this solution http://www.stephenforte.net/owdasblog/PermaLink.aspx?guid=2b0532fc-4318-4ac0-a405-15d6d813eeb8Frank
So this method has a name. And I...
-
RE: select from sp
quote:
Configure your server for Openquery1) sp_addlinkedserver SERVER_NAME
2) EXEC sp_serveroption 'SERVER_NAME', 'data_access', 'true'
Then run:
3) select col2, col1 from openquery(SERVER_NAME, 'exec DB_NAME..SelectStuff')
-
RE: weird concatenation problem
It is the whole implicit explicit thing getting you.
from BOL ltrim
quote:
Is an expression of character or binary data. character_expression can be a... -
RE: Creating pivot table view
Try this
select ChkID,
max(case fldid when 1 then value else null end) as Fld1,
max(case fldid when 2 then value else null end) as Fld2,
max(case fldid when 3 then value...
-
RE: How would you handle this and why??? (Common Data)
Thanks for the input,
Frank for Personnel they have the option of
Work Phone (Their direct number)
Pager (Umbilical cords for potential emergencies and whatever contacts)
PIN (Pager related)
Cell Phone (Similar to a pager...
-
RE: Check Constraints versus Lookup Tables
It is common in the MS books to see them suggest using Constraints over FKeys where you can (sorry loaned my books out or I would give a spocific quote0>...
Viewing 15 posts - 2,521 through 2,535 (of 7,429 total)