This looks like a job for INFORMATION_SCHEMA - specifically, information_schema.columns.

Let us consider the error message:

Conversion failed when converting the nvarchar value 'XXX' to data type int.

On the app side, adding a row to be processed is done by adding a row to the table-valued parameter. One common way to do that is to use a...

Yes, from within the proc there is the exact same 'problem'. However, it is from outside the proc you will notice dramatic performance improvements. Let's say you put 1000 records...

I'm surprised no one hasn't offered...

Why not have a non-unique clustered key of MasterID on detail?

Here is the problem in a nutshell - salary opacity and salary equality.

Demigod of SQL = x$

Seat Filler = x$

Unfortunately, just as much money is allocated by management for the...

In the script, you're selecting into a variable. No matter how many rows there are, the variable only gets set once.

Well, in the spirit of answering the question asked, it'd be pretty easy to create a view that looks the same as the table with schemabinding, and put an INSTEAD...

Gotta stick my 2 cents in - how about this?

update #testTable set class4 = d.class4 from

#testTable a inner join

( select identifier,class4 from

(select identifier,max(asofDate) asOfDate from #testTable group by...

But if you're in a hurry and cannot wait for enlightenment, I suggest you find and download sp_BlitzIndex and run it in table mode on the table in question, preferably...

We had this thingy at work to submit a claim. For a big claim, it might do 30,000-40,000 database calls. So they asks me, "Do you think you might be...

first, try this - you'll need to run it in each database

select * from information_schema.columns where column_name in ('contact_id','contactid',etc.)

That'll give you the names of the tables. If they never change,...

How about

select f.* from fact f where date between @lastYear and @thisYear

cross apply ( select case when (ididivision=100 or iddivision=240) or date>=@thisYearBegin then 1 end) b

Oops, need a commit in there...

begin tran

delete XXX from

select top 50 * from

list a inner join

XXX b on b.key = a.key

commit

While...

You want to do it in batches, in a loop. Since 300 rows takes an hour, you definitely don't want your batch size that big. Try somewhere between 25 and...