jshuter (12/17/2014)

---

I understand the need to use SQL when doing SQL but a little looping wont kill ya 🙂

I'd still do something like the following

declare @i int =...

Under SSMS> Server Objects, >

there is a Backup Devices folder. Here you can easily create a .bak file and easily find it later as well through here. You can point...

Statistically speaking you want the first quartile, so borrowing on Matt's solution I would just shift a few things to make it intuitive ...

with MYcte as (

selectMAINGROUP,vALUE, NTILE(4) OVER...

I find in these situation I save a lot of time by dropping the source and creating a new one. If I had SQL coded I copy it ahead of...

0 means 0 , NULL means unknown. They are not the same.

One approach if you do not want to have nulls in your table is to have a "magic"...

mitesh.temre (12/17/2014)

---

lvbntapasvi (9/6/2014)

---

Hello All,

I am new to SSIS, and have started using it from the past 3 weeks. I have a task where in I am supposed to access the...

I think...

I know this probably is a long shot but is everything lined up in the Sql Server Configuration Manager ? (I have shared memory, tcp/ip, and named pipes all enabled).

MMartin1 (12/1/2014)

---

You could schema bind a view to a table , so that the columns the view depends on are not altered until the binding is removed. This would have...

Eirikur Eiriksson (12/16/2014)

---

DonlSimpson (12/16/2014)

---

MMartin1 (12/16/2014)

---

It would not, but that is what the user wanted. That...

It would not, but that is what the user wanted. That is to prevent a...

As long as the business users understand the calculation and they are fine with it, that is what matters. Ideally if there are values missing I like to return null...

Eirikur Eiriksson (12/15/2014)

---

farrukhhameed786 (12/15/2014)

---

Hi

Please Below the query i need to use condition

I need to use in below query how to use

SELECT

ISNULL(EVT.VAL1/NULLIF((EVT.VAL2),0),0) AS ITEM_ID

FROM

EVENT1 EVT

WHERE NAME IN...

JeeTee (12/9/2014)

---

Where did you read nolock is deprecated?

Not that I'm encouraging use of nolock, but I see it's deprecated in from clauses in updates and inserts, but not straight selects....

Another thing to consider... in your four tables, if you only pull records that are time stamped within that last hour that you want to fetch and you dont need...