More discusions available if you search for IsNumeric.

Samples.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=296033#bm296042

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=243646&p=1

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=897

So associating different steps to different schedules is not possible.

How is it SQL Server 2005. I read there schedules are different entities and re-usable.

SELECT Client,

 DATEPART(MONTH, LogDate),

 COUNT(*) [Total Records],

 SUM(CASE WHEN Status = 'Processed' THEN 1 ELSE 0 END) [Total Processed],

 SUM(CASE WHEN Status = 'Not Processed' THEN 1 ELSE 0 END) [Total Not Processed],

 SUM(CASE...

CAST OR CONVERT Can be used

DECLARE @AA VARCHAR(25)

SET @AA = '01/01/2006'

IF ISDATE(@AA) = 1

SELECT CONVERT(DATETIME, @AA) AADate

ELSE

PRINT 'Not Valid Date'

SET @AA = '01/01/20062'

IF ISDATE(@AA) = 1

SELECT CONVERT(DATETIME, @AA) AADate

ELSE

PRINT 'Not...

SET VERIFY OFF - Not available SQL Server

Rest it is not possible to get user inputs by prompting in T-SQL Query Analyzer. You may need a seperate Application to do...

Thanks Peter.

With the help of this http://support.microsoft.com/default.aspx?scid=kb;en-us;186133

I made the same solution.

To my knowledge pivet needs a aggregate function. Without aggregate function logically it is not needed. can you explain specfic need.

Also it will be more rows something like this.

SET NOCOUNT...

Great ! Works faster.

Thank You very much.

I am not sure why you are getting an error. Try like this.

CREATE TABLE MyVarchar

(

MyField VARCHAR(10)

)

INSERT MyVarchar

SELECT 'A123' UNION

SELECT '123' UNION

SELECT 'B234' UNION

SELECT '234' UNION

SELECT 'C345' UNION

SELECT '345'  UNION

SELECT '345345E3' UNION

SELECT '234e2'  UNION

SELECT '234x34'

SELECT * FROM MyVarchar

GO

CREATE VIEW...

/*

Unfortunately yes. It is circular relations.

That is how the datafeeds are. The speck is for this case

118, 107, 405 are related to each other  with a generated ID and

645, 644...

Hi Vasc it doesn't work in large relationships table. Try with following data. It goes in an endless loop.

SET NOCOUNT ON

CREATE TABLE #Relations

(Main VARCHAR(10),Related VARCHAR(10))

INSERT #Relations

SELECT '100', '465'     UNION

SELECT '101',...

Thanks Vasc. I miss one row in each group still. Actual reqirement is group all related with a new generated id as below.

RelationGroup  Name

1                   AA

1                   BB

1                   CC

1                   DD

1                  ...

If it is scheduled as a job where will you see the output.

Create a DTS package destination as text file (Proerties Column delimiter TAB and TextIdentifier none)

Create a connection

Createa task...

It should not give duplicates unless there is a different NAM_FIRST, NAM_LAST or DTE_DOB for a NBR_SSN for the same NBR_SSN.

Can you post...

Thanks a million Jeff. That solved my problem.