I'm not sure where the 'sample' label is coming from, but you can use a pivot to get your results

declare @vs_string varchar(max) = 'create table #T (Name varchar(10), Code varchar(10),...

IMHO, I think using one table for all lookups gets real ugly real fast. I'd much prefer having a separate lookup table for each lookup. It is easier...

Dan,

we have a very similar process. Our heavy loads average around 1000 inserts/second and have never had an issue with the primary ley violation. Can you post the...

Your results don't match the sample data. I looked at itemid 1105 and I'm not sure where your numbers are coming from. I also don't understand what results...

CREATE TABLE #Customer

(CustID INT, CustLastName VARCHAR(30), DOB DATETIME

, Addr1 VARCHAR(30), Addr2 VARCHAR(30),...

Chuck,

I'm not sure I understand what you are saying. I ran this against the AdventureWorks database and the sorting was as I expected. Hardcoded or dynamic. Can...

what exactly is your question? Have you tries BOL?

One of the scripts that we use is to create and load data into a work table with the same layout as the partitioned table. Then when the loading...

It would be alot easier for us to help you if you provided some table layouts, sample data and expected results. From what I can see, you're going to...

How about getting the first record in the temp table since the identity column is being used. Something like this

declare @TopElementClassCode varchar(30)

...

I modified your temp table and then performed a 'quirky update' to get the DataRowID. You'll have to test this with the volume of data you described.

DECLARE @p_FileData ...

don't forget the where clause or all of your records will be the same 😉

Did you try using the machine name or DNS Alias instead of the IP Address? You should use the IP Address if possible, since they can change. If...

Hai

cast the PercentRecon and tot_100pervisitcnt to 0 will make...

can you post the table script and some sample data?