antonela (6/20/2014)

---

Is there a funcion in sql server 2005 to obtain this result?

For a number =0,55 I want to have 1

For a number =0,45 I want to have 0

For...

As the set has only one divisor (codcategory) and there is no requirement to preserve...

Jeff Moden (6/19/2014)

---

My problem is that I really don't understand what you're trying to do. This start out with "counting characters in a string before a space" and I...

OCTom (6/19/2014)

---

GilaMonster (6/19/2014)

---

So what's his motivation...

Yet two more ways

😎

USE tempdb;

GO

DECLARE @TSTR TABLE

(

TSTR_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED NOT NULL

,TSTR_VALUE VARCHAR(50) NOT NULL

);

INSERT INTO...

Another of many

😎

DECLARE @STR_A VARCHAR(50) = '1.9999-Q1'

;WITH STR_POS AS

(

SELECT

CHARINDEX(CHAR(46),@STR_A) AS P1

...

Is it something along these lines that you are after?

😎

SELECT

TBO.schedule_time

,'OPEN' AS open_closed

FROM

(

SELECT

...

Many ways of doing this, here are two quick examples. BTW, thanks for the nice DDL/sample.

😎

Slightly long winded pre 2012.

;WITH LIC_TYPE AS

(

SELECT

TL.ID

,ROW_NUMBER...

I see steadily increasing demand for SQL Server professionals, it is the de facto database platform for small and medium enterprises, and one of M$ best money buckets.

😎

Further on Jason's advice

😎

USE tempdb;

GO

create table dbo.names (Place varchar(50));

insert into dbo.names ( Place) values ('(1)');

insert into dbo.names ( Place) values ('(100)');

insert into dbo.names ( Place) values ('(200)');

SELECT

...

Lynn Pettis (6/18/2014)

---

Grant Fritchey (6/18/2014)

---

SQLRNNR (6/18/2014)

---

jasona.work (6/18/2014)

---

GilaMonster (6/17/2014)

---

Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"

"No pressure to...

raju.venkatsv (6/18/2014)

---

Thank you for your quick reply.

request you to provide some hints or some information , using which i can update my trigger to meet business requirement.z

requesting you for...

mickyT (6/16/2014)

---

One to make you smile if you have 2012:-)

DECLARE @smiley varchar(20) = 'Dont Worry Be Happy';

WITH Params AS (

SELECT MAX(CASE WHEN ItemNumber = 1 THEN Val END) OFFSET,

MAX(CASE WHEN...

trikha.ishan (6/18/2014)

---

Hi,

I tried to update the .dtsx file using notepad in development server and that change is in Script Component but when I ran the package that change didn't reflected...

Thanks!

😎