Viewing 15 posts - 20,161 through 20,175 (of 26,490 total)
Do you have DAC enabled on the server? If not, you may want to enable it; if you do, good. If this happens again, you may want to...
June 29, 2009 at 8:59 pm
Could you post the DDL for your DDL triggers? Maybe we'll see something you missed.
June 29, 2009 at 8:54 pm
Florian Reischl (6/29/2009)
Or, a UNION ALL if you generally don't like functions in your SELECT clause.
SELECT ZIP + isnull('-' + PlusFour, '') AS FullZIP
FROM [Address]
...
June 29, 2009 at 4:05 pm
Nuts (6/29/2009)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[DrugA]
AS
SELECT year1, month1, Quarter,[Patient No.]
FROM MainTable AS a
WHERE ...
June 29, 2009 at 3:57 pm
Peso (6/29/2009)
And without the CASE thingySELECTZIP + COALESCE('-' + PlusFour, '') AS FullZIP
FROM[Address]
Or, if you aren't concerned about using only Standard SQL:
SELECT ZIP + isnull('-' + PlusFour, '') AS FullZIP
FROM...
June 29, 2009 at 3:48 pm
Can you provide the DDL for the table (original, not temporary), sample data (in a readily consummable format that can be cut/paste/run in SSMS), expected results based on the sample...
June 29, 2009 at 3:46 pm
When using the quote button anymore, I do two things. First, I refresh the page prior to clicking on the quote button. Second, reading the quote to be...
June 29, 2009 at 3:36 pm
Alvin Ramard (6/29/2009)
Roy Ernest (6/29/2009)
Can someone take a look at this issue?? I am bit lost on how to help this OP.
That's ok. It's just the usual behind the...
June 29, 2009 at 3:23 pm
Florian Reischl (6/29/2009)
Uh... Sorry, folks! Didn't see that the discussion about the UPDATE-thread is ongoing here.
Just a side conversation between colleagues, please feel free to join in. 😉
June 29, 2009 at 3:20 pm
ddicecca (6/29/2009)
When you refer to Books On Line, is that something on this forum? I apologize ahead of time if this is a stupid question...
Nope, Books Online is the...
June 29, 2009 at 3:03 pm
GilaMonster (6/29/2009)
Alvin Ramard (6/29/2009)
Lynn Pettis (6/29/2009)
Snippy some people can be.
Yep. I'm ready to guess the solution to his update problem is, but we can't say without knowing more about...
June 29, 2009 at 3:00 pm
GilaMonster (6/29/2009)
Lynn Pettis (6/29/2009)
Actually Gail, I think it is just an old style inner join.
Except that there's no condition in the where clause that joins the two tables...
June 29, 2009 at 2:56 pm
GilaMonster (6/29/2009)
ddicecca (6/29/2009)
GilaMonster (6/29/2009)
Take a look in Books Online for the UPDATE ... FROM syntax.Seriously...? That's your help?
I'm sorry, I thought you might like a hint where...
June 29, 2009 at 2:50 pm
ddicecca (6/29/2009)
Lynn Pettis (6/29/2009)
ddicecca (6/29/2009)
GilaMonster (6/29/2009)
Take a look in Books Online for the UPDATE ... FROM syntax.
Seriously...? That's your help? I have Googled this for a good hour...
June 29, 2009 at 2:48 pm
Viewing 15 posts - 20,161 through 20,175 (of 26,490 total)