One way to do this is dump the data into a staging table, including a SheetNumber column, break the data up that way, select the distinct SheetNumber values, and loop...

First, Inserts don't work that way, with procedural code between the Insert statement and the data to be inserted (the Select statement in this case).

Second, "output" doesn't work that way....

Does the "sample1" value reference something in a lookup table? If so, you can query that, and then two inline-subqueries will get you the counts.

If not, a query like...

Is the TOAD query going through the SQL Server linked server to MySQL, or is it directly connecting to the MySQL database? If it's a direct connection, then the...

Pink123 (3/9/2011)

---

Thanks for the reply

What if i replace Null with 0

with function ISNULL() as 0 is not a value that will be present in my table for cID.

After this will...

alen teplitsky (3/9/2011)

---

the pro's of vmware is that you ship the entire instance to DR and just mount it on your DR vmware host and change the IP. no need...

krishusavalia (3/9/2011)

---

Hey G ,

Your solution is awesome. It was interesting and i learn something new.

But in my senario, I have more than 2 million rows and for every row I...

bpportman 52825 (3/9/2011)

---

@HowardW - please ignore my typo for the second query. What is important is the developer states the first query does not return data under 2K8 but...

You're welcome.

Manvendra (3/8/2011)

---

Ok suppose i have to ceate a DR solution for a instance whihc has more than 100 dbs and b sizes is approx upto 30-40 gb.cost is not a...

I don't think there's a difference.

I just tested this in 2008 R2:

CREATE TABLE #A (ID INT PRIMARY KEY) ;

CREATE TABLE #B (ID INT PRIMARY KEY) ;

INSERT INTO #A

...

If you want to simplify having an SSIS package move data between domains (local server vs different Windows domain), it's sometimes easiest to set up FTP on the target server/domain,...

"Using" is too common a word to do an effective search on. I can't speak for the standards or whatever, but I've never seen it used in a join.

Do...

Unfortunately, the Where clause doesn't necessarily evaluate sequentially, so it doesn't work when you do that.

The thing to do is first insert all the ones Where IsDate = 1 into...

The reason you're having trouble with that is that Foreign Keys aren't built to work that way.

What you've done, by having Code1, Code2, Code3 is violate First Normal Form for...