i have a date column in an excel sheet...i need to take the value of the very first row of this column and i have to start incrementing the dat...

I don't have any ideas about tha...

i just wanna know whether it is possible to download a file through SSIS package...?

if we can...i wanna see an example then...

can you help...

Hi,

I'm not understanding the way...

how can i create a connection over HTTP....what is the connection manager that i should use?

yeh my friends... i understand it now....i was not clear with his requirements...:-D

sorry about that

yeh random manner...but not deleting 9 rows always for all the execution....it differs...i don't know how it deletes...sometimes i get 7 rows deleted, sometimes it is 8 and sometimes it...

yeh...he needs only india and iran...why should we go for other countries..?

so it deletes based on newid()..?

ok..i understand the select query..but what is that delete statement?

DELETE t

OUTPUT DELETED.*

im not aware of this type of declaration...what actually it is?

yes, Ratheesh is correct...

may be you select wrong column...

just use select name,region from bbc where name in ('india', 'iran')

this is more enough to select the particular records of this region..

if...

assume if im a client side..and im connectiong to server....i want to know the server date and time..? is it possible?

but when i rerun the stored procedure with different parameter values...once again it starts with 999,998....it should be like that...whats my mistake?

Ya thanks Buddy... i got fixed it...

sorry pal, i didn't understand that

CREATE PROCEDURE Sp_Coded (@TableName varchar(15), @ColumnName varchar(10), @CodeID int, @Number bigint, @MaxLength int) AS

BEGIN

DECLARE @MySql varchar(5000)

SET @MySql = 'select 1501 as JurisID,' +...

DECLARE @JurisID int, @CodedID varchar(4), @CodeIDDescr varchar(60), @SrcCodeDescr varchar(60), @IsConverted int, @DecNumber bigint

here i declare @DecNumber as a variable, how do i declare it as identity column or something?