Thanks for the response Dennis on the main part of my post.  I do see how this 2 week sprint works well for application development.  But again on the DW...

Loved watching Red-Green on PBS here in the states.

That's a great quote Jeff.  Reminds me of a conversation I had yesterday.  They wanted me to just write some SQL to pull from a table I don't know any...

Been here less than 10, hope to get 7 to 10 more before retirement. 🙂

I would still be curious as to how others manage their sprints.  I still think it...

Micromanagement is exactly it.  I just kept looking at it from the my point of view in that 'you keep putting road blocks in my way'.  I guarantee the amount...

As I stated above we were told we had to complete each ticket by the end of the sprint.  But at the meeting to close out the last sprint we...

Python is better for handling data outside of the database. Moving files, cleaning, loading, and for general tasks. Interesting to work with python and Powershell for the same task...

As someone who started out writing COBOL, and Assembler, it warms my heart that it's a skill in demand.

I mainly use SQL now for everything, using SSIS and...

As someone who started out writing COBOL, and Assembler, it warms my heart that it's a skill in demand.

I mainly use SQL now for everything, using SSIS and SSRS mainly. ...

"Good Enough", great song by Van Halen(Van Hagar to some 😉 )

I used to have some nightly batch jobs that ran for hours.  I was tasked with trying to make...

Here is some code I had pirated about 6 years ago:

CREATE TABLE #temp_list

(

db_names        varchar(500),

tbl_names        varchar(500)

)

;

EXEC sp_msforeachdb 'INSERT INTO #temp_list SELECT "?" AS db_names, name AS tbl_name FROM [?].sys.tables'

;

--SELECT COUNT(*)

--FROM #temp_list

--;

SELECT *

FROM #temp_list

WHERE...

You could have taken the code and created a SQL Stored Procedure(SP) you could call to replace the values in the field you sent the SP.  Then you could use...

• This reply was modified 2 years, 11 months ago by below86.

This will get rid of any amount of numbers you have:

DECLARE @var VARCHAR(200);

DECLARE @expres VARCHAR(50) = '%[0-9]%';

SET @var = 'Apple (red)(12323)(green)';

WHILE PATINDEX( @expres, @var ) > 0

SET @var = REPLACE(Replace(REPLACE(...

All of your examples also only show (23) as what you want to remove, it you know the string then a replace would be the easiest way to remove that...

So what will you store if you have "Apple (Red) (23) (Granny)"?  "Apple (Red) (Granny)"?

What is the purpose to remove the number?  Can the number be more than 2 digits?

You...