Viewing 15 posts - 1,801 through 1,815 (of 2,894 total)
jp.v (3/23/2012)
Eugene Elutin (3/23/2012)
I wonder what reasons forced you to use this SP?
Direct...
March 23, 2012 at 10:34 am
SELECT TOP 10 ...
There is an article about it, link at the bottom of my signature.
March 23, 2012 at 10:27 am
njdevils39 (3/23/2012)
select em.emp_name, em.emp_organization, em.emp_department, eo.rate_history
from
employee as em
join
employee_other as eo
on
em.emp_id = eo.emp_id
Now rate_history column is in XML FORMAT in the employee_other table for...
March 23, 2012 at 10:25 am
jp.v (3/23/2012)
- Delete existing in a ref table.
- Insert New in that same ref table.
It's easy to do in two requests, but i'm forced...
March 23, 2012 at 10:04 am
You don't need MDS to create and compile c# code...
http://blogs.oberon.ch/tamberg/2007-10-17/compiling-csharp-without-visual-studio.html
March 23, 2012 at 9:53 am
SAMPLE DATA, should include data!
We don't have the data in the table your are selecting from (actually we don't have any of your tables :-D)
Please follow the link at...
March 23, 2012 at 9:50 am
pwalter83 (3/23/2012)
Hi,I have a requirement to add columns (varchar) where data is separated with a colon (:). For e.g.
115:32 and 34:28
160:00 (hrs and minutes).
Thanks,
Paul
I would suggest to store your...
March 23, 2012 at 9:47 am
One of the culprits to check that happens alot is the connection's setting of ARITHABORT. SSMS defaults to ARITHABORT ON, but .Net connections default to ARITHABORT OFF.
... meaning that...
March 23, 2012 at 9:36 am
...
Object oriented COBOL is a perfect example of what we talking about. Yes it can be done, but that does not mean it is a good idea...
It is not as...
March 23, 2012 at 9:32 am
...
It is a paradigm shift that is difficult for some to make, sort of like moving from 3rd generation programming languages like COBOL to object-oriented languages.
Is it really such difficult?...
March 23, 2012 at 9:07 am
It may be possible to re-design your stored proc in such way that it can be executed for the whole table (or required dataset)...
If not, cursors in T-SQL are mainly...
March 23, 2012 at 9:04 am
When you state 30sec in UI vs 1sec in SSMS, are you talking about complete resultset returned and displayed in both cases or, in case of SSMS you can see...
March 23, 2012 at 8:45 am
... make sure you declare your variables outside the loop.
yeah, it is widely used practice by T-SQL programmers.
However, from performance prospective, it never was any difference as the query optimizer...
March 23, 2012 at 8:18 am
Network?
Bad code?
Could be anything...
Have you tried DBCC FREEPROCCACHE ?
March 23, 2012 at 7:57 am
Sean Lange (3/23/2012)
Please! "Even better, don't use loops."? Why? :w00t:
I do not agree!
If you say that, you should say it right!
OK, don't use loops in general. They tend to...
March 23, 2012 at 7:43 am
Viewing 15 posts - 1,801 through 1,815 (of 2,894 total)