This might be what you are looking for:

CREATE TABLE #MyTable(A INT, B INT)

INSERT INTO #MyTable

SELECT 1,2 UNION ALL

SELECT 1,1 UNION ALL

SELECT 3,4

SELECT 'A = ' + CAST(A AS VARCHAR(2)), 'B='+...

Speaking of blogs and twitter, just happened to read Steve's (Jones) blog posting for January 3rd.

Congratulations for once again being selected as a MVP.

Nice question, got it right on a hunch .... but still learned something .. thanks

If your developers are using temporary tables or want to create a new table you can use a SELECT INTO which will create the table with columns matching the data...

Congratulations

I have not tested the code T-SQL from this article:

http://www.sqlservercentral.com/scripts/Miscellaneous/31092/

From above link:

This is an update to sp_helpindex, it allows you to pass the table name and whether you want to...

This might be a start. It will list all indexes on all tables, plus a bit more about the index:

select g.name, d.name as 'IndexName', e.indid as 'IndexID', e.keyno...

Your welcome ... if you come up with what you think is a good solution please post it in the forum so others may benefit

Again - thank for you response...

Look at thiis posting by Lynn Pettis, you will most likely find the T-SQL you require.

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

It seems to this person, that effort should be expended to learn why that particular piece of equipment is sending incorrect data for incorporation into the database, and then to...

Steve a quote frequently attributed to Albert Einstein (although not found using a Google Search), but true nevertheless.

"When you stop learning you start dying"

- and one that I have...

My suggestion will be an outline of what could be done rather than specific T-SQL.

1. Create Table_2 without a primary key.

2. Start the T-SQL to perform the insert...

In the upper right hand corner of the forum page .. input "import from Excel". Click "Go". In the page that is shown click in the forum and...

It would be of assistance to those who wish to help if you can you post the table definition, and all indexes on that table, a limited amount of data...

Tom.Thomson (12/23/2010)

---

Mauve (6/17/2008)

---

I somewhat disagree that a TIMEOUT can be used to end a WAITFOR. It cannot be used independently and is only an optional modifier of the Service...