try this

select

 name,modify_date from sys.all_objects where type='P'

try this

Create table Table1(

id

int,

name

varchar(100),

tracking_number...

michael.rosquist : The following is not giving the proper output ( ordered by 2nd column)

DECLARE @OrderBy varchar(33)

SET @OrderBy = 'Number3'

SELECT X1, X2 FROM...

use case statement like this

select column1,case column2 when 'Y' then 'abc'

Here 2 is not a column name, it is the position in the result set on which the sort operation to be performed

The second select in above mail is...

In a nested Transaction scenario, If the Outer Most Transaction is rolled back then all the inner transactions (even though they are committed) can be rolled back

Please refer BOL

It seems Order By Clause is ignoring the sort column position in the result set if used in conjunction with case statement

see this!!

DECLARE

@OrderBy varchar

What is your Question Exactly?

The above scenario is perfectly valid and if any error occurs in any of the stored procedures all the updates will be rolled back

try this

declare

@var varchar(10), @sql nvarchar(500)

set

@var...

I guess it will work , do not use values clause

try:

 INSERT INTO my_table (comments,

                                sr_status,

                                sr_notes_count,

                                sr_activity_count,

                                last_updated_dt)

 SELECT 'some input comments',

             (SELECT status FROM my_table_2 WHERE id...

subqueries can be used in values clause of insert statement, but it should return only single value

TRY THIS

DECLARE

@a VARCHAR(4000)

SELECT

@a = ISNULL

Modify the following where clause

p.SA_MAIL_ZIP = z.zipcode

to

convert(varchar(5),p.SA_MAIL_ZIP) = z.zipcode

I observed in your procedure.. In where condition you are comparing two datatypes without explicit conversion

SA_MAIL_ZIP is of int and

zipcode is of

Varchar(5)

use...

This will also work

SELECT * FROM Region WHERE RegionDescription LIKE COALESCE('%East%',convert(nvarchar,RegionDescription))

and this also

SELECT * FROM Region WHERE RegionDescription LIKE COALESCE('%East%',convert(char,RegionDescription))

Reason behind this is

LIKE supports ASCII pattern matching and Unicode pattern...