CELKO (8/15/2012)

---

Now we have to fix the bad schema with DML. Look up the new CREATE SEQUENCE statement and use it. Here is an untested attempt:

WITH Corrected_Tests (device_id, test_value, device_test_seq)

AS

(SELECT...

Test mine 😉

Your code: -

IF EXISTS...

Total guess, no testing has gone into this: -

CREATE FUNCTION [dbo].[fn_QBRemoveNonAlphaChars] (@String VARCHAR(1000))

RETURNS VARCHAR(1000)

AS

BEGIN

WHILE PATINDEX('%[^a-z ''-]%', @String) > 0

SET @String = STUFF(@String, PATINDEX('%[^a-z ''-]%', @String), 1, '')

RETURN @String

END

You had the...

The UNIONs that some have posted are part of creating sample...

Luis Cazares (8/15/2012)

---

DECLARE @Tabletable(

idint,

device int,

value int)

INSERT @Table

SELECT 9, 456, 70 UNION ALL

SELECT 8, 456, 60 UNION ALL

SELECT 7, 123, 70 UNION ALL

SELECT 6, 123, 60 UNION ALL

SELECT 5, 456, 50...

scott_lotus (8/15/2012)

---

I am trying to write a script to read the current row and previous row per device and work out the difference reporting values over X (> than 20...

I don't believe so. Normally I'd just test it,...

I guess this might work: -

EXEC master..xp_CMDShell 'c:yourFile.exe'

Out of curiosity, does this correct your issue?

DECLARE @str NVARCHAR(MAX);

SELECT @str = STUFF((SELECT CHAR(13) + CHAR(10) + csvFile

...

cms9651 (8/14/2012)

---

Format number thousands separator with point

Hi there, I need your help.

I have this number in my database output result of query:

1013473

I need this output: 1.013.473

Can you help me?

Thanks...

Apology accepted, I...

That's redundant.

using System;

using System.Data.SqlTypes;

using System.Text.RegularExpressions;

namespace TrimTrailingLeading

{

public class UserDefinedFunctions

{

...

Eugene Elutin (8/10/2012)

---

try to return

(SqlString) s.Value.TrimStart('0').TrimEnd('0');

instead of

new SqlString(s.Value.TrimStart('0').TrimEnd('0'));

what about Regex?

Don't forget to create static Regex object instead of instance in the function.

To remove leading...

CLR Version 1:

using System;

using System.Data.SqlTypes;

namespace TrimTrailingLeading

{

public class UserDefinedFunctions

{

[Microsoft.SqlServer.Server.SqlFunction]

...

dwain.c (8/10/2012)

---

I'm thinking the winner has more to do with the number of zeroes replaced because I got quite a variation on results for this.

For overall terseness, I kinda like...