1 hour and 15 minutes until vacation. I am ready!!! We are taking the kids on a surprise trip to Branson for a few days. See you all next week.

Or looking at your attempt maybe you want everything after the first occurrence of '-'?

If that is the case your code would work if you close the function.

select RIGHT(@String,LEN(@String)- CHARINDEX('-',@String))...

dwilliscp (3/18/2014)

---

Hard coding where the '-' does not work since it varies, so the below does not split correctly

--RIGHT(col1,(LEN(col1)-6)) as col1,

I tried to fix it by using the below...

joakim.fenno (3/18/2014)

---

ChrisM@Work (3/18/2014)

---

joakim.fenno (3/18/2014)

---

OK

CREATE TABLE my_table (col1 nvarchar(25) NULL, bit_flag nvarchar(3) NULL)

INSERT INTO my_table VALUES('A', '100'), ('A', '001'),('B', '010'),('A', '001');

expected output from query :

A 101

B 011

The bit_flag column contains 12...

joakim.fenno (3/18/2014)

---

OK

CREATE TABLE my_table (col1 nvarchar(25) NULL, bit_flag nvarchar(3) NULL)

INSERT INTO my_table VALUES('A', '100'), ('A', '001'),('B', '010'),('A', '001');

expected output from query :

A 101

B 011

The bit_flag column contains 12 flag (and...

joakim.fenno (3/18/2014)

---

I be happy to use the built in T-SQL functions if that is possible.

But the function needs to work as an aggregate function.

I have to be able to execute...

Now that you have figured out how to convert your character data to a datetime I would HIGHLY recommend you change the datatype so you don't have to wrestle with...

domingo.sqlservercentral (3/18/2014)

---

No, I don't know. Do you mean about upload of database backup file? ...

karthik babu (3/18/2014)

---

i have the below table.. i need the intersection of j with group by of i column, which is 4. pls let me know the query to arrive...

raghuldrag (3/17/2014)

---

HI Friends,

i m creating one google map application using asp.net with c# i had done also

now that marker ll be shown from database (lat,long)

depends on the lat,long i wanna...

joakim.fenno (3/18/2014)

---

I want to create a custom bitwise OR aggregate function.

I want to use it like the built in aggregate functions (MIN, MAX etc.)

SELECT dbo.bitwise_or(bit_string) FROM table

where bit_string is a...

sten.f.soerensen (3/18/2014)

---

I've tried to convert the datatype from Image to Varbinary, but that didn't help. I keep getting file is damaged. I have also tried to change the code_page to...

As soon as I saw the title of...

OlyKLin (3/17/2014)

---

I can't add the column b/c I need to query all records between the 1st and 2nd date of the lookup table and add the column 30 to it...

OlyKLin (3/17/2014)

---

This seems simple enough but for some reason, my brain isn't working.

I have a lookup table:

Table A: basically dates every 30 days

1/1/2014

2/3/2014

3/3/2014

4/3/2014

I have Table b that has records and...