Todd Engen (4/8/2008)

---

Here's one simple way to do that. Just copy-and-paste the results into another query window.

USE MyDatabase

SELECT 'SELECT COUNT(*), ''' + name + ''' FROM ' + name...

Stanley Pagenel (4/8/2008)

---

Can someone help me I would like to save the execution plan using SQL management studio. But I'm still having the error telling me that :

Msg 195, Level...

Jack Corbett (4/8/2008)

---

Well, count this as one of the times I made a fool of myself. I actually looked up PatIndex in BOL expecting it to give an example...

Then why...

Two rather straight forward ways. If the table has no foreign keys, and shouldn't have any data in it as of now, then TRUNCATE TABLE mytable would reset your identity.

The...

Try something like this (the collation is key - you need to make sure the sure is case-sensitive:

select *

from mytable

where patindex('%[ABCDEFGHIJKLMNOPQRSTUVWXYZ]%',mytable COLLATE Latin1_General_CS_AI)>0

Now - this is going to cause scans,...

born2 -

double check that SSIS isn't making any "stupid" guesses on the datasource properties (which also has column data widths set up). I find that it makes a...

You're going to have to break it up. You need to the initial query to only return the 8 smallest values per grouping, and then send that to the...

Stefan Bengtsson (4/8/2008)

---

Please, someone:-)

If i have the rate 0.5597% and want the yearly effective rate

How do i do that i t-sql

I now the answer, i looked in excel. It should...

GilaMonster (4/7/2008)

---

I've read some articles that say that truncate is not logged, hence cannot be rolled back. The truth is that truncate is a partially-logged operation.

The row 'deletions' are...

GSquared (4/8/2008)

---

I have a question on the Questions of the Day: Should I limit the complexity of the question by any arbitrary means? Like a specific word-count or anything...

For what it's worth - why not make that a computed column? That way you won't have to worry about fullname getting out of synch with last and and...

Jeff Moden (4/8/2008)

---

Sure, you could sub RowNum for *... not sure it matters for performance here as it might in other places. * allows it to pick the best...

For what it's worth - the solutions advanced implicitly answer the question of "open" as "how many cases are currently not ended at this moment". Anything that would open...

All I want to know is - who do I call...