SELECT DATEADD(M,1,'2008-03-04')

As always all helps and alternative suggests are welcomed from each-other!

😉

Instead of UNION use UNION ALL because the UNION statement select only distinct values the...

It would be better to change the color of the accepted post as solution for the user if the problem solved!

I suggest before that if we have solution to close...

The most thing that can be happen negatively for you and positively for the persons who interviewed you is that you have sometimes the overqualified skills and sure that they...

sometimes:

They don't want you if you are overqualified! 😛

Yea Correct something like this:

SELECT T1.emp_id, T2.emp_id, T2.name, T2.DOB, T2.emp_address

FROM TABLE2 T2 LEFT OUTER JOIN TABLE1 T1 ON t1.emp_id = t2.emp_id

Hmmm if you prepare more details about you problem it would be better that the other will choose your problem without spending time to create table then add some data...

Jeff Moden (3/3/2009)

---

[font="Arial Black"]Dugi... [/font]if I may suggest, it's better to give someone no answer than to give them what might be one of the worst answers for replacing cursors....

Chris Morris (3/2/2009)

---

Jeff Moden (3/2/2009)

---

There's no special technique for this... it's simply the choice to figure it out using regular ol' set based code. It doesn't require a Tally...

I don't have any info that you can do it with SQL Server database settings, SQL Server doesn't change its behavior depending on regional settings in this case the decimal...

Why you are going to change the decimal symbol?

Hi Jeff !

I know your rules about T-SQL and special techniques that you can use for any kind of the problem till today! I just make a little search couz...

Yea ...nice video tutorial how to setup cluster .....I agree with MANU!

declare @strsqlcreatetable as nvarchar(255)

declare @tablename as nvarchar(255)

declare @strsql as nvarchar(255)

select @tablename = 'lclifecycle' + convert(nvarchar(2), datepart(mm, getdate())) + convert(nvarchar(4), datepart(yyyy, getdate()))

print @tablename

select @strsqlcreatetable = 'create table ' +...