Pritz (3/28/2014)

---

I have four fields:

FirstName varchar(20),null

MiddleName varchar(5),null

LastName varchar(30),null

Position int,null

How to concatenate all these four fields to give result as Name?

I tried this but it is not working properly.

select

LTRIM(RTRIM(isnull(Person.Lastname,' ')+','+isnull(Person.Firstname,'...

Not a bad rule of thumb but as you can see...

sku370870 (3/28/2014)

---

I have done that sort of thing before. I might have had, say, 6 various sort conditions to satisfy and I have written as you suggested. So, effectively you...

sku370870 (3/28/2014)

---

But, isn't that not a 'catch-all query'? It hasn't got any ... WHERE (ProjectID = @ProjectID or ProjectID = 0) AND (ContractType = @ContractType or @ContractType = '') ......

No need to be embarrassed at all. This whole sql thing is...

Bob McClellan-320407 (3/28/2014)

---

This should get you there...

Create

ProcdynaSort -- exec dynaSort 1, 'DESC'

@SortID int,

@SortDirection char(4)

as

If @SortID = 1 and @SortDirection = 'ASC'

Begin

--Put your query and correct sort...

The...

This screams of a catch all query. Performance for this type of thing is likely to seriously stink unless you handle it correctly. Take a look at Gail's blog post...

Annee (3/28/2014)

---

When I change

Convert(datetime, GetDate(), 101) to

Convert(date, GetDate(), 101)

I see following error:

'Type date is not a defined system type.'

Sorry I am actually using SQL server...

buddy__a (3/28/2014)

---

Msg 1781, Level 16, State 1, Line 1

Column already has a DEFAULT bound...

The point is to make it easy for us volunteers to help. I really don't want to download several zip files and do a bunch of stuff setting up the...

buddy__a (3/28/2014)

---

Can you elaborate on what the problem is? I assume you must be getting an error message? What version are you running?

What you posted has no primary key and...

That is the edition not...

samalex (3/28/2014)

---

Merge would probably work, but you'll need to run this for each historical day to get caught-up then each day after that. Here's an example given your dates...

This looks to be a pretty traditional islands and gaps problem. Take a look at this article. http://www.sqlservercentral.com/articles/T-SQL/71550/%5B/url%5D