This should help you to post the information needed.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

That's because your column Code is larger than your column Csimplecode.

If you provide DDL of your table, I could give you the exact code, but you basically need to...

You might need to do an update on all fields.

Something like this:

UPDATE MyTable

SET column1 = LTRIM(column1),

column2 = LTRIM(column2),

column3 = LTRIM(column3),

--...

...

I'm thinking that you might want to include "business hours" on weekends. The easiest way to do it would be using DATEPART. However, you might encounter with the problem of...

Your code doesn't seem to exclude weekends, it only excludes hours. Since hours can happen in any given day, you're excluding those hours on weekends as well.

Technically, it's a single query and there's no IF..ELSE. 😀

That's an ugly db design.

Here's a possible solution.

DECLARE @idEmployee int = 3

SELECT TOP 1 MyAddress

FROM(

select 1 Priority, MyAddress

from #Address a

WHERE EXISTS( SELECT 1 FROM #Emp e

WHERE a.idCompany =...

I can't find the reference (so I might be wrong), but I'm sure you can't assign values from a function when declaring parameter defaults.

EDIT: Reference seems to be only for...

I'm sure he meant that...

What about giving us the complete scenario? You say this is a result of a FULL JOIN, but you might not need it if it's a self join.

Please post sample...

If you haven't changed the query, then the data might have changed. Verify that as you might be in trouble.

I'm glad I could help even if it wasn't a complete solution for you, but at least you got an idea that worked for you. And it's even better that...

Is there any reason to use a JOIN when CROSS TABS will work fine?

SELECT Item,

MAX( CASE WHEN Category = 'Small' THEN Value END) ,

MAX( CASE WHEN Category = 'Large' THEN...

Do you have continuous dates? Or you might have gaps?

Here's a possible solution, but I don't know if it's the best.

WITH cteLots AS(

SELECT *,

ROW_NUMBER() OVER( ORDER BY lot_nbr) rn,

ROW_NUMBER() OVER( PARTITION BY lot_OwnerID ORDER BY lot_nbr, lot_nbrDec)...