Viewing 15 posts - 6,931 through 6,945 (of 8,731 total)
Jeff Moden (2/13/2014)
Luis Cazares (2/6/2014)
There's a simple reason of why would I do this on the front end. Formatting totals and subtotals is a lot simpler that way.
If the front-end...
February 13, 2014 at 8:31 am
That's the nature of T-SQL. T-SQL is a declarative language. It won't follow the instructions in the order that you write them, it will generate a plan to get the...
February 13, 2014 at 8:28 am
If you're updating all those rows, you should consider changing your scalar function to an inLine table-valued function. It will boost your performance.
If you need help on how to do...
February 13, 2014 at 8:19 am
With so little information given, you could check this article: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
February 13, 2014 at 8:16 am
You can still use DTS on 2008 if you want to have more time for migration. You can migrate DTS to SSIS in a phase 2.
February 12, 2014 at 4:06 pm
You're still missing DDL for tables and indexes.
Things might speed up if you remove the ORDER BY and change your WHERE clause to
WHERE A.entitlement_function NOT LIKE '@@@%'
However, more improvements can...
February 12, 2014 at 4:00 pm
SQL Guy 1 (2/12/2014)
February 12, 2014 at 3:50 pm
CROSS APPLY works similar to an [INNER] JOIN and OUTER APPLY works similar to LEFT [OUTER] JOIN. Maybe that will help you to understand it better.
This article series by Paul...
February 12, 2014 at 12:38 pm
You could use the query hint MAXDOP.
Check the reference: http://technet.microsoft.com/en-us/library/ms181714.aspx
Example F.
February 12, 2014 at 12:22 pm
You're welcome.
The question now is, do you understand how does it work? You should do it before implementing it into production.
February 12, 2014 at 12:01 pm
That's the difference of unique keys and primary keys. Primary keys will idenitfy a row within a table and they're essentially a preferred unique key. Unique keys will enforce uniqueness...
February 12, 2014 at 10:43 am
I'm not sure why would you want that. It seems like a weird requirement.
As you should know, triggers use 2 pseudo-tables (Inserted & Deleted) from which you need to get...
February 12, 2014 at 10:26 am
Craig-315134 (2/12/2014)
Sooner or later, the balance sheets catch up with them.
That's one of the more positive...
February 12, 2014 at 10:08 am
Why can't you sum a float column? float is a numeric data type and it can be used in SUM().
Here's what I used to test.
DECLARE @Appllication TABLE(
IDint,
Datedate,
Costfloat,
Fundingfloat
)
INSERT INTO @Appllication
VALUES
(1,'20140201', 10.52,...
February 12, 2014 at 9:51 am
latitiacasta (2/12/2014)
I Got the solution. i just convert int to decimal and its worked.Thanks for your help
I was about to write that a conversion was all you need as I...
February 12, 2014 at 9:36 am
Viewing 15 posts - 6,931 through 6,945 (of 8,731 total)