My current design and business logic is as following: There can be N number of clients. CLT_Clients table stores client information. There can be N...
Can someone please answer to this question?
I have to load the data shown in the below image into my database.[ATTACH] For a particular row, either field PartID would be NULL OR field GroupID...
Hi Preethiviraj thanks for taking interest in it.. BTW, I have got the answer now.
I am using SQL SERVER 2008, I have a number of INT, SMALLINT fields in my various tables, And I know they all will be 0 or greater than 0 i.e. I can...
Hi Satya To give you more insight into my database schema so that you can address the issue properly, please have a look at the below: 1....
Hi Satya What I realized is that importing 40k-50k records (with 10-15 columns) into a staging table using BULK INSERT take 2-3 seconds. Once the...
Database will grow with each import process which will insert 20k-30k records (7 columns) in these each table. And there will be around 40-50 such...
Can someone please answer these questions?
The query is regarding data modeling for core functionality of my application. I have a scenario where multiple users will be doing import...
Separate names with a comma.
