I can't. I have too many SP's.

Posted...

Apologies in advance if this is already known, I didn't read through the whole thread. The issue is likely arising because one of your strings is < 72 characters,...

Heh, yeah, had a few minutes to kill.

You can also just use notepad.

+---------------------------+

| Employees |

+---------------------------+

| EmployeeID int ...

SQL-939141 (12/11/2009)

---

Wow - click on the error and it takes you there - FAB!

We need a 'handy tip of the day'!

This would have saved me hours by now.

I guess the...

Never Say Never!

(Hehe, sorry, couldn't resist, but hopefully both the people that get that joke...

I mean, if you were gonna cheat, you could have at least done nickname as well....

Way to try and cheat Jeff....

BaldingLoopMan (12/9/2009)

---

not sure what ur saying about the selecting for a cte because u can sdo that w/ the #tables as well.

I like the #tables in development because i can...

Here's a short article on CTE's you could read when you want to start investigating them.

http://www.sqlservercentral.com/articles/T-SQL/68651/

BaldingLoopMan (12/9/2009)

---

All very useful info guys. Once again it appears the geniuses at sql server have designed a new way to do the same thing but w/ different syntax. Sure...

Dear Tally Table. How I love thee, let me count the ways...

SELECT *

FROM YourTable

WHERE pseudodatecolumn NOT IN (

select CAST(YEAR(dateadd(d,n,'19910101 00:00:00')) as char(4)) +

RIGHT('0' + CAST(MONTH(dateadd(d,n,'19910101...

Can you post the current query you are using? We may need more, but that'd be a good place to start.

niall.baird (12/8/2009)

---

I *can* read Garadin. That is why I was questioning the above statement. Seems to me that defining a #table would be more use, as you can use...

niall.baird (12/8/2009)

---

Seriously? You can only use a CTE in the statement immediately following?

When I read the article, the impression I got was that you could define a CTE at...