Body

Pepper

Alan.B (6/29/2016)

---

Luis Cazares (6/29/2016)

---

oradbguru (6/29/2016)

---

Hello, I was debugging some legacy code and came across an insert statement with only this in the where clause.

WHERE ' ' = ' '

Any ideas...

oradbguru (6/29/2016)

---

Hello, I was debugging some legacy code and came across an insert statement with only this in the where clause.

WHERE ' ' = ' '

Any ideas what this would...

You can keep your dates as dates using the date data type. It's easier to manage and requires 1 byte less of storage per row. 😉

You need one generic calendar/dates dimension which will be related to different columns in your fact table.

Possibly obvious but shouldn't hurt to ask. Have you run sp_blitz? https://www.brentozar.com/blitz/

Or other health check scripts?

Think set-based 😉

CREATE FUNCTION [dbo].[GetDaysUnavailable]

(

@intRefint

)

RETURNS TABLE...

jasona.work (6/29/2016)

---

Brandie Tarvin (6/29/2016)

---

jasona.work (6/29/2016)

---

So, I'm thinking if we get enough takers, we might be able to make a run at buying Taravai

Close enough to another island with an airstrip,...

It's possible, but it's not easy.

An option, if you want to keep queries dynamic is to use an ORM such as Entity framework. Be aware that if it's not handled...

Just a little humor.

Does this example helps you?

Note that the code is non deterministic, so the results aren't guaranteed to be the same on each run.

CREATE TABLE PersonalInformation(

PersonID ...

bcp doesn't have output to xls files. It generates flat files (delimited or fixed length) which you can add any extension.

Use SSIS for this.

You can use the SELECT...INTO... option using a global temp table or a perm table. A local temp table would lose the scope after finishing the dynamic code execution so...

No problem, as long as you understood the problems...