Check the link below. Hope it helps.

http://technet.microsoft.com/en-us/library/dd578580(SQL.100).aspx

Regards,

Shaiju CK

Hi Wayne,

I have learned something new today. Thank you very much 🙂

Regards,

Shaiju CK

Dear Luke,

Thank you for your comment. When I saw makham01’s question, the only thing came into my mind is “COALESCE”. So I tried to get the result over it. If...

Hi Ravichandra,

Please find below some links related to this.

http://support.microsoft.com/kb/935573

http://weblogs.sqlteam.com/mladenp/archive/2007/02/15/60101.aspx

http://www.eggheadcafe.com/software/aspnet/31942052/downgrading-2008-to-2000.aspx

Regards,

Shaiju CK

--// Please try the below script

------------------------------------------------------------------------------------------------

CREATE TABLE tYourTableName

(

Position CHAR(1),

Name VARCHAR(30)

)

INSERT INTO tYourTableName VALUES('A','John')

INSERT INTO tYourTableName VALUES('A','adam')

INSERT INTO tYourTableName VALUES('A','eddie')

INSERT INTO tYourTableName VALUES('B','scott')

INSERT INTO tYourTableName VALUES('B','james')

DECLARE @tPosition AS TABLE

(

Id TINYINT IDENTITY(1,...

Hi,

Try this...

--------------------------------------------------------

DECLARE @lValueStr VARCHAR(MAX)

SET @lValueStr = NULL

SELECT @lValueStr = COALESCE(@lValueStr + ', ', '')

+ name + '(' + CAST(Counts AS...

Hi,

Try the below script. But changing datatype is the best option what Stefan and Paul White’s suggested. Otherwise you need to do lot of date conversions to get the result.

SELECT...

Hi,

Let me clear 2 things.

1) Is there any data in this table?

2) EmployeeName data type is bigint or any character data type?

Shaiju C.K.

Hi Hugo,

The 3rd and 6th options seems similar.

Shaiju C.K.

Hi Maqsood,

Can you recreate the table at the time of dropping or creating a new field? Before that you have to move/copy the existing data to a temporary table and...

Hi Jacob,

I tried the same code.

CREATE TYPE ItemInfo AS TABLE

(

ItemNumber VARCHAR(50),

Qty INT)

and I got the following error:

Msg 156, Level 15, State 1, Line 1

Incorrect...

Please find one of the sp script below.

ALTER PROCEDURE [dbo].[pLoadDoctors] ...

Hi Abhijit,

EXECUTE permission is already there. When I DENY VIEW DEFINITION permission it is giving the above error, otherwise not.

Hi Gail,

Those sps are not accessing any system tables.

Thanks,

Shaiju C.K.

Thanks Girish,

I meant print a message or show an error to the creator of that object. Anyway, You directed me to the exact link. This is what I want. I...

Hi Andras,

Thanks man !!!