DECLARE @Pin VARCHAR(12)

  EXEC @Ret=GenerateSecurityNo @Pin OUTPUT

  SELECT @Pin

Change the proc as under

and then you could do something like

DECLARE @XPin varchar(12)

Exec GenerateSecurityNo @Pin=@XPin

SELECT @XPin AS PinNumber

CREATE PROCEDURE GenerateSecurityNo

 (@Pin VARCHAR(12) = NULL OUTPUT)

AS

DECLARE @MaxInt int

DECLARE @SecurityNo varchar(12)

DECLARE...

You may try this out

SET NOCOUNT ON

DECLARE @TBL TABLE (C1 VARCHAR(20))

INSERT INTO @TBL VALUES('1,2,3')

INSERT INTO @TBL VALUES('1,4')

INSERT INTO @TBL VALUES('1,6')

SELECT SUM(

 CASE ISNUMERIC(REPLACE(SUBSTRING(C1,1,1),',','A')) WHEN 1 THEN CAST(SUBSTRING(C1,1,1) AS INT) ELSE 0 END +

 CASE...

You may try this if you know,

To find out all the running traces you may use below sql

SELECT * FROM ::fn_trace_getinfo(DEFAULT)

and if you want to stop it particular...

You may try this

SELECT Combined.NursingHomeName, Combined.City, Combined.Street, Combined.State, Combined.ZipCode, Combined.PhoneNumber, Combined.CertifiedNumberOfBeds, Combined.TotalNumberOfResidents, Combined.PercOfOccupiedBeds, Combined.TypeOfOwnerShip, Combined.LocatedWithinAHospital, Combined.MultiNursingHomeOwnerShip

FROM  Combined

WHERE  Combined.NursingHomeName In

 (SELECT [NursingHomeName]

 FROM  [Combined] As Tmp

 WHERE  Left([NursingHomeName],5) =...

Try this

DROP TABLE [dbo].[Daily_Transactions.hist]

Ram

You may try this to convert and then do the insert

SET NOCOUNT ON

DECLARE @tbl TABLE (A VARCHAR(30),B VARCHAR(30))

INSERT INTO @tbl(A) SELECT '2015877052'

INSERT INTO @tbl(A) SELECT '800 554-6474'

INSERT INTO @tbl(A) SELECT '(650)...

You may have to check all the statistics/Indexes (It does not get carried when you convert to 2005..also Implicit conversion of datatypes does not use Index Scan/Seek in 2005)

SQL Server, may try this and LastUpdatedDate column will satisfy your needs 

SELECT 'IndexName'   = QUOTENAME(SI.[Name], '['),

       'LastUpdatedDate'  = STATS_DATE(SI.[Id],SI.IndId)

FROM  ..sysindexes AS SI

WHERE SI.IndId BETWEEN 1 AND 254

Another one ...

SET NOCOUNT ON

DECLARE @tbl TABLE (COL1 VARCHAR(20))

INSERT INTO @tbl (Col1)

SELECT 'ABC-0'

UNION ALL

SELECT 'ABC-1'

UNION ALL

SELECT 'XYZ-0'

UNION ALL

SELECT 'XYZ-1'

UNION ALL

SELECT 'XYZ-2'

UNION ALL

SELECT 'PQR-0'

UNION ALL

SELECT 'MNO-0'

UNION ALL

SELECT 'MNO-1'

UNION ALL

SELECT 'SPX-0'

UNION ALL

SELECT...

You may try this out

DECLARE @MyTest VARCHAR(20)

SELECT @MyTest = '009282d1'

SELECT CASE WHEN (ISNUMERIC(@MyTest) = 1 AND CHARINDEX('D',@MyTest) = 0 AND CHARINDEX('E',@MyTest) = 0) THEN 1 ELSE 0 END

Microsoft, Please fix this bug!!!

Ram

My Script requires ordering of records before update and hence 

DECLARE @tbl1 TABLE

 (ActualValue  VARCHAR(30),

 UpdatedValue  VARCHAR(20))

DECLARE @tbl TABLE

 (ActualValue  VARCHAR(30),

 UpdatedValue  VARCHAR(20))

INSERT INTO @tbl1(ActualValue) vALUES (100001)

INSERT INTO @tbl1(ActualValue) vALUES (100001)

INSERT INTO @tbl1(ActualValue) vALUES (100048)

INSERT INTO @tbl1(ActualValue) vALUES (100001)

INSERT INTO @tbl1(ActualValue) vALUES (100002)

INSERT INTO @tbl1(ActualValue) vALUES (100001)

INSERT INTO @tbl1(ActualValue) vALUES...

You may try this

DECLARE @tbl TABLE

 (ActualValue  VARCHAR(30),

 UpdatedValue  VARCHAR(20))

INSERT INTO @tbl(ActualValue) vALUES (100001)

INSERT INTO @tbl(ActualValue) vALUES (100001)

INSERT INTO @tbl(ActualValue) vALUES (100048)

INSERT INTO @tbl(ActualValue) vALUES (100001)

INSERT INTO @tbl(ActualValue) vALUES (100002)

INSERT INTO @tbl(ActualValue) vALUES (100001)

INSERT INTO @tbl(ActualValue) vALUES (200567)

INSERT INTO @tbl(ActualValue) vALUES (345000)

INSERT INTO @tbl(ActualValue) vALUES...

Run this below query in query analyzer and get the output of query and run it again.

USE Master

GO

SELECT A.RunThisQuery

FROM

(

SELECT  1 AS ColId,'ALTER DATABASE '+[Name]+ ' SET ONLINE' AS RunThisQuery FROM SysDataBases

WHERE DatabasePropertyEx([Name],'Status')...

Try this

set nocount on

declare @varname varchar(50)

declare @newownername varchar(20)

set @newownername = 'dbo'

declare @import table

(

rownum int identity (1, 1) primary key not null,

tablename nvarchar(255)

)

insert into @import (tablename) values ('chjohnson.christest')

select @varname = tablename...