pjcafonso (10/3/2013)

---

Hi all

I have the following table:

CREATE TABLE usTab1

(

Col1 INT IDENTITY(1,1) NOT NULL PRIMARY KEY,

Col2 Tinyint DEFAULT (0) NOT NULL,

...

Are you using sql server? That is not an error I have seen in SQL server.

What is the actual code...

a_car11 (10/3/2013)

---

Hi,

Thanks for your replay, but it still returns empty values for all results even when I have data in the "date" ( the column name "date"...

a_car11 (10/3/2013)

---

I am trying to replace a value from my select if the value from this column 'date' is equal to '0001-01-01' to ''. Not working, it returns nothing to...

:w00t:

I know what you...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Your "inline" function #2 is basically the same thing as a scalar function. It is multiple line function which means it behaves the same way. In fact, many time a...

Have you tried google? I typed in your question EXACTLY and the very first hit in google is what...

You are welcome. You really don't need the RETURN in there...

rocky_498 (10/2/2013)

---

Is this looks good to you?

Alter MYSP

Begin transaction

Begin Try

1st Insert Statement

2nd Insert Statement

1st Update Statement

commit transaction

end try

begin catch

rollback transaction

-- Raise an error and return

RAISERROR ('Error...

Since you are posting in the 2008 forum I will assume you are using 2008 or later. Don't use @@error, it is more difficult to work with and the code...

It is absolutely possible to do in sql. This article explains how to generate comma separated lists.

http://www.sqlservercentral.com/articles/71700/%5B/url%5D

If you need coding assistance, we will need a few things:

1. Sample DDL in...

Most likely you need to change your cursor location to adUseServer.

Also, NEVER NEVER NEVER post you actual connection information to a public forum. I would advise you to change your...

You should take a look at this article. It explains how to do this type of query and keep the performance acceptable.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

--EDIT--

NVM. I missed the RECOMPILE in there when I...

If you have read any of the other posts by that person...