nothing has changed .Its not just one step but job executes around 40 queries .

I have not tried to rerun since its production,it runs everyday at 7 am so will...

Table A

Id seq

1231

1242

1252

1263

Table B

TAbleBIDAIDAseqService

112311

212312

312313

412314

512315

612421

712522

i want to write a query which will give Table A id 124,125 ,126 as they dont have all of service(1,2,3,4,5)

i dont...

Thanks so much for the reply.I am confused .Can you explain with refernce to my example above

Thanks so much.This is what I was looking for.

Thanks,

Thanks for the reply.What does public implies here and how do I do it in a query.

Thanks,

Thanks but if I want to set the update date as some date in past ,how do I do that?

Thanks for the reply.

Even for some test purposes .Is there a way to change the updatedate in syslogins manually?

Thanks for the reply.Is it actually windows domain rules or SQl server own rules.Since I am using SQL logins and all users in application have their sql logins so if...

Thanks for the reply.

Because of lack of time ,we want to implement this password thing quickly and for this what currently application does is each time user changes passwords from...

Thanks all for the replies.

Its like this the various steps are

1.Generate text file from .dat file(Vb script)

2.Take the txt file and insert data in database

3.Move the original .dat file to...

Thanks a lot for reply.

My Web application is deployed on a web server A and database is on a Database Server B.

I am running out of space on Server A...

Thanks for the reply, it helps.

It implies that I will be able to set or map field length from my text file to columns in database.for example

First 2 chars from...

Thanks a lot

No the temp table doesnt have any rownumbers.

It sjust

insert into #temptable

select ....

from ...

then I do a select rownumber as mentioned in my query and it gives rowcount as 1...

Thanks for your reply.Your explanation is really helpful.