Hi all, thanks for all interesting replies. The practical reason is to work at the transaction log level. For updates, the transaction log has this uniquefier number to represent...

Okay...  I know that the term "lakh" is a large number, but let's go ahead and have you state exactly how many 2o of those is in English units, meaning...

Seems also likely that not being able to see that you are a top poster in a forum might have taken the recognition value out of responding to existing posts.  ...

Disadvantage to exporting to Excel from the SSRS site is that you get a static output of the report.  Nice thing of Power Pivot is you can click a...

It would depend on exactly how the BCP process was coded.  Without any of the details on the destination table or even an example of 1 row of an import...

Nice find, Brian.   An excellent article that demonstrates that the uniqueifier value is unique within a given set of otherwise duplicated values, from the point of view of the index...

Brian,

Seems like it would probably be easier to just export the report in Excel from the URL in your browser.   Have to admit I've not touched Power BI yet,  and...

There is a similar icon present in the browser rendering (Firefox) on my Windows 10 Pro laptop.   It's in the upper right, in a gray-colored bar above the forum content.

I've created VB.Net desktop applications that render an SSRS report that is on the SSRS server, using an extension to Visual Studio that allows an SSRS Report Viewer Control to...

Can you provide an example of what any given line in this file looks like?   Also, what, exactly, is an "adnominal space" in this context?

I'm not at all sure how the rows you show as output:

Black Paint 540

Blue Paint 360 50

qualify as being in the format you're specifying:

Name <45  45 To 60  60 To...

Can you provide an example of such a table, using DDL and some INSERT statements?    Also, why would you not add your own such column to such a table?

Also, in addition to Brian's advice, take a look at this snippet of code that is a JOIN condition:

CAST(Wh_Store.StoreType as nvarchar(10)) in (2,4)

Why convert a column to...

Without a fair amount of sample data, replicating your problem might be difficult because 20 lakh records is a ton of data.  We at least need a better idea of...

Oh for crying out loud, Joe...   just because the poster might not have the best skillset for what they are trying to accomplish, doesn't mean you should insult them.   Try...