Thank you all for the response....

let me try this..thanks for reply

i have used this code for converting ipv4 address

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION [dbo].[fnBinaryIPv4](@ip AS VARCHAR(15)) RETURNS BINARY(4)

AS

BEGIN

DECLARE @bin AS BINARY(4)

SELECT...

@r.P.Rozema:

It works for Ipv4 addresses..i just tried converting those 4 parts into integers and then binary.It is fine for v4...how about v6?

sorry for the trouble....

I have only 1 table

CREATE TABLE [dbo].[MySampleTable](

[LocId] [int] NULL,

[Low] [varchar](20) NULL,

[Hig] [varchar](20) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING ON

GO

INSERT [dbo].[MySampleTable] ([LocId], [Low], [Hig]) VALUES (1, N'205.34.25.20', N'205.34.25.255')

INSERT [dbo].[MySampleTable] ([LocId],...

Forget about table and Consider some fixed values for IpMin and IPMax just like above mentioned example..if it works i can work for a table. Thanks for responding.

thanks for responding...i tried that but it gives wrong result...

Lets say an ex: IPMin= 206.63.71.23

...

Thank you all for the replies.

thanks for the reply..

i want to convert the whole ssis package into sql. i do not want to use ssis packge again. i want to convert into sql and schedule...

Thanks for responding....Can you tell me how to generate script? Thanks

Anyways i got that thanks.....

Thanks Arjun.....

So which one works better when i have huge data? CTE or Subquery??

Thank you all

Thanks for the reply....Got it