Post the structure of the table and some sample data and how do you want to see your data !

Hope that we will help you faster!

Dugi

Too many things positive or negative:

22 work days - Saturday and Sunday is day off

18 day holiday in year

15 day sick in year

Money or budget for any certification...

Mangal9i (3/6/2009)

---

Hi,

Try this... I guess very easy to understand and modify as well 🙂

;WITH Mangal as

(

SELECT Dateadd(yy,datediff(yy,0,getdate())-4,0) Date --Start Date,5 years including current

UNION ALL

SELECT dateadd(dd,1,date)

FROM Mangal

WHERE Date + 1 <...

Steve plz close this thread because the replies are active in this thread!

manju_gallivant (3/6/2009)

---

Hi,

I have a subquery which would return multiple records.

I need to update another table with these multiple records.

Say table has Name, age, birthdate etc .. as columns

and .....

Ok! I just notice that we can discuss in one thread no replies in both threads so one of them we must consider as closed and someone from moderators will...

Please don't do double posts all replies should be here ....the active replies are here so we are continuing here...

:w00t:

florian.reischl (3/5/2009)

---

Just write what you said...

DECLARE @datesum TABLE (id tinyint, name VARCHAR(25),sdate DATETIME, edate DATETIME )

INSERT INTO @datesum

SELECT 1,'TestName1','2004-01-25','2005-02-06'

UNION ALL

SELECT 2,'TestName1','2003-07-20','2005-03-18'

UNION ALL

SELECT 3,'TestName1','2002-12-24','2004-03-21'

UNION ALL

SELECT 4,'TestName1','2001-10-27','2003-03-03'

SELECT SUM(DATEDIFF(DAY, sdate, edate))...

Yep that's right MJ even that BOL has toooo much information about every detail, better to start from here in...

It seems that the account used to...

...and if you have again the question about SQL Server Express you can start thread here

http://www.sqlservercentral.com/Forums/Forum324-1.aspx

It wouldn't be any problem for upgrade or to change the trial version to standard or enterprise, just if the key is illegally sure that you cannot do such a...

doca (3/5/2009)

---

Hi,

Im takin error when i restore my .bak file to my database it becomes

TITLE: Microsoft SQL Server Management Studio Express

------------------------------

Restore failed for Server 'PERFECTPC\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

How can i resolve...

Please read carefully in the article in my sig and post the structure of you table and some sample data if you want to find the correct solution!

Why you can not find...click here

http://wtv.watchtechvideos.com/forum3.html