Thom A

Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 5,109 total)

Reply To: Ability to EDIT a post is timed.

Jeff Moden wrote:
Dave Convery wrote:
I've changed it to the upper bound of the software, so you now have 190 years to edit posts.
Awesome. I'll give it a try. Thanks, Dave....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

April 2, 2019 at 6:22 pm

#2534721
Reply To: Using the OUTPUT CLAUSE in a INSERT statement.
INSERT not being able to reference tables in the FROM clause is documented (OUTPUT Clause (Transact-SQL) - Arguments):
from_table_name
Is a column prefix that specifies a table included in the FROM...
- This reply was modified 7 years, 2 months ago by Thom A.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 2, 2019 at 2:14 pm

#2513119
Reply To: Split file attachment if they exceed size limit

What would you expect to happen if you had a single file with a size of 8MB or more? Could that happen? if so, how would you expect to split...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

April 2, 2019 at 12:00 pm

#2500471
Reply To: Convert source real data type to target decimal(18,5) data type .
I can't replicate your problem db<>fiddle. Could you post us some sample formatted DDL and DML so help us replicate the problem, and explain what the results you're after...
- This reply was modified 7 years, 2 months ago by Thom A.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 2, 2019 at 11:46 am

#2498615
Reply To: Quoting posts with Line breaks
Thom A wrote:
Title says it all here, but when quoting a post with line breaks in, the line breaks are lost. This actually can easily make the previous quote an unreablemess,...
- This reply was modified 7 years, 2 months ago by Thom A.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 2, 2019 at 11:11 am

#2494551
Reply To: Dynamic query

piu.scorpio wrote:
Hi Chris Thank you for your reply. But I have an issue. Your suggestion works if i the local variable values are null. But in the actual job they...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

April 2, 2019 at 10:46 am

#2492378
Reply To: Dynamic query
Does that SQL work? I suspect it doesn't, as context (ironically) has no context in the 2 lines below:
```
SET @projectId = '' + context.projectId + '';
SET @version...
```
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 2, 2019 at 8:31 am

#2478651
Reply To: What has happened to the layout / format of the forum ?

It's something that has been coming for a a while , but they put an announcement up last week: SQLServerCentral v3 coming tomorrow. If you note any problems, best...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

April 2, 2019 at 8:16 am

#2477499
Reply To: Can see all images when uploading an image

Steve Jones - SSC Editor wrote:
For pasting in images, where did you try this? Was this in the article editor? That was working, but I’ve filed a bug for that.
No, that was in the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

April 2, 2019 at 8:03 am

#2476410
Reply To: Are the posted questions getting worse?
Grant Fritchey wrote:
2373715 wrote:
This “little” problem is also the likely reason why about 80% of all my briefcase listings are now gone. They really need to fix this...
- This reply was modified 7 years, 2 months ago by Thom A.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 1, 2019 at 3:31 pm

#2375467
Reply To: Are the posted questions getting worse?

Sean Lange wrote:
Ugh…how many links all over the interwebs are there to the DelimitedSplit8K article? Or any of the other articles. Not sure why some are still valid and others aren’t.
I...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

April 1, 2019 at 3:03 pm

#2372000
Reply To: Are the posted questions getting worse?

Jeff Moden wrote:
Now all everyone has to do is fix the links in their signature line.
Was honestly hopeful that the address for the old articles would be...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

April 1, 2019 at 2:08 pm

#2364849
Reply To: Are the posted questions getting worse?

Something I did purely out of habit (from Stack Overflow/GitHub), but was surprised to find out to worked is backtick quoting (`) works on the site as well. So if...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

April 1, 2019 at 1:27 pm

#2360357
Reply To: I'm In Charge of Books Online
Jeff Moden wrote:
From the article:
<hr class="d4pbbc-hr" />
Don’t believe much of what you read today. Keep your head down and focus on code that you know is true.
Great prank, Steve. To...
- This reply was modified 7 years, 2 months ago by Thom A.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 1, 2019 at 1:18 pm

#2359191
Reply To: Using the OUTPUT CLAUSE in a INSERT statement.

ben.brugman wrote:
Sorry for the formatting, did some searching, but haven’t found the correct BBCodes for SQL formatting. Sorry. — Thanks Thom.
Click "{;} insert/edit code sample". Paste code into...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

April 1, 2019 at 1:14 pm

#2358794

Viewing 15 posts - 1,186 through 1,200 (of 5,109 total)