They must be proud of their site. It helps unqualified people get jobs they can't handle.

How can I argue...

But isn't the problem with just replacing spaces is that it doesn't deal with other special characters?

EXEC(FunctionColumn) AS FunctionResult

Sorry, but functions can't call procedures. They can only call other functions. Period.

If I understand you correctly now, you want to be able to...

Good to know.

This code would make a handy little inline table valued function.

It currently filters out everything but letters and numbers.

Fairly quick, too.

declare @find varchar(50) = 'SET NOCOUNT ON'

declare @txt...

Work in progress. Now that I've got more time, I thought you might like to see a code sample of how OUTPUT works, just to make sure we're on...

+1 as well.

Good luck, guys.

Look up the OUTPUT clause, and the INSERT or MERGE statement. When you add a row to Table B using Merge, you can immediately get back all of...

While agreeing with TheSQLGuru that cursors are to be avoided, the way to calculate the number of seconds is fairly simple.

Declare @Start datetime = '8/23/2016 8:30am'

...

I know of two ways to approach what I *believe* you are describing.

One is dynamic SQL, using values from tables to build a string to be executed....

You are really better off working with a calendar table for these kinds of questions. It's better to have created and stored one on disk, but the following...

SqlStarter (8/24/2016)

i need to find whether a set of words for ex. SET NOCOUNT ON in a text. in text it may be SET NOCOUNT...

Thanks, Gail. Evidently my thought processes were shutting down last night from caffeine deprivation.

I am reminded of a very old song by a brilliant comedian named Tom Lehr,...

Firewolf, it may seem frustrating to ask a question and get sent a link to an article about asking questions, but there is a reason for it. We...