Paul,

Thanks for the full explanation. It makes complete sense now.

Jeff,

Thanks for your time and full test. You do a fine job of myth busting. I've used your...

Paul,

I've kind of forgotten what the advantage to SCHEMABINGING is for a scalar UDF. I think I read it somewhere, but I can't find it in my SQL saved...

Most of the time I've done this was for stored procedures that returned an OUTPUT type parameter, which can mostly be replaced by scalar functions. I'm afraid there is...

I've had problems with Access front end to SQL Server back end like the one you describe.

Access is a funny beast when dealing with SQL Server when the forms are...

Lutz,

I must not have been looking closely at the screen when I ran the test from your previous post. You're right!!!

That was just bloody brilliant. Thanks!! I...

Lutz and Alex,

I really appreciate the time you guys put in on this problem. Unfortunately neither solution worked for this client. In the sample data for the table...

Imu,

If you can come up with it, my hat is off to you.

Todd

Thanks guys. The CTE with Row Number was exactly how I did solve it. I just though there might be a way to use PIVOT to solve the...

The only way I've found to handle this sort of thing requires several passes at the data. You want the most complete data possible for each duplicate:

-- Assuming that...

Thanks for your response. This isn't quite what I needed, however. I wanted to get 1 row per customer, with up to 5 sets of ordered pairs. ...

There is an easier way to do it. Using the COUNT(ColumnName) function counts only those rows that aren't null.

Here's an example:

create table #Orders (

OrderNum int,

...

Drushen,

I never did get a solution for GMail. What we ended up doing was set up a Linux box running Zimbra to use as the SMTP server. The...

The 1000 part is just an impossibly long number of characters to make up for the fact that we don't know exactly how long the string is. You start...

You can also populate the drop-downs using a UNION query if you don't want to add a default to the actual code table.

SELECT

0 AS ID

, '*** None Selected...

Thanks guys. I'll give them both a try.

Todd Fifield