just a quick question, have you checked it without file format?

All the question you have asked means you yet to get to know the working of sql server. i have share you some links to understand what is what. understanding...

have you checked the execution plan? which will show what exactly is happening behind the sense.

try the recompile option with timeout query. Do check your statistics are properly updated....

a sample set and desired output will help to identify your actual scenario.

nice question. Thanks for sharing

nice question. it get a lot easier if you Remember the Msg 2749, Level 16, State 2, Line 1 error message.

Thanks for sharing.

hmmmm .... it can also be named as Theory of Everything 😛

nice question and thanks for sharing Eirikur.

In addition to the Eirikur response, Please also share what working you have already done against it so far for the problem your are facing.

good question. reminded me some old thoughts 🙂

Nicely put. thanks for sharing the question. this will certainly bust few myths 🙂

nice question. good basic knowledge.

thanks for sharing

excellent question have to give a thought before answering it. Thanks for sharing

how much time this procedure if you execute it. Its an awfully long transaction which mean if this procedure is running in the background then it will lock all the...

Another word of caution, as long as you have numeric values in your columns then it will work. But what if you have Alphabet in your data.

Consider the following scenario:

cola...

When you say this

What is the data type of column [TBL_whole_rock_geochem].au column. because following can also generate the error. Consider the following...