If refreshing the data is a significant part of the time being consumed by this, I would suggest breaking up the data into the sets actually needed by each set...

Considering implicit conversion will take place if the column datatype isn't DateTime, no, there isn't a real difference between the two, and they should get the same results.

ELT() is a MySQL function. Doesn't exist in T-SQL. This is a forum for MS SQL Server, so you will probably be better off on a MySQL site...

Would it be possible to automate the refreshes so that they happen off-hours?

Replacing them with SSAS+SSRS is definitely the right path to head down. As you mentioned, you'll never...

Eric M Russell (7/12/2012)

---

Todd Payne (7/12/2012)

---

Thanks for that example. Truth is hard, and it gets even harder when we want to communicate the truth. There is so much...

Select each one separately, then use the Union All operator to stack them.

Something like:

select 1 as Seq, 'PAccess' as AppAccess, Name

from dbo.MyTable

where PAccess = 1

Union All

select 2, 'HAccess', Name

from dbo.MyTable

where...

Saga... (7/12/2012)

---

I mean for e.g I have database HP561CT and HP561CTstg.

As per this demo names, i have reffered master means main HP561CT and HP561CTstg as staging database.

Just wanted to...

If you want to abstract hierarchies so they can cover many types of relationships, like these examples, you do it the way you do any many-to-many relationship in a relational...

Jeff Moden (7/10/2012)

---

@Gus,

Ok... I've been looking at this thread for a bit for "Sam's view definition" and I'm not finding any "SAM" that posted. Did you mean "Chris' view...

Jeff Moden (7/10/2012)

---

GSquared (7/10/2012)

---

Nitpick. Modify the CTE to use a Row_Number() function call instead of an ID column, and it will still be functional with missing ID values, or even...

If you're talking about Change Data Capture (CDC), I believe that's all/nothing on a table.

Revenant (7/10/2012)

---

GSquared (7/10/2012)

---

Steve Jones - SSC Editor (7/10/2012)

---

jay-h (7/10/2012)

---

SQLRNNR (7/10/2012)

---

If you can show that there is data to support a decision, it is more likely to be well received...

You're welcome.

I used to have a manager who insisted that SQL Server itself "leaked memory", because it takes memory from the server, and doesn't give it back, even if it's not...

I can see a use for this kind of thing in generating data for a dev or QA environment. Makes it so you can parallel patterns and volume of...