Viewing 15 posts - 4,711 through 4,725 (of 8,731 total)
Let me try to make some points clear.
- What you're referring as Database, might actually be a Schema.
- If you run your code as it is now (without...
July 15, 2015 at 6:50 am
I hope that the wording for the answers could be corrected as there might have been translating issues or something (even if one could understand the intentions).
Thank you for the...
July 15, 2015 at 6:39 am
Mike Aguilar (7/14/2015)
IF EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'Index name here' AND object_id = OBJECT_ID('Table Name Here') DROP INDEX ....
I was just wondering why some people...
July 14, 2015 at 2:09 pm
sgmunson (7/14/2015)
mw112009 (7/13/2015)
Are you sure ? I am confused on the followingDELETE
FROM DEDUPE
WHERE RID > 1;
Should it be --->
DELETE
FROM AbC
WHERE ???
When a CTE exists, it...
July 14, 2015 at 1:55 pm
I actually prefer this format.
SELECT S.STRING, LEFT( t.newString, CHARINDEX(',', t.newString) - 1) AS NUM
FROM @STRINGS AS S
CROSS APPLY (SELECT SUBSTRING(S.STRING, CHARINDEX('resultid=', S.STRING) + 9, 8000)) t(newString)
July 14, 2015 at 1:34 pm
robert.wiglesworth (7/14/2015)
If I am able to edit how the records in this table get entered, should I...
July 14, 2015 at 1:22 pm
That's great! I just wanted to make sure that you weren't over complicating yourself.
I'm glad that you solved your issue.
July 14, 2015 at 1:16 pm
xanuyo (7/14/2015)
"Column 'NAME' is invalid in the select list because it is not contained in either an aggregate function or...
July 14, 2015 at 12:57 pm
SolveSQL (7/14/2015)
Apart from your syntax error (which i have not checked)what's the purpose of comparing same column from same table?
..."WHERE Loss_state = #tmpTotals.Loss_State"
That's used to get a correlated subquery...
July 14, 2015 at 12:35 pm
You just need to use MIN() and GROUP BY.
What have you tried? What problems have you encountered?
July 14, 2015 at 12:33 pm
Will you really have that amount of data elements? You could simply code for each possible data element. It would be even better if you change the EAV design into...
July 14, 2015 at 11:25 am
I would have loved if you referenced Data Type Precedence in the article to understand SQL Server decisions on implicit conversions.
July 14, 2015 at 9:41 am
Lynn Pettis (7/13/2015)
July 13, 2015 at 5:20 pm
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
Congratulations, Gail.
July 13, 2015 at 1:46 pm
Another option, just in case that you want to have your information returned in a different way.
WITH Groups(GroupID, GroupDesc) AS(
SELECT 1, 'Count Less Than 5K' UNION...
July 11, 2015 at 3:58 pm
Viewing 15 posts - 4,711 through 4,725 (of 8,731 total)