Viewing 15 posts - 2,641 through 2,655 (of 2,894 total)
george.greiner (6/24/2010)
...
It has nothing to do with laziness I did not know what DDL script meant and was researching it =0. Thank you for your help.
...
Sorry George, I might...
June 29, 2010 at 9:29 am
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...
June 29, 2010 at 8:39 am
Have you ever updated statistics on this table? 😀
June 29, 2010 at 8:28 am
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...
June 29, 2010 at 8:19 am
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...
June 29, 2010 at 8:12 am
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...
June 29, 2010 at 8:02 am
Gopal Rathore (6/25/2010)
June 29, 2010 at 7:51 am
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...
June 29, 2010 at 7:31 am
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...
June 28, 2010 at 10:33 am
Ninja's_RGR'us (6/28/2010)
The facebook guy was deemed the...
June 28, 2010 at 10:29 am
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?
June 28, 2010 at 10:14 am
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...
June 28, 2010 at 10:07 am
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...
June 28, 2010 at 9:54 am
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...
June 28, 2010 at 8:57 am
PaulB-TheOneAndOnly (6/28/2010)
...Don't think MySpace got there by posting a simple question in a forum 😀
...
Of cause NO.
They just GOOGLED it out! 😀
June 28, 2010 at 8:45 am
Viewing 15 posts - 2,641 through 2,655 (of 2,894 total)