How I've dealt with getting a set of unique identifiers ahead of time is to insert a dummy row into your iterating table (#RIN_Table in your example) and then use...

Depending on what's in between ElasticSearch and SQL, a rudimentary .Net application can quite easily de-serialize the JSON before putting it into SQL.

you can also join out to sys.index_columns

select

TableName = object_name(i.object_id),

IndexName = i.name,

ColumnName = col_name(i.object_id, ic.column_id)

from sys.indexes i

inner...

;with LikeList (string) as

(

select 'Bob' union all

select 'Jane' union all

select 'Bill'

), sourceTable (string) as

(

select...

Sorry, I missed that part. But similarly to how you can group on the derived column for the Tariff Group, you can group on a derived column for the month....

I'd use a computed column (or if you dont want to use a temp table, you can just select the expression) to define whether the tariff rate is "X" or...

Hi Blyzzard,

Can you please provide the table structures of both tables (including their primary keys) as well as some sample data?

SOUNDEX is one option, albeit not a great one. you might be able to get clever with it to get you close enough. You could pipe the results through a...

I wish there were a precise answer I could give you, but there are a lot of unknowns (including what the actual table structure, existing indices and data look like),...

Couple things.

First and foremost, you're not going to know how a SQL call scales to "very large" table sizes with table variables. Table variables by nature have no statistics built...

If you want to go the string split route, you might as well go all out. If you want to read through it, I'd check out this article, but the...

Since I obviously don't have access to your tables, I'd double check this does what you anticipate, but here's how I'd rewrite the script to do this as set based...

You can try converting the string to varchar or nvarchar to see if meaningful text comes out, but that assumes meaningful text was put in in the first place. If...

I need to stress here that I'm making several leaps of logic about your database schema.

The primary keys of table1 and table2 plus the rules of how each are...

Would this work?

insert into table2

select

emplid,

applicationid,

programid

from table1 a

left outer join table2 b

on a.emplid = b.emplid

...