tom.moore.777 89426 (12/11/2012)

---

Hi, I have encountered an unusual issue where the option to 'Script View as' is missing, however the option to script out other objects exists.

I am aware...

This seems to work:

create table #TestTable(

TestStr varchar(10)

);

go

insert into #TestTable

values ('5+'),('1+'),('3-');

go

select * from #TestTable where TestStr like '%+%';

go

drop table #TestTable;

go

AndrewSQLDBA (12/11/2012)

---

Hello Everyone

I am attempting to query a column that the data has a plus sign. I know there is data, but nothing.

I have tried multiple wildcards, but still nothing...

kounslr (12/11/2012)

---

Steve and Lynn - Both of these are awesome... I'm a bit star-struck by you! 😉 I am a social work therapist by education, so I have been...

Going out on a limb here, but I think it is because the connection is broken (or not established) even though it is not severity 20 or higher:

Errors that have...

Just some food for thought:

declare @TestString varchar(8000) = '30;38469|31;38470|32;38471|33;38472|34;38473|35;38474|36;38475|37;38476|38;38477|';

select

max(case ds2.ItemNumber when 1 then ds2.Item else '' end) as field1,

max(case ds2.ItemNumber when 2...

If you don't count the functions inside the function, this one:

IF...

Just some food for thought:

declare @sample table (id int, [type] char(1));

insert @sample select 1,'A' ;

insert @sample select 1,'B';

insert @sample select 2,'A';

insert @sample select 3,'B';

insert @sample select 4,'D';

with ReqIdsTypes as (

select...

Food for thought:

CREATE TABLE #LOGGING_DATA (

STAFF_MBR varchar(15),

SERVICE_DATE date,

PATIENT varchar(15),

START_TIME time,

END_TIME time,

PATIENT_MINUTES int

);

INSERT INTO #LOGGING_DATA

SELECT 'SUZY STAFF', '06/16/11', 'JOHNNY', '10:00', '10:30', 30 UNION ALL--for staff_mins would count this as 30

SELECT 'SUZY...

The SSC Steelers move on to play Ditka and the SQL Bolts move on to play Orange Engineers in the semi-finals for the championship! On any given Sunday, anything...

prathibha_aviator (12/10/2012)

---

Women Art Revolution (2010)

"!Next?" (1994)

"#1 Single" (2006)

"#ByMySide" (2012)

"#Follow" (2011)

"#nitTWITS" (2011)

"$#*! My Dad Says" (2010)

"$1,000,000 Chance of a Lifetime" (1986)

"$100 Makeover" (2010)

"$100 Taxi Ride" (2001)

"$100,000 Name That Tune" (1984)

Above...

???

Sample data and expected result, please.

Modified my code to update the table:

CREATE TABLE dbo.UpdateGaps(

MachineID int NOT NULL,

RecordedDate datetime NOT NULL,

Pressure float NULL,

CONSTRAINT PK_UpdateGaps PRIMARY KEY...

CELKO (12/8/2012)

---

Getting toasted by me is a ritual of passage in...