Refer

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/07/15/varchar-max-datatype-and-replicate-function.aspx

So you are trying to format the empno?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57069

Also refer

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/10/10/generating-random-numbers-part-ii.aspx

SELECT DATENAME(weekday,date_col) from table

You are welcome 🙂

SELECT DATEADD(d, 1, CalendarDay) as CalendarDay

FROM Days

WHERE DATEADD(d, 1, CalendarDay) < DATEADD(m, @NumberOfMonths, @FirstDay)

Means add 1 day to existing day until it is less than the first day of next...

Something like this

select t1.ID, t1.Date1,t1.Value1,t1.Value2,t2.Value3 from table1 as t1

inner join

(

select id,value3 from table2 where date1=(select max(date1) from table2 where id=t1.id)

) as t2

on t1.id=t2.id

More info

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Yes. It will also omit NULLs

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/02/different-ways-to-count-rows-from-a-table.aspx

jcrawf02 (12/10/2008)

---

Somebody posted a link to this website, and after reading this particular comic, couldn't help but post it here. Enjoy!

http://xkcd.com/327/

And if you don't get it, click here (http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/) for...

Select * from Table_Name as t inner join (sub query) as s

on t.Column1 like s.col+'%'

Nice Article Jeff

Here is mine

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx

The word OPTION is a keyword in sql server

Try using a different name

Also refer http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/dynamic-crosstab-with-multiple-pivot-columns.aspx