Comments by Member 10815407

Member 10815407 17-Oct-14 9:36am View

I like your answer What would be the datatype of column 'Value' in Table2?
because attribute value can be integer,varchar or datetime value
and how can me use type casting and DateTime formating

Member 10815407 17-Oct-14 8:19am View

Suppose in future 30 more Objects are added then we need to add 30*10=300 new columns in Table3 and Now in Table3 total no of columns will be 500. Then how we will manage the table.

Member 10815407 17-Oct-14 8:15am View

I am not able to understand your solution. Can you pls give me more details with an example

Member 10815407 17-Oct-14 5:32am View

Suppose I choose SQL Bulk insert option and insert data into temp table. After validating data in temp table, I am inserting all data to main table. But this process taking more than 3 mins when total number of records>5K
So user can't wait for 3 min without any status(Data is uploading or not). Here we can display a progress bar but How? I have no idea

Member 10815407 17-Oct-14 1:59am View

But I need to perform multiple validation over the data

Member 10815407 9-Oct-14 2:41am View

Yes, After validating data in sql it is inserted in DB table then return control to application to display the status of insertion(error in validation and how many records inserted out of total records)

Comments by Member 10815407 (Top 6 by date)