Lynn Pettis (12/11/2012)

---

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...

Myself and a colleague are having some problems with replication. To be honest, replication is something I've had very little to do with so I'm at a loss with trying...

My hope is that Jeff Moden won't take um-bridge to my ripping apart of his code. . . 😀

I've based this answer on the 8K splitter[/url], with some modifications to...

CLR. If you mean native, then no.

Your first post about this

Your second post about this

Your third post about this

Your fourth post about this

So this one makes five posts. . . Can I offer a suggestion? One...

karthik M (12/10/2012)

---

create table emp

(

last_name varchar(50)

)

insert into emp

select abc_worldbaank

union

select xyzabc_countrybank

union

select yyybb_districtbank

union

select zzzaaa_internationalbank

my requirement is to display the text after '_'

worldbaank

countrybank

districkbank

internationalbank

I used two method

1) select substring(last_name, charindex('_',last_name), len(last_name) - charindex('_',last_name))

--...

Have you had a read through this --> http://www.manning.com/nielsen/SampleChapter5.pdf ? The sample chapter that I linked shows the "guru" method for performing...

This is the Islands and Gaps problem.

As this is a university project, I won't just give you the answer. However, take a look at this --> http://www.manning.com/nielsen/SampleChapter5.pdf.

Why do you need a cursor for this?

Here's your sample data: -

CREATE TABLE MNFC (Col_1 VARCHAR(5),Col_2 VARCHAR(3),Col_3 VARCHAR(6));

INSERT INTO MNFC

SELECT 'Sales','Yes','12-Jan'

UNION ALL SELECT 'Prod','Yes',NULL

UNION ALL SELECT 'Mark','NO','15-Jan'

UNION ALL SELECT 'Finc',NULL,NULL;

So...

I didn't realise...

SELECT ENAME

FROM test

WHERE PATINDEX('%[[[]AFG]', ENAME) > 0

OR PATINDEX('%[[[]USA]', ENAME) > 0

OR PATINDEX('%[[[]IND]', ENAME) > 0;

Results in: -

ENAME

------------------------------

Afghanistan [AFG]

United States [USA]

India [IND]

United States [USA]

SELECT SUBSTRING(ENAME,PATINDEX('%[[][A-Z][A-Z][A-Z]]', ENAME),LEN(ENAME))

FROM test;

Results in: -

------------------------------

[AFG]

[BRA]

[USA]

[FRA]

[IND]

[DZA]

[DZA]

[USA]

[BGD]

Can...

Not without more information, no.

I can tell you that the generated query is awful. Of the top of my head, try this instead: -

SELECT CAST(ISNULL((SELECT TOP 1 1

...

Have a read of this article --> http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D, about how to post performance problems.

Interesting. Something like this maybe: -

SELECT 'CREATE '+CASE WHEN IndexProperty(TableId, IndexName, 'IsUnique') = 1 THEN 'UNIQUE '

ELSE '' END+CASE WHEN IndexProperty(TableId, IndexName, 'IsClustered') = 1 THEN 'CLUSTERED ' ELSE...

steve.bavis (12/7/2012)

---

I am using an INSERT INTO statement to enter data into a table. There are only 3 columns. The first two are foreign keys, the last is the actual...