If you're talking about Business Intelligence Dev Studio (which is where you build SSIS packages), then it probably doesn't have any templates because it doesn't appear to come with them....

Yes.

Service Broker is necessary for DBMail, for example. Has other uses as well.

I guess you'd probably need to talk to the people who provide the web service about that one.

(One thing to keep in mind is that "lac" and "lakh" are only...

I may be missing something, but what does SSIS have to do with web site building?

Do you mean .NET Dev Studio? Or something else?

Text data-type is one way to go on that. The other is to vertically partition the table.

If, for example, the table has an ID column, then you have the...

You're welcome. Glad I could help.

Lynn Pettis (5/28/2009)

---

Which is something I had (quite obviously)...

Nah. That requires at least some artistic aptitude. I'm not exactly top shelf in that...

Kit G (5/29/2009)

---

GilaMonster (5/29/2009)

---

I'm not sure he knows what he wants or what he's asking either.

Gut feel is that those bad stats are going to bite him but he probably...

Actually, if it's apples and pears, it's 1 or 2, not 2 or 3. 3 doesn't carry apples.

Here's a sample of how to do this kind of thing. ...

Have an identity column, and a calculated column based on it.

create table #T (

ID int identity primary key,

CustomerID as 'Cust' + right('000' + cast(ID as varchar(3)), 3));

insert into #T

default values;

insert...

Yeah, I'm good at left turns. Sorry about that.

Bob Griffin (5/29/2009)

---

There are several versions of the test out there. The one I took didn't really have any difficult verbage. It also gives a score of how...

Alvin Ramard (5/29/2009)

---

Kit G (5/29/2009)

---

Steve Jones - Editor (5/29/2009)

---

[drive by post]

Well maybe the questions aren't worse, but the grammar certainly is!

"The problem is that the order by clause was left...

Ramesh (5/29/2009)

---

X-Query is case sensitive, so all the methods and the data elements used in the xml must match with that used in the methods. For e.g.

The method "Value"...