Glad that worked for. Thanks for letting me know.

No you can't put it before.

FROM [dbo].[MitelCallTrace] mt

cross...

below86 (6/12/2014)

---

Sean Lange (6/12/2014)

---

below86 (6/12/2014)

---

I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t: This person also...

Like this.

if OBJECT_ID('tempdb..#something') is not null

drop table #Something

create table #Something

(

SomeValue varchar(100)

)

insert #Something

select '0154 6548647 11235' union all

select '0154 65478647 11235' union all

select '01464 64788647 11835 1654' union all

select '01464 64788647...

This is not only...

below86 (6/12/2014)

---

I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t: This person also had the idea...

waseemshaikh345 (6/12/2014)

---

So I have gone and input the date, But on the AND > on the codec is an incorrect syntax error.

WHERE '01/29/2014' >= dateadd(yy, datediff(yy, 0, GETDATE()), 0)...

pietlinden (6/12/2014)

---

Okay, you can filter your dataset so that you can only see the current year.

SELECT <column list>

FROM <table>

WHERE YEAR([SomeDate])=YEAR(GetDate())

(Not sure that's going to perform well, but one problem at...

I don't know....

mickeytech2000 (6/12/2014)

---

Hi,

I have the following code to send out an email if the row count of a table exceeds a certain number. But it seems to fire an email alert...

I would bot be a big fan of that. There are times that a procedure should...

The problem is that in your temp table RowNumber = 1 for every...

cbrammer1219 (6/12/2014)

---

This doesn't work for what I am wanting, it is counting the spaces, It doesn't count the characters before the spaces, as you see in the data below for...

That procedure has a lot of subqueries which is likely going to hurt. You are hitting the same table over and over. You also have some nonSARGable predicates in there....

Check out this article. It explains this type of query and a few ways to make it faster.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D