Viewing 15 posts - 406 through 420 (of 789 total)
saravanantvr1984 (3/4/2009)
Hi dear all,If I give one date like '2008-03-04' i need the result next month last day or date
SELECT DATEADD(M,1,'2008-03-04')
March 4, 2009 at 5:41 am
steveb (3/4/2009)
good point !! thanks
As always all helps and alternative suggests are welcomed from each-other!
😉
March 4, 2009 at 5:28 am
steveb (3/4/2009)
try this code..
SELECT ParentId , '--Parentid' AS TypeId
FROM YouTable
UNION
SELECT ChildId , '--Childid' AS TypeId
FROM YourTable
Instead of UNION use UNION ALL because the UNION statement select only distinct values the...
March 4, 2009 at 5:21 am
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...
March 4, 2009 at 5:11 am
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...
March 4, 2009 at 4:53 am
sometimes:
They don't want you if you are overqualified! 😛
March 4, 2009 at 4:46 am
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
March 3, 2009 at 6:18 am
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...
March 3, 2009 at 5:57 am
Jeff Moden (3/3/2009)
March 3, 2009 at 5:44 am
Chris Morris (3/2/2009)
Jeff Moden (3/2/2009)
March 3, 2009 at 12:52 am
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...
March 2, 2009 at 7:36 am
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...
March 2, 2009 at 6:24 am
MANU (3/2/2009)
Why not watch a video-->http://www.jumpstarttv.com/clustering-sql-server-2005_33.aspxFree registration required.
MJ
Yea ...nice video tutorial how to setup cluster .....I agree with MANU!
March 2, 2009 at 5:37 am
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 ' +...
March 2, 2009 at 2:57 am
Viewing 15 posts - 406 through 420 (of 789 total)