Are you able to amend the file layout at all? It may be better to push the problem back to COBOL by adding record no. as a field and getting...

I would say; take the time to learn what your employer does. Many of us in IT work in the IT department of companies whose business is something else entirely....

If I've understood correctly, you write the results of a query to a work table and those results are tagged with a GUID. Other screens then work on this data;...

It seems that standards tend not to be developed until there's already a large body of existing code. You then have a choice of following the standard or following the...

I suspect the speaker was using the word snowflake in its meaning of unique rather than the more recent meaning of easily offended. I've not worked in an IT department...

Turns out our database backups should be reasonably safe - we're still backing up to tape!

If you do each iteration in a branch and only merge those Jira items you want to promote into Main prior to deployment, you can generate a script by comparing...

I think you need something like this (below). As mentioned by Ratbak, you'll need to drop indexes and foreign keys before making the change and you should definitely run it...

• This reply was modified 4 years, 1 month ago by  Chris Wooding.

When adding the reference to the non-managed database, you should set "Suppress Reference Warnings" to True. I think that will get around your problem.

Are you able to see whether it's blocked by another transaction? The fact that it returns null on the occasions when it takes a long time suggests some other process...

Jeff's comment about the cut-off for 2 digit years reminded me that the millennium bug was "fixed" at one place I worked by using YY>20 as the cutoff to guess...

If they've asked to be able to search for two area codes at a time, it won't be long before they ask to search for 3 or 4 or more....

We do the same as others have mentioned. Load into a table where the columns are wide nvarchar and then validate afterwards. We use TRY_CAST and TRY_PARSE to check whether...

My guess at the logic is that the seats are in pairs. Single children can sit anywhere there is a space, but siblings need to sit together, so their seat...

It would be nice if the object explorer in SSMS had a node under each database for triggers so that you could see them all in one place.