Table variables are just like temporary tables, just light weight. Both are created in tempdb, table variable just have a few more restrictions. They do not have statistics...

gururajan (6/9/2009)

---

Hi friends

I want use Cursors in my query. How to use the cursors in sql2000. i want to some eample with any other link for...

DBA with OCD (6/25/2009)

---

Do you have any special requirements? Such as...

- Are you trying to save the 90 percent of the rows you need to get rid of?

...

Could you explain your problem in a little more detail and perhaps show us what you are looking for with a couple of examples?

Your initial post is a little vaque...

And then, based on the other thread where it looks like you want the names from TableA with no match in TableB:

SELECT

tA.Id,

tA.Name

FROM

...

Curious, can you recreate the problem using a simple cte instead of a complex one? Perhaps selecting an ID from a base table?

This one won't be easily solved. I am going to need some additional information from you, and I'm going to ask you to read the first article I reference...

Why the requirement for it to be an indexed view? I'm asking as sometimes it just isn't possible based on the data that is being pulled together.

We use HyperBac where I work. The differences I see are the following:

1) All our backups are to individual files. Each full, differential, and transaction log is written...

Not quite what you may have been looking for, but it does separate the date and time.

declare @TestDate datetime;

set @TestDate = getdate();

select

@TestDate as TestDate, -- Original...

sudha.2k7 (6/25/2009)

---

Hi

Could you please tell me if it is possible to use a data conversion transformation from nvarchar to int??

My data needs such a transformation as my manager...

Glad it works for you, and thanks for the feedback.

Heh, I am Saint...

Flo,

I only beat you by a minute. 😉

I only hope he reads the blog, but I doubt it.

I find this down right appalling:

rodan (6/25/2009)

---

We receive replication data from an external source and I want (you) to write a query that will

1. check to see that the data...