mpdillon (11/17/2008)

---

Lynn,

Thanks for your replies. You have started me thinking in different direction than I had been. The problem I am trying to solve is one of comparing dates but...

Shoot... you can say the same thing for documented things, as well. For example, sp_MakeWebTask is very well documented but they changed the privs in 2k-sp4 so that you...

Those are pretty standard interview questions and you'll probably find the answers simply by googling them. Look for "SQL Server Interview Questions". But, beware... if you get hired...

You might not want to use a pivot... please see the following... especially the performance chart near the end of the article...

http://www.sqlservercentral.com/articles/T-SQL/63681/

Then, a simple mod to Seth's good code should do...

--===== All of this is a duplicate of the test code you provided

-- with an extra...

You're welcome. Thanks for the feedback.

Serious or sarcasm? Can't tell from here.

Anyway, yeah, I forget about case sensitive servers. Thanks for the pickup on that.

One problem at a time... have you gotten to the point where you can see one...

eddy (11/17/2008)

---

Hey Jeff,

I was looking for the SP_MakeWebTask but the following appears on my screen.

sp_makewebtask is retained for backward compatibility. New Web pages are more easily created using Microsoft SQL...

Gaby A. (11/17/2008)

---

Jeff Moden (11/13/2008)

---

Pretty nice, Gaby... your article and some of the comments above gave me a couple of ideas for an article with just a pot-wad of tricks...

And, from BOL...

"ODBC does not fully support sql_variant. Therefore, queries of sql_variant columns are returned as binary data when you use Microsoft OLE DB Provider for ODBC (MSDASQL). For example,...

Cool... thanks, guys.

Yep... I agree... no scripting required for that. In fact, you don't need SSIS, either. Simple BULK INSERT will do.

Clint,

You still haven't answered my question... do you want all the rows of Summary Van No. to be the same?

De nada!