Sorry George, I might...

Dear J Miller,

Please click the link at the botom of my signature. It will help you to present your question in a right way. I believe you will quickly get...

Have you ever updated statistics on this table? 😀

try:

;WITH selDates

As

(

SELECT clientID, DATEADD(month, -6, MAX([date])) as Date6MAgo

FROM trans group by clientID

)

SELECT T1.transID, T1.clientID, T1.[date], T1.note

FROM trans T1

JOIN selDates...

DDL Script to setup a table and some data would be helpfull.

Please click on the link at the bottom of my signature to find how the question should be...

Morteza,

Hornestly, I believe that your question is not really for a forum discussion. It is too many factors which would determine the best solution for your company. Without knowing...

Gopal Rathore (6/25/2010)

---

Which is better to have either Numeric Candidate Key or Composite Key in the dependent table to make joins faster to execute say for example I have FormulaId...

Your query indeed renders the required XML. However, using subselects will cause to many scans and reads. I have modified my one to render the required XML for you. You...

I can't see any problem there:

declare @t table (val nvarchar(50))

insert into @t select '-95469.49'

union select '-92565.24'

union select '-90384.38'

union select '-89245.69'

union select '-88976.89'

union select '-88976.89'

union select '-82735.84'

union...

Ninja's_RGR'us (6/28/2010)

---

Visitors are only 1 part of the equation. You still have to sell all the ads, which is harder than it seems.

The facebook guy was deemed the...

select cast(replace(replace(replace('(-10,299.00)', '(',''),')',''), ',','') as decimal(18,2))

Do you have brackets? Can you show exact value you are trying to convert?

Ninja's_RGR'us (6/28/2010)

---

...

That works... only 1 problem here, you need to have a single shared "memory" on the web server for all the executions. Then you need to batch process...

Ninja's_RGR'us (6/28/2010)

---

...

Just keep in mind that in most cases, logging takes far less ressources than actually showing the page(s) and querying the data to do so ;-).

...

Further keep in mind...

By the way, my SQL Express manages to insert 10000 records into the table in around 15 milliseconds. So, if you like you can allow your web site to be...

Of cause NO.

They just GOOGLED it out! 😀