change the type_desc according to your's.:)

Hi pat,

Just try this one. It may work ....:w00t:

ALTER PROCEDURE sp_DeleteUsers

AS

BEGIN

DECLARE @Name varchar(256),@Cnt int

SET @Cnt = 1

SET @Name = (SELECT Count(name) FROM sys.database_principals)

--WHERE type_desc like '%use%')

--AND name NOT...

Hi pat,

This may help you to sort out the problem. I believe 😛

CREATE PROCEDURE Test

(

@SDate DateTime,

@EDate DateTime,

@status varchar(20)

)

AS

BEGIN

SELECT @SDate

SELECT @EDate

SELECT CAST(@Status AS varchar)

END

DECLARE @StartDate datetime, @EndDate...

Hi jass,

I think this link may help you .....

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

---

Hi,

see the last 3 line. It will work. May be you have to delete one '.' :hehe:

SET @cmd = 'bcp ' + @dbname + '.' + @tablename + ' '...

Hi,

Instead of * Use ColumnName whatever you want.

SELECT t1.ColumnName1,t1.ColumnName2,t2.ColumnName1,t2.ColumnName2,...

FROM Table1 AS t1

INNER JOIN Table2 AS t2

ON t1.ColumnName = t2.ColumnName

---

Hi,

Try this one.

SELECT DISTINCT g.loginid,g.LName,g.FName,g.office#

FROM gradstudents g

INNER JOIN ta t

ON g.loginid = t.loginid

WHERE classnumber NOT IN (SELECT DISTINCT classnumber FROM ta)

-----

Hi,

Make sure of the following settings:

i. The Regional Settings on the Server are correct.

...

Hi Andras,

Yes. Thanks you very much for your quick reply. 😛

Hi Sandy,

Try out this ....

SELECT EXP(SUM(LOG(SID))) FROM #t

😛

Hi stricknyn,

First find if you create any schema for this.

or just execute the following.

GRANT ALTER ON SCHEMA::dbo TO RoleName...

Thanks GilaMonster for your reply 😀

Hi vyas,

Thanks a lot for your quick reply.

In my server...

Hi Chrys204,

This is the temporary table (#d) and it is for current session only. that means for the current query window. moreover this is the local temporary table.

😉

Hi,

Create this "dbo.icddistance" function sepatatly.

After that create one more procedure like:

ALTER PROCEDURE dbo.sp_CheckDistance

(

@X1 FLOAT,

@X2 FLOAT,

@X3 FLOAT,

@X4...