Adi's solution fails for strings with trailing spaces.

Try it for @String ='1.2.3 '

To make it work replace "len(@String)" with "DATALENGTH(@String)/2"

Use "/2" only if @String is Nvarchar value, if it's just...

New tools make solutions more complex and less effective.

😉

Here how would it look with "classic" SQL:

SELECT DocNo

FROM #Docs QE

WHERE LStatus = 'QE'

AND...

Most likely the command launched by xp_cmdshell has some problems executing on one of your sites.

It may be access privileges, enviromental variables, anything else.

Command may be just waiting for Y/N...

The easiest way, as for me, would be creating a scalar function which whoud accept a string as a parameter and return a numeric value.

Function should parse the string and...

CONVERT(float, [DatetimeValue])

With little help from Calendar table you may add the days which did not have any hours recorded:

-- Create temporary table

IF OBJECT_ID('Tempdb..#PontoRegistos') IS NOT NULL

...

rootfixxxer (10/26/2010)

---

I need to know what would you do if you need to get from the db that kind of data, like i said the user can define in the...

CASE WHEN SIGN(@Value) = -1 THEN '-' ELSE ....

Basing on the data sample from the article I built a "chart dependency" table which reflects different levels of subordination:

CREATE TABLE dbo.EmpChart

(

EmpIDint FOREIGN KEY REFERENCES dbo.Emp(EmpID),

BossID int FOREIGN KEY REFERENCES...

Which way Capricorn is recorded in your table?

This option affects only new/recreated indexes.

Try to use DBCC INDEXDEFRAG instead of rebuilding indexes.

Funny part - you don't need dynamic SQL at all.

This should work with no problems (if you add parameters @usersList and @eventTypeList to the procedure 🙂 )

ALTER PROCEDURE dbo.mytestproc

...

Actually your original approach was more efficient:

AND (@Company is null OR PM1.PM70.Company_List.Company_Name = @Company)

Does it work?

That's the question to the customer, not to this forum.

There is no point to discuss an implementation if it's not clear how customer wants to see it.