Yes. Note that you can use a CTE with an INSERT, UPDATE or DELETE statement in addition to the SELECT statement.

R2 has a mode (in BIDS) where you can select which version you're developing for. If you use the "R1" version, then sure.

Edit: added (in BIDS)

FWIW, I tend to think of a CTE as a pre-defined sub-query. (Of course, a recursive CTE is slightly different.)

And that, Steve, is quite the understatement!

Attopeu (9/30/2010)

---

Hi Guru,

I need new solution not to have temp table to store MAX identity. Here is current business logic: we have a job execute a procedure and if there...

If he's in his kilt you...

FYI:

I was able to manually uninstall the instance from the cluster using the directions at http://www.sqlservercentral.com/blogs/pearlknows/archive/2010/07/26/uninstall-a-sql-server-cluster-when-all-else-fails.aspx?CommentPosted=true#commentmessage as a guideline - modified to only delete registry keys and binary files that...

Tom.Thomson (9/30/2010)

---

East side of Michigan - anywhere between Detroit and Port Huron? That's...

Still trying to uninstall. No further progress after running overnight.

I have noticed that in the registry (HKLM\Software\Microsoft\Microsoft SQL Server) that there are keys for MSSQL10.NamedInstance and MSRS10.NamedInstance for the instance...

How's this?

Declare @FrDate datetime,@ToDate datetime

Set @FrDate ='2010-09-28 17:38:58.577'

Set @ToDate ='2011-02-01...

This is working for the sample data you provided. As previously mentioned, it won't work if you cross year boundaries.

Declare @FrDate datetime,@ToDate datetime

Set @FrDate ='2010-05-31 17:38:58.577'

Set @ToDate ='2010-09-01 17:38:58.577'

;WITH...

Are you ever going to have something like:

Declare @FrDate datetime,@ToDate datetime

Set @FrDate ='2010-09-01 17:38:58.577'

Set @ToDate ='2011-02-01 17:38:58.577'

Where the years are crossed?

If so, would you want?

1

2

9

10

11

12

When you're working in the editor, there...

Thanks Lutz.

The last few days, I've had issues trying to post to some threads... it just won't accept my code, but it will take it...

The attached code works for me; however I'm having problems posting it.

Edit: since Lutz posted my code, I've deleted the attachment here. See the following post of Lutz' for what...