Comments by pradeep kumar

pradeep kumar 13-Feb-18 10:27am View

How will i do that?

pradeep kumar 30-Jan-18 11:27am View

I am calculating percent sales by Total_Sales/(Sum of Each GWN_NO) technically

(sum(cast(AMT as float))/sum(cast(sum(AMT) as float)) over (partition by (SELECT NULL FROM DUAL))) percentsales

Thanks!!

pradeep kumar 30-Jan-18 8:28am View

Here among all GWN_NO which one shares 80% of sales, which I have given in expected output

pradeep kumar 11-Jan-17 10:15am View

Nope :(

pradeep kumar 29-Nov-16 15:23pm View

This looks pretty interesting I will test .! Thanks

pradeep kumar 26-Nov-16 16:58pm View

pradeep kumar 13-Aug-16 19:21pm View

Insert Into Sales_Table
Select Username,UniqueNo
from Login
where UniqueNo = @uniqueno
Union
Select
ISNULL(Sales_Count+1,0) AS [Sales Date],GETDATE() [To_date]

pradeep kumar 13-Aug-16 19:06pm View

Create an UDT, put all your JSON data in #temp table or something, from there you can able to cast or convert to expected data types.

pradeep kumar 19-Jul-16 17:12pm View

how to get only last modified date of an folder from FTP?!

Immediate help is appreciated.!!

pradeep kumar 7-May-16 7:34am View

Exception of type 'System.OutOfMemoryException' was thrown.; at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events)
at Microsoft.SqlServer.Dts.Runtime.Project.LoadPackage(IProjectStorage storage, Package package, String streamName, IDTSEvents events)
at Microsoft.SqlServer.Dts.Runtime.PackageItem.Load(IDTSEvents events)
at Microsoft.SqlServer.Dts.Runtime.PackageItem.LoadPackage(IDTSEvents events)
at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ISServerExecutionEvents.LoadPackage(PackageItem item)
at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ProjectOperator.StartPackage()
at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ProjectOperator.PerformOperation()

What does this error means?

pradeep kumar 6-May-16 9:35am View

From Flat File source to OLEDB Destination..,

pradeep kumar 23-Mar-16 10:25am View

:) :) I saw I got stuck while Ignoring Header row.

Thanks

pradeep kumar 23-Mar-16 10:23am View

Yes correct..!! Please post your ideas on this..!!

Thanks

pradeep kumar 23-Mar-16 10:22am View

Yes My requirement is Thomas Nielsen reply only..!!

Thanks for your reply..!!

Comments by pradeep kumar (Top 14 by date)