Taking Eirikur's set up:

SET NOCOUNT ON;

WITH SAMPLE_DATA(IP_ADDR) AS

( SELECT * FROM (VALUES

('132.135.3.100, fe90::bu54:e9z5:61a9:5003')

,('132.235.219.113, fe80::28d9:l69a:5bbd:gr2f')

) AS X(IP_ADDR)

)

SELECT

IP,

MAC

FROM

...

Eirikur Eiriksson (5/29/2015)

---

Quick suggestion, use dbo.DelimitedSplit8K on the comma

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(IP_ADDR) AS

( SELECT * FROM (VALUES

('132.135.3.100, fe90::bu54:e9z5:61a9:5003')

,('132.235.219.113, fe80::28d9:l69a:5bbd:gr2f')

) AS X(IP_ADDR)

)

SELECT

...

Does the string only have 'IPAddress, MACAddress'?

select left(@TestStr,patindex('%,%',@TestStr) - 1);

I can't post the declare of the @TestStr with the ip and mac address as...

TJT (5/29/2015)

---

Hi,

I am trying to grab the IP address from a field and having trouble getting some IP addresses. The query is below

SELECT ...

GG_BI_GG (5/29/2015)

---

I have the following expression;

Cust_nr between 9950001 t/m 9959999 then 2, Cust_nr between 9980001 t/m 9989999 then 3 and others 1

I like it to do it on a select...

You have two unnecessary BEGIN statements and no END statements. You can remove the two BEGINs.

I can understand why you can't make this a view, but what error are you getting when trying to create a stored procedure, and please post the code you tried...

ramana3327 (5/28/2015)

---

Thank you.

Incase, if I use the correct table name TableB (If I didn't use any Xact_abort on and there are no syntax errors)

In case of any error occur, Is...

sharonsql2013 (5/28/2015)

---

If its today it should show data from last week to last week - 52 weeks

Because we are in the middle of the week.. Hope I am not...

rocho09 (5/28/2015)

---

Hi, thank you for your response. I already upload the execution plan and here are the index definition, table definitions are above, please look into my first post.

CREATE NONCLUSTERED...

Okay, what...

sharonsql2013 (5/28/2015)

---

I am trying to get the avg of Tickets closed in last 52 Full weeks.

However , The query I have does not filter for full weeks and I get...

Letron Brantley (5/28/2015)

---

Yeah I did say that ... :Whistling:

Actually the real table is not. That's why we are doing the rename. Also both tables are partitioned with the...

Based...