Rows are inserted into a table.

If I substitute the word TABLE for the word FUNCTION, your questions begin to make some (not completely) sense.

Please provide DDL and sample data.

Also, it would be helpful to attach a query plan so we can see what's going on.

It's hard to say without a proper example with DDL and sample data. You've got item1 in both sides of your CASE .. ELSE expression.

But perhaps a "SELECT TOP...

Indexing good.

Think of it like a book. If you know the term you are searching for, you turn to the index in the back of the book. The...

What is returned from the following query?

select * from distribution.dbo.MSsubscriptions

... or if there is an error message, what is the message?

Jason is correct, there is no error when I run this code:

CREATE TABLE #tablename (wo int, last_chg varchar(7),

amt_0109 varchar(7),

amt_0209 varchar(7),

amt_0309 varchar(7),

amt_0409 varchar(7),

amt_0509 varchar(7),

amt_0609 varchar(7),

amt_0709 varchar(7),

amt_0809...

Try :

+ ' SET insert_date = ''' + @InsertDate + ''''

I don't understand what you're trying to do. Your DDL is incorrect, but I assumed you are trying to create a table. I don't see a view except...

SELECT * FROM TABLE1

ORDER BY DEPENDENCY

It appears from your sample data this would come out in the correct order, but if your sample data doesn't reflect your actual data, you...

Love this question. I got A but missed B.

Yes, you can shrink logfiles without the database going offline.

I don't recommend shrinking database files if it can be avoided.

Sapen (11/9/2011)

---

Hi All,

Can we replicate all the tables from one node to another in peer to peer transactional replication. Also at any given point of time can a end user...

The table designer does not work that way.

The description field uses the extended property 'MS_Description'. You can edit and publish this in a bit more friendly fashion using the...

Can you please post the actual query, DDL and sample data?

hindle.steve (10/20/2011)

---

I'm executing some TSQL code in a job step. I need to specify the master database in the Database drop-down than what needs to be referenced in the code.

If...