Viewing 15 posts - 1,096 through 1,110 (of 2,645 total)
Nothing wrong with COBOL!!!! and still use it on my shop.
I had to convert a Cobol system (well part of a Cobol system, as I didn't finish...
February 29, 2020 at 12:08 pm
Nothing wrong with COBOL!!!! and still use it on my shop.
I had to convert a Cobol system (well part of a Cobol system, as I didn't finish it) into...
February 29, 2020 at 2:16 am
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone...
February 28, 2020 at 12:24 pm
Are you sure you've pasted in the query you are running? I tried it and got:
Msg 102, Level 15, State 1, Line 21
Incorrect syntax near '@subject'.
Which is...
February 28, 2020 at 12:19 pm
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.
In my...
February 28, 2020 at 9:40 am
I don't think there is anything wrong with multiple substring commands, but if there are a lot of different row types and you want to make coding a bit simpler...
February 27, 2020 at 9:31 pm
A unique constraint is the standard way to prevent duplicates, though I usually just create a unique index instead.
alter table myTable
add constraint UC_LocoBrakeType_Col1Col2 unique (Col1, Col2)
Adding a...
February 27, 2020 at 11:31 am
An alternative query for the same results:
select c.TABLE_NAME,
c.TABLE_SCHEMA,
c.COLUMN_NAME,
...
February 25, 2020 at 9:32 pm
When I run Scott's code, I get this error msg?
Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'RowCount'.
Msg 156, Level 15, State 1, Line 8
Incorrect...
February 24, 2020 at 6:38 pm
You've already been supplied with some queries. Have you tried them?
February 24, 2020 at 4:46 pm
I think there is a mistake in your question. The SQL you described that works is exactly the same as the SQL you say is giving you an error:
February 24, 2020 at 2:13 pm
Jeff, Here is the data in a consumable format. I couldn't work out from the question exactly what's wanted so I'll leave it to someone else.
Except for a...
February 22, 2020 at 11:03 pm
Jeff, Here is the data in a consumable format. I couldn't work out from the question exactly what's wanted so I'll leave it to someone else.
;with Episode...
February 22, 2020 at 2:51 pm
You could also do it all in a single statement with a recursive CTE:
;WITH rCTE AS
(
SELECT a.RcvDt,
...
February 22, 2020 at 12:43 am
Scott's answer looks correct, the UPDATE is potentially updating the FromDate with the FromDate of a row it has previously just updated (which also could have been updated with...
February 21, 2020 at 11:53 pm
Viewing 15 posts - 1,096 through 1,110 (of 2,645 total)