Duplicate rows in a result set can be caused by things like, in correct joins or perhaps the joins are correct but in one table you have a single row...

in the SQL the parameter passed is varchar(150) ,so the datatype wont change, the oppo only asks if the parameter is null populate it with this value, so there wont...

• This reply was modified 5 years, 10 months ago by SGT_squeequal.

you can also use isnull function

Update APFinal

Set Comments = isnull(@Comments,  'No Comments Provided')

Where DocID = @DocID and ID = @ID

My primary role is data migration and i use both SISS and T-SQL, I use the tool i find the most appropriate for the task i'm trying to achieve. That...

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d6d51f6e-c01b-4880-abb2-4f0cfd1f4531/extended-event-trace-on-event-rpccompleted-not-capturing-sqltext-action-unable-to-retrieve-sql?forum=sqldatabaseengine

this may help however if you want to do this for a short period you could use profiler

is this a SQL or Excel question?

Char(9) is a horizontal tab and has a Ascii value of 9, select '' yields null

select ascii(char(9)),ascii('')

what are you explicitly trying to do? are you looking where your column is...

Before changing your maxdop read this https://support.microsoft.com/en-us/help/2806535/recommendations-and-guidelines-for-the-max-degree-of-parallelism-confi

ideally we would need a create table and test data to help however, here is something for you to try

Create table test (col1 int, col2 varchar(10))

insert into test (col1,col2)

select 1,'TEST123'...

you could try un pivoting the data, something like this

select invoiceID,prov as provider,amount from (
SELECT *  
   FROM Testdata ) p
UNPIVOT  
 ...

• This reply was modified 6 years, 1 month ago by SGT_squeequal.

this just gets better, they don't know!, what kind of software company doesn't know what the application does and why it does it.

This to me is a real security risk,...

i can't think why any application would need access to the master database, i would avoid using SQL Express because of the limitation on resources. I would push back to...

• This reply was modified 6 years, 2 months ago by SGT_squeequal.

if you want to preserve a small  number of rows in a table then to speed up the delete process you could. for example lets say you have a large...

if you can provide your raw data in the format it is on your DB then we can assist more. that said google pivot tables, if all you are doing...

you have duplicates in 0, instead of a loop id create use a CTE using Row_number() to eliminate any duplicates

with cte as
(
 SELECT t.*,rank() over (partition by...