You can use a list, set the data set of the employee to the list.

Then add a rectangle to the row of the list, add all your text boxes for...

This is a really good one.

I wish it is true because MySQL's programming capability is far behind SQL Server T-SQL.

Is the Apr.1 joke becoming our wish list? The classic...

Nice trick Mark.

Great idea, Steve. I hope MS can adjust its license policy to what you described.

I am afraid sheet name is a necessary. It is equivalent to table name.

By default, Excel put Sheet 1, Sheet 2, ... as sheet name. In office 10, it does...

I would say catalouge views and DMVs added in 2005. Those really changed the ways that DBAs get meta-data and troubleshoot problems. But DMVs are still not widely adopted. They...

Step 5 means copy the t-log generated on primary to secondary while you were upgrading the secondary to 2008, and restore it on the secodnary with no-recovery.

When we talk about the time format (UTC or local), we need to think about it in the scope of whole application, not just storage. UTC is clean for storage...

JG,

The SP is a generic tool to import xml spreadsheet. After data is imported, you can apply any logic and processing to the data within your table. As that said,...

JG,

In your case, it's better to pre-create your table with all necessary columns, allow null for those columns that do not exist in the worksheet. Then call the SP to...

mgkirsch,

I used xquery orignally and changed to use OPENXML and PIVOT due to the following two issues:

1) It was slow for big xml;

2) If any cell in the spreadsheet does...

Please use the link in the "Resource" section at end of the article.

femc,

I tried on an excel with 274 columns, it worked fine.

JG,

I did test the scenarios when I gave you the necessary changes in the previous posts. I tested again today,...

JGay,

Both are yes.

Since those 37 columns are nullable, the SP should ignore them. So I think you found a bug. Thanks.

The fix is pretty simple. You can find the...

JGay 2041 (2/19/2010)

---

Peter,

1 - running debug. In debug SQL is one line, I split here for readability

INSERT dbo.TestTable

(

ABC_NAME_ADDITIONAL_INFORMATION,

ABC_NAME_ADDITIONAL_INFORMATION2,

...