Good question but I don't really agree that it displays "The encryption state of all databases on the instance". This view does not have a record for a database that...

kramaswamy (8/26/2011)

---

It seems to me like a better solution would be for you to just add a new column to your table and make use of the new HIERARCHYID data...

The bandwidth consumed will vary greatly depending on the data being sent. There may be a more elegant calculation but you probably just determine how much data your system is...

Jeff Moden (8/26/2011)

---

Heh... I was thinking the same thing and said, "Nah... " because it's...

asm1212 (8/26/2011)

---

No I dont have a WHERE clause in my SELECT query...I want to update table A...This query returns a result set and want to update those columns that this...

oh yeah....forgot about needing to break up all the batches like you were doing. Pay no attention to the man behind the screen giving you bad advice. 😉

One...

That syntax will work too. I still think you can drop the temp table entirely but that is up to you. 😛 Glad you got it to work.

True enough Jeff. Maybe it should be called LBAL (Level By Agonizing Level)? :w00t:

And of course if the two variables are always going to have the same value....just use one of them and you don't need both of them. 😀

You don't need a temp table for this at all. It is just adding unnecessary complexity. You have only a single row in this table populated by two variables.

To answer...

So you need to create a report in excel that uses excel as its datasource? Unless I am missing something I don't know why you would even bother with sql....

Recursive cte is still RBAR just not as visible. At any rate there a number of ways this can be accomplished. If you can post ddl, sample data (insert statements)...

al_nick (8/26/2011)

---

Three questions please:

1. In tsql, if I use multiple BEGIN/END blocks in stored procedure, will the second BEGIN wait for the first END to complete before executing itself?

2. If...

You have a where clause on your select? Add the same where clause to the update. If you post your select I can show you.