Viewing 15 posts - 4,051 through 4,065 (of 8,731 total)
The following thread might give you an idea.
http://www.sqlservercentral.com/Forums/Topic1585850-391-1.aspx
Your update seems wrong and overcomplicated. Fixing the join, this would work.
UPDATE e
SET [contentScore1] = s.contentScore1
from [PearsonScores].[dbo].ViewScoresView s
INNER JOIN [HSBCP_DB].[dbo].[ExamInfo] e ON...
October 9, 2015 at 12:42 pm
mister.magoo (10/9/2015)
Lynn Pettis (10/9/2015)
October 9, 2015 at 12:24 pm
Eirikur Eiriksson (10/9/2015)
Ed Wagner (10/9/2015)
DonlSimpson (10/9/2015)
anthony.green (10/9/2015)
Ed Wagner (10/9/2015)
crookj (10/9/2015)
Ed Wagner (10/9/2015)
happygeek (10/9/2015)
Deadlock victim!Cost
Expense
Revenue
Tax
Tariff
Price Increase
Pint
Pitcher
October 9, 2015 at 11:42 am
This might seem weird, but have you tried to recreate the table?
I kept getting an error which seemed to be replicating your problem saying that the column couldn't be indexed...
October 9, 2015 at 11:38 am
I couldn't find the explanation on why does the TRY...CATCH would reset the value of @@ROWCOUNT.
From BOL
Statements such as USE, SET <option>, DEALLOCATE CURSOR, CLOSE CURSOR, BEGIN TRANSACTION or COMMIT...
October 9, 2015 at 7:39 am
The ORDER BY clause is not valid in views, inline functions, derived tables, and subqueries, unless either the TOP or OFFSET and FETCH clauses are also specified. It hasn't been...
October 8, 2015 at 2:46 pm
I'm not sure if this helps.
I sure had fun replicating the SOUNDEX function which I then changed it into the DIFFERENCE function, all by keeping it as an inline table-valued...
October 8, 2015 at 2:26 pm
I guess you could at least post your sample data in a consumable format (CREATE TABLE & INSERT statements) if you want some coded help.
If not, I can tell you...
October 8, 2015 at 11:46 am
I have no idea on the rules to get to the output. Where does the FormOrder comes from? Are the 2 input tables related? or are they just 2 set...
October 8, 2015 at 9:32 am
And by the way, the CREATE VIEW must be the first statement in a query batch. The IF and any other things that you might want to include must be...
October 8, 2015 at 9:12 am
Why are you using a BEGIN with your view? Views are a single statement and they can't include a BEGIN...END block.
October 8, 2015 at 9:09 am
You've got basically the same answer twice in different threads. Have you tried it?
This was the original thread: http://www.sqlservercentral.com/Forums/Topic1726364-2799-1.aspx
October 8, 2015 at 8:55 am
I just wanted to add, as a suggestion, that you should use table alias in your queries. It will make your queries shorter and easier to identify column names. And...
October 8, 2015 at 7:16 am
You could use the Quirky Update to get the desired result. If you don't want to mess with it, another option would be to use a well written cursor (not...
October 6, 2015 at 11:27 am
If you're going to work with timezones, you need to use the datetimeoffset data type. This means that you can't rely on GETDATE() because you won't be giving enough information.
That...
October 6, 2015 at 9:13 am
Viewing 15 posts - 4,051 through 4,065 (of 8,731 total)