steven (8/4/2009)

---

Hi,

I have a situation where I have bunch of 7-digit Encoded text in database like 0304182, now here

First two characters represent Product i.e. 03

Next two character represent Class...

Are you guys working together, or against?

http://www.sqlservercentral.com/Forums/Topic764816-1291-1.aspx?Update=1

You have practically the same code, and you ask the same questions, what's going on?

By the way, I answered to your friend there, see...

Try This :

SELECT DISTINCT CASE

WHEN DonorCompanyID -1

THEN d.OrderID

+ d.DonorCompanyID

ELSE d.ID

END REFERENCE,

CASE

WHEN DonorCompanyID -1

THEN d.OrderID

...

Thanks for the correction Gus, that's the difference between someone who takes the time to answer the problem, and...

How's that?

Select case when CTTitle is null

...

I say you should look into an SSIS package for all your backup moving, and schedule it within SQL Agent.

If you execute the procedure in SSMS, do you see the raiserror output in red? If not, maybe the message was not registered. You could try to send a custom...

Using Try/Catch with raiserror should get you the error message you want into VB. It will get you a message number of over 50 000 which means it's a user...

Elliott W (7/29/2009)

---

J-F Bergeron (7/29/2009)

---

Or append it in a single variable using FOR XML PATH('') with semicolumns as separators. But everything will be run in the same batch, don't know...

Or append it in a single variable using FOR XML PATH('') with semicolumns as separators. But everything will be run in the same batch, don't know if that is an...

Thanks for the feedback Pat,

Have a nice day,;-)

Hi, I built this procedure for you, hope that it helps you understand how you can easily nullify the results, or return everything, based on the parameters.

USE TEMPDB

GO

CREATE TABLE ProductTAble...

Hi,

I will not say it's the best way for your needs, but let me explain how we work here:

We use 2 fields in every table that's possible to lock:

CREATE TABLE...

Hey, by the way, I don't see why you use Dynamic SQL for that operation, all you do is a select/case statement, you should be able to include this in...

Hi,

Have you tried this?

exec sp_ExecuteSQL @vsql