Garadin (8/17/2009)

---

Sounds like a plan. Thanks Barry.

Any comments from anyone...

GilaMonster (8/17/2009)

---

Those weren't dumb questions,...

Feel free to come back with any questions that you have on what BOL is saying.

Please explain what this means.

Look up "Linked Servers" in BOL ("Books On-Line").

Linked Server are something that you define on your SQL Server that allows you to access another Database server, including another SQL Server...

Well, for what it's worth, D would probably be the most likely to perform well, but I don't think that that is worth very much, because at this level of...

OK, this gets rid of the Cursor and still assigns candidates to board members pretty evenly (+/- 3 out of 720):

/*

RULES:

1. A selection board will convene, consisting of 3 to...

nahalsaeedi (8/16/2009)

---

I have a stored procedure in SQL which calculate formulas. The formulas are prepared in vb.net and are passed to my stored procedure. If formula contain ^ ,an error...

Jeff: Oracle bought SUN (for $7.4B ?) and got MySQL in the deal. It's a dark day for Open-source...

Here's a stored procedure that demonstrates how to do this:

CREATE PROC spWorkDays_Count as

BEGIN TRY DROP TABLE #WORKDAYS END TRY BEGIN CATCH END CATCH;

CREATE TABLE #WORKDAYS(

DayNo INT

, DateOnly DATETIME NOT NULL...

You might also consider using the sql_variant data type. This is after all what it was intended for.

OK here's the latest plus the scripts to test and demonstrate that it works correctly:

drop table RSUNew

go

drop table ISC_OrgUnits

go

create table RSUNew(id int, OrgUnitID varchar(12));

go

create table ISC_OrgUnits(OrgUnitID varchar(12), Parent varchar(12));

go

insert into...

Gianluca Sartori (8/14/2009)

---

I can't believe it! I'm almost finished with my article!

It took me three months. I could have written the "Divina Commedia" in this time...

Is anybody interested in...

It is probably more soft faults and less hard faults than before.

Peraonally, I'm still waiting for...