To  Rudy Komacsar

Only thing you need to do from second query analizer is to run

select * from #temp

at the end of your exercises. You'll get error,...

And look at the explanation:

"You need to remove the existing data, using the Excel automation model, copying a blank spreadsheet onto the target spreadsheet, or executing a drop table, create...

"Are DBA's hard to please?"

Not really. Just use proper words.

Truncate means delete all records but keep the table structure. Equivalent of the truncate in Excel is "Clear". This command will...

Actually there is no right answer in the list.

There is a little difference between "drop" and "truncate" table. And DTS package really drops the table - it removes spreadsheet from...

And that's exactly how it works!

In an environment with proper security no users should have any access to tables, especially to system ones. So, if you are good SQL developer...

To Don Healey.

Sorry, Don, but if you'll read you own post you'll realize that the answer you stated incorrect id definitely correct!

"SQL Statement A will return its recordset sorted by myiT.Unique_ID...

What's wrong with Datetime fields? Why indexes on those fields are not recommended?

I use to work with big tables containing records about some events. And main part of information is...

What's a point of questions about simple references to on-line help? Even if you don't know that it does not make you worse DBA because you can retrieve this information...

You cannot use that syntax because @Formula is not SP.

Actually options for EXECUTE ('String') are quite limited. It exists in own environment, no variables to be transferred.

The only way I...

You cannot use that syntax because @Formula is not SP.

Actually options for EXECUTE ('String') are quite limited. It exists in own environment, no variables to be transferred.

The only way I...

Add after last of your statements:

select @Formula = 'select ' + @Formula -- or 'print '

execute (@Formula)

and run.

That's all.

Sorry, Dinesh, you've got so many titles... Just like number of operands in your script.

But what about performance of your scripts? It's good while it has only 4 rows to...

Actually 50M rows is not the end of the world for SQL Server. No doubt there is PK on ID column in tbl_Parent.

May...

Replace(FieldName, '!', '') 

Variables may be not only CHAR type.

declare @Include table (I char)

insert @Include values('A')

select count(*) from employee

where Status in (select I from @Include)

insert @Include values('I')

select count(*) from employee

where Status in (select...