Actually, using TOP 1 may b the worst suggestion... you don't care which value you get from the respective tables?

rohanverma (9/1/2008)

---

Yup, I got this from this forum:

declare @filename char(40);

set @filename = 'File1.txt'

declare @dir char(30);

set @dir = 'C:\Misc';

set @openrow1 = 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=' + @dir + ';';

set...

mstjean (8/28/2008)

---

My argument against the usage I see here is that there are views nested within view within views. This is done to such an extent that what may appear...

The problem is that you've reached the undefined but omnipotent "tipping point". Try updating just a million rows and see how long (short) it takes. You'll need to...

Heh... yeah... GO for it! 😛

No explanation should be necessary... try executing parts of it yourself... lookup GO in Books Online to see what its correct and only format is....

You're using "bulkcopy" to do the inserts for "connections"? That's a new one on me. You're gonna have to show me that one. 🙂

The key is likely going...

When is the last time you did any maintenance on the indexes of the table?

Khalidhussain (9/24/2003)

---

I need to compare two databases (e.g. Development DB and Test DB) to make sure they are 100% identical. Is there a way to create a SQL view,...

G.R.Preethiviraj Kulasingham (9/25/2003)

---

I too faced your situation and finally wrote the scripts myself.

I'll be happy if my scripts are usefull

Please check

http://www.sqlservercentral.com/scripts/listscriptsbyauthor.asp?author=1771

There are many wonderfull tools available in the market....

So... what "destination" did you have in mind? If it's SQL Server, lookup the "-n" parameter of BCP in Books Online which says...

-n

Performs the bulk copy operation using the...

thatok (9/1/2008)

---

OK.

I have a table IRchair which has columns staffno and clusterid. I am going to add to this table a clumn named period. So I need to bring...

Heh... yep... someone doesn't have a good split function or didn't know how to do a crosstab...

Why not?

The problem is that this can't be done in a UDF because...

Select the count from both and see if they're equal?

Yes... there are a thousand reasons why this may happen...

1. Code to set the flag to 1 didn't work correctly.

2. Code to reset the flag to 0...