Stephanie Giovannini (7/21/2015)

---

SQLRNNR (7/21/2015)

---

On the other hand, I do require candidates that I interview to remote into a server and perform a basic hands on exam while I monitor what...

Ed Wagner (7/21/2015)

---

WayneS (7/21/2015)

---

What we need to do here is to look at the patterns.

The Length is from the first numeric value to the first non-numeric value.

The Width is from...

What we need to do here is to look at the patterns.

The Length is from the first numeric value to the first non-numeric value.

The Width is from the next numeric...

In looking through this, I see several logical problems with the query.

First, you are trying to have a row contain both database role and server role permissions. Why not have...

Lynn Pettis (7/17/2015)

---

Careful dropping indexes. The DMVs that report usage reset on restarts of SQL Server. Just because an index is not used recently doesn't mean it isn't...

MilesToGoBeforeISleep (7/17/2015)

---

My data was on "Sheet 1" which I had renamed to "data". I changed it to "data$" and reran the query but got the same error. I also...

nidhi.naina (7/17/2015)

---

i Have a table with a column Capacity which is char(10) and gets populated from user files. I want to check records which have negative Capacity value. So i...

jasona.work (7/17/2015)

---

GilaMonster (7/17/2015)

---

And that's about all the patience I have this week for 'tell me how to do my job' type posts. At least today's going to be a short...

XML shredding is;...

I didn't notice it before, but that's not quite the code that I posted, which is (after modifying to varchar(30) as Steve suggested):

CREATE FUNCTION dbo._tTVFN_tEEst2 (@countryNr INT, @telNr NCHAR(30))

RETURNS TABLE

WITH...

sgmunson (7/15/2015)

---

Wayne,

Why NCHAR(30) instead of VARCHAR(30) ? For a phone number, it makes no sense to waste the extra byte per digit when you only need to account...

Eirikur,

I changed your (very nice) test harness to put the results into a temp table vs. using @CHAR_BUCKET. My results are:

T_TEXT ...

I'm glad that you can use it.

jbalbo (7/14/2015)

---

Ok so I think I found something in the forum and adapted it to work

SELECT

ParentObject,

STUFF((SELECT ', ' + [View As] FROM dbo.Signatures t2 WHERE t2.ParentObject = t1.ParentObject FOR XML...

Raymond van Laake (7/15/2015)

---

Yes, I saw older posts, was just wondering what fastest would be.

I eventually came up with this based on older posts:

ALTER FUNCTION [dbo].[__fx_test] (@countryNr INT, @telNr NCHAR(30))

RETURNS...