Viewing 15 posts - 7,666 through 7,680 (of 26,490 total)
SQL_Enthusiast (5/10/2013)
CREATE TABLE [dbo].[TEMP_COMMENT]
(
[GUID] [varchar](32) NULL
,...
May 10, 2013 at 3:40 pm
AnnA-607068 (5/10/2013)
May 10, 2013 at 2:57 pm
AnnA-607068 (5/10/2013)
May 10, 2013 at 1:38 pm
ssmith 29602 (5/10/2013)
There are more different stages then just Bus_Written and I need to include them...
May 10, 2013 at 10:02 am
ssmith 29602 (5/10/2013)
Select
oppo_opportunityref
,oppo_stage
,oppo_closed
From
Opportunity
Where
Case Oppo_stage When...
May 10, 2013 at 9:56 am
Revenant (5/10/2013)
jasona.work (5/10/2013)
18 days and change until I'm touching down in Jamaica for that vacation...
18 days and a bit more...
May 10, 2013 at 9:51 am
ssmith 29602 (5/10/2013)
If trying to write this
Case Oppo_stage When 'Bus_Written' Then (oppo_closed is null or Oppo_Closed >= GETDATE() -7)
but...
May 10, 2013 at 9:42 am
memymasta (5/10/2013)
SELECT 1,2,3
Feels like it shouldn't be much more...
May 10, 2013 at 9:39 am
j2cagle (5/9/2013)
May 9, 2013 at 4:15 pm
j2cagle (5/9/2013)
But, whether it's being executed from VB or another SP, it shouldn't make any difference to how the current SP should be written...should it?
Try it with this: 'ABC...
May 9, 2013 at 4:03 pm
j2cagle (5/9/2013)
For example, if I pass in:
"ABC DEF GHI"
I'm only...
May 9, 2013 at 3:51 pm
Evil Kraig F (5/9/2013)
Lynn Pettis (5/9/2013)
drew.georgopulos (5/9/2013)
make this crash?select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t
it works fine without the t?
thanks a lot
Because you have the table alias in the wrong place:
select...
May 9, 2013 at 3:44 pm
Straight from BOL:
http://msdn.microsoft.com/en-us/library/ms188629(v=SQL.90).aspx
Also here:
http://msdn.microsoft.com/en-us/library/ms189121(v=sql.100).aspx
May 9, 2013 at 3:40 pm
Viewing 15 posts - 7,666 through 7,680 (of 26,490 total)