Instead of using ServerName\InstanceName

Use IPAddress,port

Example: 192.168.0.1,1433

Have you tried connecting using the IP address and port instead of the server name?

That happened in a company I used to work.

Are you kidding? a DELETE with no WHERE? :blink:

Is that the version...

I never read the "choose 5" instruction until I saw your...

Lynn Pettis (7/30/2012)

---

Luis Cazares (7/30/2012)

---

What's your point Lynn? The last two values use datalength on unicode strings and is normal to give the same output.

Am I missing something? Have you...

What's your point Lynn? The last two values use datalength on unicode strings and is normal to give the same output.

Am I missing something? Have you slept well lately?

ColdCoffee (7/30/2012)

---

Instead, you can use DATALENGTH function to get the length, inlcuding white...

Thanks Sean, but I was joking with this because I'm not sure palindromes count as a "practical application".

You can use it to check if 2 phrases are palindromes.

Just kidding.

It's important to give all the information possible in the first post, otherwise the solutions might not be completely accurate.

Here are 2 solutions with DDL and sample data (something that...

How would you define "the first ocurrence"?

I'm not sure if this is the best place to search for that answer, as the best solutions would be oriented on MS SQL...

Thanks Jared, I think I couldn't have explained that well.

Of course, I know what I'm doing but I have problems to explain when I see some things that might look...

This could be easier to translate (if even needed)

DECLARE @tTabletable(

IDint,

namevarchar( 20));

INSERT INTO @tTable

SELECT 1275, 'Customer A' UNION ALL

SELECT 3472, 'Customer A' UNION ALL

SELECT 2812, 'Customer A' UNION ALL

SELECT 1245, 'Customer...

Was this a homework assignment?