Grant Fritchey (5/6/2010)

---

Steve Jones - Editor (5/6/2010)

---

GilaMonster (5/6/2010)

---

Grant Fritchey (5/6/2010)

---

Hmmm... They never even asked me how many questions I answered. I think if you took away the number of times...

IF 1 <> 0

BEGIN

Select @sql = 'Select * INTO #myTemp1 From TableA'

END

ELSE

BEGIN

Select @sql = 'Select * INTO #myTemp1 From TableB'

END

EXEC(@sql)

This runs but when I try to query #myTemp1 I get...

Adam.Massey (5/6/2010)

---

Hello all,

Had a problem come up that I have never seen and wanted to get some people's take on what I need to do...

The situation:

We have 3 servers that...

Try this:

with Search_cte as ( -- name the CTE appropriately

select

dbo.LEVENSHTEIN (USEARCH.firstname, ?) distance,

* -- should really specify the columns...

CirquedeSQLeil (5/6/2010)

---

The problem with that is you have to return to...

Came up with this waiting for clarification:

DECLARE @Table TABLE

(

id int,

...

Monday next week even better, only day I will be at work!

vijay.s (5/6/2010)

---

Dear Team,

Kindly look into my problem

DECLARE @Table TABLE

(

id int,

ClientIdINT,

bnmk_dt DATETIME,

AmountINT

)

...

Sure

Happy

It's

Thursday

I have to agree. If you are not happy as a DBA, perhaps you should look at other areas such as development. SQL Server is such a large...

Here is my take on it, tempdb is a system database and may be excluded from the 4 GB (or 10 GB) database limit. My best suggestion, contact Microsoft...

Grant Fritchey (5/6/2010)

---

Steve Jones - Editor (5/6/2010)

---

Not a bad thing, but for those of you that are MVPs, keep that in mind when reporting. I tend to report about 3/4...

Steve Jones - Editor (5/6/2010)

---

Top Ten Posters in this thread (out of 15,100 or so)

Lynn Pettis 1533

CirquedeSQLeil ...

mckinnj1 (5/6/2010)

---

Lynn Pettis (5/5/2010)

---

Didn't know you could run DBCC CHECK DB against a .bak file.

Were you able to restore the database itself as under a differnet name using the .bak...

From your post:

Now i want something like this:

Year booked shipped

2008 300 null

2009 500 ...