What is the recovery model on the database in question? If you need to control the growth of your transaction log, you may want to consider another alternative.

My I...

ScottPletcher (3/28/2014)

---

Ignoring any potential performance issues, a CROSS APPLY can do what you want fairly...

arrjay (3/29/2014)

---

Hi there - We have multiple SQL environments, a few of them are production which run Enterprise version of SQL Server.

Most of our development and QA environments...

Eric Stout (3/28/2014)

---

So I have data like the following:

ID COUNTER DATA

1 10 ...

Faster...

Congrats!

If you would like some real help solving your problem please read the following article. It will show you what you need to post and how to post it...

kaplan71 (3/26/2014)

---

Hello --

The third-party backup program can be configured to exclude the directory where the log files reside.

That brings me to another question: Correct me if I am wrong,...

Grant Fritchey (3/25/2014)

---

The Dixie Flatline (3/25/2014)

---

My poster child interview disappointment: Good resume' on paper, but then the man walked in, opened up his laptop, and scrolled through...

sharonsql2013 (3/25/2014)

---

Out Table has date as '2014-04-25' and time as 12:00 AM , 1:01 Am ,12:10 pm etc....

I need to see records for last two hours ...

How should I do...

Okay. You might want to mention that up front when asking for...

Here is a SQL way to do this easily:

declare @Date date = '20140201';

select cast(YEAR(dateadd(month,9,@Date))-1 as varchar(4)) + '-' + cast(YEAR(dateadd(month,9,@Date)) as varchar(4))

set @Date = '20140612';

select cast(YEAR(dateadd(month,9,@Date))-1 as varchar(4)) + '-'...

Why do you NOT want to use RANK or ROW_NUMBER functions?

Is this a good start? Without your expected results based on the sample data it is hard to know what you are actually looking for here.

CREATE TABLE [dbo].[Doc](

[ID] [int]...

homebrew01 (3/25/2014)

---

We came across a "gotcha" while testing our application without being in 2000 compatibility mode. We fixed all the *= left join syntax, but in another stored...