Viewing 15 posts - 1,096 through 1,110 (of 2,648 total)
One good reason for an application to only use stored procedures to access data is that you don't have to give the application-user permissions on the tables to select/update/insert/delete. The...
March 6, 2020 at 4:08 pm
What's the query and what indexes do you have on the table? and how on Earth do you expect people to make out a tiny screen dump of an execution...
March 5, 2020 at 11:59 pm
Sorry... Missed Jonathan's post, which appears to be spot on. Jonathan, how did you figure out it was a rail schedule and where to get the documentation on it? ...
March 3, 2020 at 3:57 pm
I don't really feel like I should be defending myself here, but 'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P' is 57 characters long, the length of all those columns is...
March 3, 2020 at 2:39 pm
getting the data into the database isn't an issue its breaking out the the differing record types ...
However I have manged to re-code my procedure it will now load...
March 3, 2020 at 2:27 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...
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
Viewing 15 posts - 1,096 through 1,110 (of 2,648 total)