durga.palepu (6/28/2016)

---

It says the problem with converting the expression to int.

I see only the date expression in this query, do you use any other expression also?

Also you can rewrite date_begin...

Phil Parkin (6/24/2016)

---

Paul White suggests that the NOT EXISTS ... INTERSECT form produces better query plans than the EXCEPT form, and that's why I use it. See here (in the...

I think that Luis' solution will perform faster than any looping solution, especially once the square root short circuit is added.

Drew

Phil Parkin (6/24/2016)

---

UPDATE is probably better than MERGE.

If you are a fan of MERGE, please take a read of this[/url] and decide whether, perhaps, you should reconsider.

And rather than using...

By definition, an aggregate combines separate elements into one whole. This is exactly what you are doing with a pivot, which is why a pivot requires an aggregate. ...

, CASE

WHEN [Type] = 1 THEN 26

WHEN [Type] = 2 THEN 27

...

You don't need CASE statements.

select *

from tickets

where ticketdate = CAST(DATEADD(HOUR, -6, GETDATE()) AS DATE)

If you have a range that you are trying to fit into another range of the same...

The problem is that you are trying to add a string to a date.

set @SQLQuery = 'SELECT RequestDate, IP, RequestID, CustomerID, LoanID, Ranking FROM ' + @TableName + 'where RequestDate...

Luis Cazares (6/20/2016)

---

Don't forget to add the year as well.

An alternative to get both in a single function is to convert them to a string: CONVERT(char(6), yourDateColumn, 112)

I'm not sure...

BrainDonor (6/15/2016)

---

First of all, you don't need a CTE for this. The CTE would be useful if you were transforming the data prior to inserting it (at a basic level...

@jeff,

Thanks. It should be fixed now.

Drew

Jacob Wilkins (6/13/2016)

---

You could do something like this:

SELECT X1,

AllVar

FROM your_table

CROSS APPLY

...

pharmkittie (6/11/2016)

---

Thanks drew.allen for your help. I need to update the joined table only once per month but it should be "triggered" when the table without the Boolean value...

After 390+ visits, you should know how to post data to a forum to get the best results. I have a link in my signature if you need a...

You have two main options