John Mitchell-245523

Forum Replies Created

Viewing 15 posts - 1,921 through 1,935 (of 7,191 total)

RE: Execution plan estimates Join hint spilling.

Please will you post the query and execution plan(s)? How about eliminating the temp tables and working directly from the source tables? Not always possible and/or desirable, but worth...

January 27, 2017 at 9:26 am

#1925384
RE: SSRS 2016 Error

PJ_SQL - Friday, January 27, 2017 8:54 AM
Yes , I can.
I don't get the error all the time, it is sporadic.
Are...

January 27, 2017 at 9:00 am

#1925378
RE: Adding datafiles to Tempdb

Without knowing anything about your environment, I'd say it would be more likely to have a positive effect than negative. But don't go adding too many! Have a read...

January 27, 2017 at 8:53 am

#1925371
RE: SSRS 2016 Error

PJ_SQL - Friday, January 27, 2017 8:37 AM
When I try to access SSRS URL externally or from any other server it gives...

January 27, 2017 at 8:49 am

#1925368
RE: Cost threshold for parallelism

george.p - Friday, January 27, 2017 8:39 AM
So are you guys saying that in effect the queries will take longer to run...

January 27, 2017 at 8:45 am

#1925363
RE: t-sql 2012 using error handling logic

wendy elizabeth - Friday, January 27, 2017 8:15 AM
I have the following questions about '

January 27, 2017 at 8:41 am

#1925362

RE: Cost threshold for parallelism

No. Imagine if you only had five dishes to wash. Even if you had a friend sitting around doing nothing, you'd still find it easier to do the work...

January 27, 2017 at 8:27 am

#1925352

RE: Cost threshold for parallelism

george.p - Friday, January 27, 2017 8:12 AM

Hi guys,

I have a question that I have read and heard differing opinions on in...

January 27, 2017 at 8:22 am

#1925349

RE: Permission set to allow user to create and manage databases

Alex

The database owner should be able to assign permissions in the database to other users. If you prefer a more automated solution, have you tried creating a...

January 27, 2017 at 7:03 am

#1925316

RE: Finding Within dates

Come on, this is a simple syntax error. You should be able to troubleshoot it yourself. Hint: count the open parentheses and the close parentheses on each line.

January 27, 2017 at 5:22 am

#1925288

RE: Semantics of simple-seeming UPDATE statement with FROM clause

Mark Dalley - Thursday, January 26, 2017 10:03 AM

BTW Do I surmise that the first example on the page you referred...

January 27, 2017 at 2:01 am

#1925255

RE: Semantics of simple-seeming UPDATE statement with FROM clause

Mark Dalley - Thursday, January 26, 2017 9:23 AM

To sum up then, what people seem to be saying is that...

In order for...

January 26, 2017 at 9:36 am

#1925099

RE: Convert number stored as text to number

Try changing the first "13" in each line to "12". You can also cast as decimal(18,2) if you only need two decimal places.

John

January 26, 2017 at 7:37 am

#1925059

RE: Convert number stored as text to number

Works for me. The bits I've added are in bold.

DECLARE @sNote varchar(1000)
SET @sNote = 'LI-FU-4DV-DCTN-EACH-0059-Monaco Couch Fully Upholstered Exotic Leather 4 Seater, line...

January 26, 2017 at 7:14 am

#1925052

RE: Get data into a table

INSERT INTO MyTable (StudentID)
select s.StudentID
from Students s
join Subscriptions ss on s.StudentID= ss.StudentID
group by s.StudentID
having sum(ss.Subscriptions) > 10

John

January 26, 2017 at 5:58 am

#1925033

Viewing 15 posts - 1,921 through 1,935 (of 7,191 total)