RVO (9/23/2013)

---

Dear Sean Lange.

You really are SSChampion !!!!!

It runs in 1 sec now !!!

Wow.

I just need to understand what is the trick

and what was wrong with my old code

because I...

GilaMonster (9/23/2013)

---

And now that the paperwork has been signed....

November it's good bye consulting, back to full time grind. Starting at a software development house as a technical lead. Focusing on...

golansimani (9/23/2013)

---

I don't have a problem to get a random month or a day I just using this :

UPDATE table_a

...

Totally a shot in the dark because we don't have much in the way details...

See if this helps.

SELECT p.RollupAllProjectsCommittedTotalCost * CASE WHEN RowNum = 1 THEN 1 ELSE 0 END,...

Based on your screen shot and the description this sounds like a search criteria based on the values the user wants to use as their criteria. This is a very...

See if this makes things any better.

FROM

vwNzEmpNonPrjTime e

outer apply getValuesAsTable(@L_ORG, ',') o

outer apply getValuesAsTable(@L_EMPLOYEE, ',') et

WHERE

co_code = @L_CO_CODE

AND (CHARINDEX('**all**', @L_ORG) > 0 OR o.org_code = o.[SomeColumn])

AND (CHARINDEX('**all**', @L_EMPLOYEE)...

Check out the link in my signature about splitting strings. In there you will find a way to do this very easily and fast.

Your code might be as simple as...

stevewes (9/23/2013)

---

Hi Sean,

That is great info, yeah the info needs to be real time our Help desk ticketing application gets lots of email request into a particular table and seem...

ramyours2003 (9/23/2013)

---

I want to change the identity of the column to false when the column is primary key , how to change the identity property is to be False in...

stevewes (9/23/2013)

---

yeah this is a great help many thanks!!!

next step is to I suppose create a Job with the SQL query in as a step the next step is how...

p.avinash689 (9/23/2013)

---

Hi All.

i have to tables like patient table with columns(patient name, DOB,Age,Sex) and table2 with column (regno).

i want to insert the registration number as first 3 characters of...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

stevewes (9/23/2013)

---

Hi, how do I do this ?

my select statement goes something like this

Select count(*) AS EMAILQFULL,column name from tablename

group by column name

this returns the number of rows in...

Instead of this, read the article that Jeff suggested. The approach...

slpgma (9/23/2013)

---

Unfortunately I am not able to release the design of the Person table. But what I can say is that the table will only have a couple of...