I recommend you read through Gail Shaw's blog on catch-all queries, you can find it here:

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

D'oh, okay, now I getcha....

GilaMonster (4/29/2012)

---

Because you're trying to remove more characters than the string...

Bob Barrows (4/29/2012)

---

Hah! We're still trying to find time and resources to migrate our existing SQL 2005 apps to SQL 2008, which we recently purchased to my amazement...

There's still one...

adc22 (4/29/2012)

---

Thanks bitbucket-25253 & Craig 🙂

@craig-2: Actually a new Project is on the way. So just preparing in advance. 🙂

One more related question .. can I...

Jeff Moden (4/29/2012)

---

So far as any "mid point" error goes, how would there be an error unless you were off course? You can't be more than half way...

Jeff (and OP) if I read this problem correctly, he doesn't have an endpoint yet and is trying to find said endpoint. Also using that technique you could miss...

Tara-1044200 (4/29/2012)

---

Not sure if understood you guys correctly but are you saying that i can remove last 12 charcters using LEN function?

i am just trying s simple select stmt and...

adc22 (4/29/2012)

---

Hi Experts,

I have some questions regarding SQL server 2008. Below situations are from DB testing arena .

1) How to check a trigger is fired or not, while doing database...

SQL Saturday out here in Phoenix was a lot of fun, and of particular interest I met a LOT of good people, including finally getting a chance to meet our...

I have a similar problem, partially because I'm a contractor who does whatever comes along, partially because I've never dedicated in one direction or the other.

I keep two resumes. ...

So two things.

1) Who's heading to SQL Saturday in Phoenix? I know Steve's going and I'm looking forward to meeting him, any other threadizens? Oh, warning: I don't...

From a distribution and load sharing perspective, apparently MySQL blows MS SQL Server out of the water, at least according to a few dual admins I know and one I...

Dynamic SQL is the only way to alter your target 'on the fly'.

In a case like this however you might be better off just setting up a massive union to...

A few things.

1) Restart Visual Studio/BIDs. the cache occassionally gets wonky.

2) Go through the package and look for OLEDB sources that are using stored procedures and the like. ...