gmamata7 (10/13/2010)

---

Hi,

I'm using the below Power Shell script discussed at the link http://www.sqlteam.com/article/monitoring-sql-server-agent-with-powershell to run at every one hour to check the SQL Server Services STATUS and if it find...

Hi

Find the below sites which might give u some idea

http://www.sqlservercentral.com/Forums/Topic664428-162-2.aspx%5B/url%5D

[url] http://msdn.microsoft.com/en-us/library/ms143724.aspx%5B/url%5D

[url]

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/0d4af4e9-99e9-433c-b1c5-decf74198678"> http://www.sqlservercentral.com/Forums/Topic664428-162-2.aspx%5B/url%5D

http://msdn.microsoft.com/en-us/library/ms143724.aspx%5B/url%5D

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/0d4af4e9-99e9-433c-b1c5-decf74198678

Thanks

Parthi

WayneS (10/13/2010)

---

But of course... superior ways to achieve...

Sacheen (10/13/2010)

---

Well table you can consider as -

Invoice Table -

[Invoice No] int, [Record/Transfer Time] datetime, [Departname] varchar(50)

I do agree that we will need to do self join as there...

Hi Gila shaw

Thanks for your replay as it is local...

no i need the output as of now then...

any thing dd/mm/yyyy or mm/dd/yyyy or yyyy/mm/dd thats not a matter i need to split and store so...

is this correct

StartDate=""? "":(SUBSTRING(StartDate,1,2) + "/" + SUBSTRING(StartDate,3,2)...

then how can i use here to check any other syntax for the above

Thanks

Parthi

Hi

Not for ClientB alone ClientA,ClientC... and so on all the clients can not have same...

hi

Any one got the solution for the above it is urgent i am wating to do this. still now not...

Hi

My...

Hi

Thanks for your response but i need in pure SQL/SSIS not in vb code.

Thanks

Parthi

hi

Here are some of the ways of upgrade

In-place Upgrade

Side by Side...

Jeff is correct unless you dont have a unique value you will not be able update the prv column with your data columns.you dont have any unique field as id...