Thanks. That gives exactly what I need.

All our SQL data changes have to be made via a script. The script is written by the developer and peer reviewed before being executed by the Release team. Obviously...

INSERT INTO table2
SELECT col1, col2 FROM table1 t1
EXCEPT
SELECT col1, col2 FROM table2 t2

I very proudly stuck with my "stupid" phone for many years precisely because the charge lasted over a week. All it could do was handle texts and phone calls (and...

If the text part could appear before the number part, you could use Alan Burstein's pattern exclude function thus.

create table #temp
(
columnTextNumbers  nvarchar(50)
)
insert into #temp (columnTextNumbers) 
values
('3.5A'),
('5.50kg'),
('35.70kg'),
('9m'),
('£4.99')

select...

• This reply was modified 6 years, 4 months ago by Chris Wooding.

My boss has been very proactive in this area - we already had a weekly "Tea and biscuits" meeting, but he's moved that to Teams and we join in from...

I'd suggest that you look at some of the Stairway articles on this site. All the ones I've read have been extremely  well-written. You can pick topics that cover areas...

As the database is using a case-sensitive collation, I don't see why the 2nd option wouldn't work.

To find out which values are causing the problem, you could use TRY_CAST(YourColumn AS DATE). The values that can't be cast will be null in the new table. Then you...

And how long did it take them to give us a better message than "string or binary truncation"?

Now I really want a picture of Steve in a Smurf shirt!

Good article. The only thing I'd question is having the revision history in the header; over time this can become very verbose and bloat the script considerably. All that information...

That's my guess based on the fact that...

I had a problem a few days ago where using TRY_CAST gave no nulls in the result, but using just CAST caused an error. It turned out that either my...

I was expecting the LEAD solution to need the UNBOUNDED FOLLOWING frame, so I discounted that one.