Internally, a datetime is a numeric. That's why you can do a "SELECT GETDATE() -1".

If you are always looking for a month, then check out the "Date/Time routines" link in...

SQLRNNR (7/28/2015)

---

Those are used for cutting steak right?

Or are they the spindle-y things that they stack...

Well, we'll just have to take her out to dinner then.

sqlguy-736318 (7/27/2015)

---

Hi, can I safely use top n select/delete in a while loop? For example:

declare @FieldVal int

while (select count(*) from @MyTempTable) > 0

begin

select top 1 @FieldVal = FieldVal from...

sqlguy-736318 (7/27/2015)

---

Hi, are you aware of any shortcut strategies for table variables similar to shortcut strategies for temp tables? For example, the following SQL will create a temp table...

brody.rathman (7/27/2015)

---

I have results from a query that have anywhere from 1-4 results. I have a subid of 1-4 which is grouped by a certain criteria. so for example...

id ...

SQLRNNR (7/27/2015)

---

Your Loginfo results are a bit wonky.

It shows that the first vlf is 8kb and the second vlf is ~1090mb. This is not normal.

Second piece of wonky is...

So...

If I were to say that one of Gail's answers wasn't, well, entirely accurate... do you think this would get her out to Summit this year to whoop on me...

ScottPletcher (7/27/2015)

---

Yes, non-trusted constraints could seriously degrade your performance because SQL won't be able to use the index associated with those constraints and thus might have to scan the table...

Did you try the solution...

karthik82.vk (7/25/2015)

---

I have a four tables called plandescription, plandetail and analysisdetail. The table plandescription has the columns DetailQuestionID which is the primary and identity column and a QuestionDescription column.

The table...

Pseudo-simple is a new database in the full recovery model that hasn't...

shezi (7/24/2015)

---

I'm inserting from TempAccrual to VacationAccrual . It works nicely, however if I run this script again it will insert the same values again in VacationAccrual. How do ...

That's going to be a bit more difficult. For one thing, there isn't a row being returned for these machines for that year in that subquery... the NOT IN ensures...

Luis Cazares (7/23/2015)

---

This seems to be what you're asking for. However, it seems awkward that you consider the enddate as an enrollment date.

SELECT EMP.ID,

EMP.NAME,

...