Jeff Moden (4/5/2013)

---

deepzzzz (4/5/2013)

---

Thanks Sean for your post..

For this example it works fine..

Just consider these examples...

'US Eastern District Court'

'Southern District Court of US'

For this also it is giving the...

you're welcome.

So you are asking how can we format the t-sql so it looks nicer?

There is no way to do that in SSMS. There are however a number of 3rd...

I don't see anything hugely obvious here. Unfortunately there aren't a lot of details either. Take a look at this article about how to best post questions about performance problems....

sej2008 (4/4/2013)

---

I have just started to go through reporting services in sql 2008.I used some of the wrox ebooks on reporting but could not find proper examples in it.can anyone...

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1438955-1292-1.aspx

jbalbo (4/4/2013)

---

Hi

Kind of a dumb ???

Sometimes I will take a sp and play with it in a view

once I copy the code the tables are all over the place

is...

ScottPletcher (4/4/2013)

---

SELECT RefNumber

FROM #Data d

GROUP BY RefNumber

HAVING

COUNT(DISTINCT EntryType) = 3 AND

MAX(CASE WHEN EntryType NOT IN ( 0, 2, 11 ) THEN 1...

adesai 26520 (4/4/2013)

---

If I am not mistaken, the command just replaces/removes the spaces, and the user wants to separate the word from a sentence and add single word to the...

This is almost identical to another thread.

http://www.sqlservercentral.com/Forums/Topic1438875-391-1.aspx

Since you are brand new around here I create the ddl and sample data for you.

if OBJECT_ID('tempdb..#Data') is not null

drop table #Data

create table #Data

(

RefNumber int,

EntryType tinyint,

EntryAmount int

)

insert #Data

select 239000,0,200 union...

It would much better if you could post your ddl and sample data in a consumable format. (create table and insert statements)

Also, are there any more rules or is this...

adesai 26520 (4/4/2013)

---

May be this will help

________________________________________________________

declare @word varchar(125) = 'The Quick Brown Fox Jumps over a lazy Dog'

declare @swrd varchar(100)

declare @l int

while len(@word) > 0

Begin

set @l = CHARINDEX('...

like this:

select ShipmentID, ProductID, ProductType,Qty

from YourTable

where ShipmentID not in

(

select ShipmentID

from YourTable

where ProductType <> 2

)

You can also use sys.databases to build a string for you.

For example if you wanted to select * from MyTable on every database you could do something like this.

select...