I have a Date string. My objective is how to get the Datename.
I got this Receivedate as string when I used the Bulk insert. i make the
receiptdate as nvarchar because i got an error when i used the bulk insert.
Select ItemNumber, PurchasePrice, ReceivingPO, Cast(ReceivedDate as Datetime) as ReceivedMonth From #VPTable as vp Where vp.ReceivingPO is not null