Gift Peddie (4/9/2009)

---

What exactly is...

Chris Morris (4/9/2009)

---

Don't forget a tally-table version!

DECLARE @Untrimmed varchar(50), @Trimmed varchar(50)

SET @Untrimmed = 'HaveNow!/7896-7'

SET @Untrimmed = 'HaveNow'

--

SELECT @Trimmed = LEFT(@Untrimmed, (SELECT ISNULL(MIN(n.number)-1, LEN(@Untrimmed))

FROM Numbers n

WHERE n.number <= LEN(@Untrimmed)

AND NOT...

I'm also learning every day here... 😉

I would try to...

Hi

@rob-2

Thanks for sample data! 😉

Try this:

DECLARE @test-2 table (NameTrim varchar(20))

---Populate with gumpf

insert into @test-2

select 'jones/1234' union all

select 'Jones-1234' union all

select 'McDonald/56780' union all

select 'Goddard-098765'

SELECT LEFT(NameTrim, PATINDEX('%[0-9_/-]%', NameTrim) - 1)

...

Hi Eswin

I didn't know that option. Thanks also from my side!

Greets

Flo

Hi

In Management Studio Object Explorer select your table "dbo.INVENTDIM" expand the node and expand the "Indexes" node there should be an index called "I_698DIMIDX". Right click and select "Script Index...

Hi

What about permissions?

Greets

Flo

Hi

Maybe my English is too bad, but could you explain me the difference between "median" and "average"?

Edited: Or I just don't get it... 😉

Greets

Flo

Jeff Moden (4/8/2009)

---

Florian Reischl (4/8/2009)

---

So here is my formatting function 😉

It's another concept than Lowell's but might also help in some cases. Keep in mind, if possible use CONVERT due...

Greets 🙂

""Msg 2601, Level 14, State 1, Line 1

Cannot insert duplicate...

Create stored procedures containing your queries and use the ENCRYPT option so they will no be available for anybody at the server. Now create a job which just executes the...

Hi kevin

I think the main problem will be the duration of your queries in combination with a web front-end due to the server timeout.

The only way would be a AJAX...

Have also a look to this thread:

http://www.sqlservercentral.com/Forums/Topic692679-338-1.aspx

Greets

Flo

As first thanks a lot to Lowell for formatting the sample data!!

So Nuts, try this:

DECLARE @DrugDates TABLE

(

Drug_Name varchar(30),

Year int,

Quarter varchar(30),

...

Hi sward

Thanks for DDL and sample data ;-).

Try this:

DECLARE @wce_ilr TABLE (

[COMPANY_Contact] [varchar](50) NULL,

[company_name] [varchar](50) NULL,

[Learner_Name] [varchar](50) NULL,

[Learner_Surname]...