Viewing 15 posts - 4,036 through 4,050 (of 8,731 total)
Why would you expect to have distinct values if you're not telling the engine to return distinct values?
October 14, 2015 at 9:46 am
Eric M Russell (10/14/2015)
This guy must have gotten the most laughs of any tech conference presentation. 😛
OMG, I can't stop laughing. 😀
I agree that Adam, along with others, have great...
October 14, 2015 at 8:03 am
It's very hard to give an advice. There's no right answer. I could tell you to for Company A as you'll get a great chance to develop yourself by knowing...
October 14, 2015 at 7:44 am
I guess it all depends on what you're looking for. 😀
October 13, 2015 at 8:25 pm
I have to split a string with '&' separated values without the use of a function or stored proc
Why can't you use a function? There's a great splitter function that...
October 13, 2015 at 8:52 am
DBA in Unit 7 (10/12/2015)
I am not sure if this is too silly to ask, but can someone explain why SQL Server only has one TempDB?
Is...
October 12, 2015 at 1:01 pm
crookj (10/12/2015)
djj (10/12/2015)
eccentricDBA (10/9/2015)
Ed Wagner (10/9/2015)
Luis Cazares (10/9/2015)
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
Round
Parrotheads
Paradise
Snake Eyes (pair a dice)
G.I.Joe
October 12, 2015 at 12:07 pm
When building your parameter list, you can add an "All" row with value '%'.
Just remember the following:
- If the column is nullable, you won't return rows where days...
October 12, 2015 at 12:03 pm
I assume that you were asked to change the old sql to prevent sql injection.
You could validate your variables to prevent it. For @UNIQUENESS you can do it manually. For...
October 12, 2015 at 9:23 am
There's the preview option, but I'd use SSMS or any other client depending on the RDBMS you're connecting to.
October 12, 2015 at 9:13 am
ChrisM@Work (10/12/2015)
Luis Cazares - happy birthday geezer. No idea how but it came up in some feed or other on my phone. Hope you had a great day 🙂
Thank you,...
October 12, 2015 at 7:56 am
Have you reviewed the data types?
You could create a 'csv' file and import it through bulk insert or bcp.
October 12, 2015 at 7:32 am
trapnell (10/9/2015)
There are several things in your code I've never seen before. For example, I don't understand why
SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
works. ...
October 9, 2015 at 1:45 pm
How do you know it didn't update?
What happens if you run the update outside the stored procedure or removing the SET NOCOUNT ON?
What do you get from this?
SELECT *
FROM [PearsonScores].[dbo].ViewScoresView...
October 9, 2015 at 1:15 pm
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
Viewing 15 posts - 4,036 through 4,050 (of 8,731 total)