SELECT CONVERT(nvarchar(MAX), GETDATE(), 101) + ' ' + Stuff(Right(convert(nvarchar(max),DATEADD(hour, DATEDIFF(hour, 0, GETDATE()), 0),109),13),6,4,'')

Regards

Guru

Thanks John

Regards

Guru

Hi kshitiz,

But we have converted the date to format 103 then why its not formatted.

And also when using getdate() its formatting but when we give the date its not...

Declare @dates int

set @dates=datepart(yyyy,'10/30/1988')

print @dates

if (select count(DATEPART(yyyy,years)) from period_dim where years=@dates)>0

return

else

Insert into period_dim values(@dates)

select * from period_dim

i think u r asking this...

Hi Jeff Moden,

Yes my post was blocked.. Its ok no problem

Regards

Guru

Declare @sum int

Select @sum=coalesce(@sum+'+','') + item_id from inventory.inventory_transaction

select @sum

I guess this will help u..

Regard

Guru

Hi Ant,

Thanks & sorry

Regard

Guru

Hi Jeff Moden,

Thank you for your reply. Here is the url http://www.sqlservercentral.com/Forums/Topic1252335-391-1.aspx

Regards

Guru

Hi Gail Shaw,

Can I know the reason why my post blocked? I had reply @ "Posted Yesterday @ 10:50:20 AM"

Regards

Guru

Hi Paul ,

You need to display the result 147 as 147:00:00 or 2:45:00

Hi Gianluca Sartori,

Thank you.. Im sure they asked for particular range of columns 11th column to nth column

Regards

GuruPrasad

Hi all,

this is the question asked in my previous interview.. How to select column 11 to nth from a table..

Hi,

I guess this can help u

select R.Rim_no ,NULL Account_no,NULL as Transactions,count(accounts) TotalAccounts,SUM(amt)TotalCharges ,COUNT(tran_name)Total_transactions from Rim R Inner Join Accounts A on R.Rim_no=A.Rim_no Inner join Atm On A.accounts=Atm.acount_no group...

Thank u Dave and Jayanth

Regard

Guru