mario.balatellii (12/7/2011)

---

sorry mike i may sound stupid but where do i get object dbo.Split. and second question is that declaring @message get only on row but in my table if...

You can certainly do this with TSQL - using the splitter Gianluca mentioned - but it's an expensive long-haul trip:

DECLARE @Message VARCHAR(8000)

SET @Message = 'Type=0 8=111 9=HSBC 35=d 49=DAC 56=ALA...

If you're looking for a fixed percentage of random rows from each partition (salesperson), have you considered using NTILE?

SELECT

*

FROM (

SELECT *, NTILE(10) OVER(PARTITION BY Salesman ORDER BY NEWID()) AS...

Wasn't...

drew.allen (12/6/2011)

---

ChrisM@Work (12/6/2011)

---

Now imagine you're writing a query to output cleaned title, firstname, lastname from a table of appallingly bad data. You've set up a shedload of detection and cleaning...

drew.allen (12/6/2011)

---

ChrisM@Work (12/6/2011)

---

drew.allen (12/5/2011)

---

ChrisM@Work (12/5/2011)

---

You might get one or two ideas from the following. It's proving very usable for data cleansing, which is similar to your scenario - you want...

Cool, thanks for the feedback. I learned the trick from an article Lowell did years ago 😀 Thanks, Lowell.

Plus 30 mins to round up:

SELECT CAST(DATEADD(hour,DATEDIFF(hour,0,DATEADD(minute,30,GETDATE())),0) AS TIME(0))

Duplicate post, work in progress here.

Duplicate post, work in progress here.

Perhaps usage is supposed to be like this:

DECLARE @streamid VARCHAR(5)

SET @streamid = '519'

SELECT @streamid

FROM (

SELECT streamgroupid = '%,519%' UNION ALL

SELECT '%,519,%' UNION ALL

SELECT '%519,%' UNION ALL

SELECT '%519%'

) d

WHERE @streamid...

pallavi.unde (12/6/2011)

---

Below is the query in my store procedure..

SELECT .....

where b.coursetypeid=@CourseId and b.degreeid=@DegreeId

and b.streamgroupid LIKE '''%,'+@streamid+',%'''

and b.streamgroupid LIKE +@streamid+',%'+''

and b.streamgroupid LIKE ''+'%,''%'+@streamid+''

and b.streamgroupid LIKE +@streamid+'%'

end

query is running...

Put an index on your temp table. SQL Server will jump through fewer hoops creating the INSERT source.

CREATE --UNIQUE

CLUSTERED INDEX [CXscn] ON #glxRDCount (scn ASC)

drew.allen (12/5/2011)

---

ChrisM@Work (12/5/2011)

---

You might get one or two ideas from the following. It's proving very usable for data cleansing, which is similar to your scenario - you want to identify...

You might get one or two ideas from the following. It's proving very usable for data cleansing, which is similar to your scenario - you want to identify a case...