It might be because you don't need the brackets to escape the underscore.

The other problem is because if the pattern is not found, then you'll get a zero as the...

I just wanted to note that the performance of DelimitedSplit8K function won't be affected if it receives a varchar(max) as input. It will, however, truncate the string to a 8000...

I'm not sure if this can work for you. Seems simple but I can't guarantee performance.

WITH cteText(string) AS (

SELECT 'oh_look_at_this.thing.his\hers_stuff\mine.craft\yours_protein' UNION ALL

SELECT 'i.am.a._thing.hers\his_things\mine.refrigerator\yours_potato' UNION ALL

...

Ed Wagner (8/20/2014)

---

Lynn Pettis (8/20/2014)

---

Lynn Pettis (8/20/2014)

---

Ed Wagner (8/20/2014)

---

This is one of the great things about this site. A question gets posted and several working solutions get posted. ...

Why don't you remove permissions to developers on production?

Maybe something like this:

SELECT StudentID,

FirstName,

Course ,

Score ...

Why is that a problem? Or it isn't?

How about using another column on the spreadsheet to generate the (revoke?deny?) statements by concatenating some values?

Then you'll just need to copy that column and execute it.

It's just a thought.

Scott Coleman (8/19/2014)

---

I just reread your original post. For data transfer between databases on the same server, the Execute SQL task with INSERT/SELECT should be faster than an SSIS...

I was just trying to group a table by weeks. My manager told me to use a table like the following (I've changed the names and I have no control...

Lynn Pettis (8/19/2014)

---

How about this one, starting monthly salary of $4,927 for a Senior Database Developer. That's 2/3 what I made at School District 11.

Granted, it is a non-profit...

CELKO (8/19/2014)

---

I'm working on setup where we have period like 201401 ( jan 2014), etc... And it is INTEGER , however it doesn't help if you need to...

You're absolutely right. This was made by someone who heard that cursors were bad and replaced them with while loops.

If you can...

No, the expression inside a COUNT() will only matter if it can return null values. Otherwise, is the same to use a constant, an asterisk or any non nullable column....

I'm sorry, I didn't realize that.

Let me start with the basics.

A script is a file that contains code. This is true for any programming language.

A stored procedure is a...