Viewing 15 posts - 6,136 through 6,150 (of 15,381 total)
Yes David is on the right path here. A case expression has not bearing on the number of rows returned, it merely affects the values for a single column in...
December 12, 2013 at 3:10 pm
DaveDB (12/12/2013)
I need to write a SQL query that aggregates data based on 1 hour intervals. So, basically I would need something that lists all available times: (6:30 - 7:30),...
December 12, 2013 at 3:08 pm
Gillian_Pappas2002 (12/12/2013)
Pardon my ignorance but I have never seen ;with before, and are you...
December 12, 2013 at 2:51 pm
Gillian_Pappas2002 (12/12/2013)
Sorry about the mess.
Hi. Thank you again for your response. That works very well to get rid of either status C or O, but what they want...
December 12, 2013 at 2:47 pm
Please don't start new threads just because nobody answered your other one.
Please direct replies here.
http://www.sqlservercentral.com/Forums/Topic1522455-1633-1.aspx
December 12, 2013 at 2:23 pm
Gillian_Pappas2002 (12/12/2013)
December 12, 2013 at 2:21 pm
Gillian_Pappas2002 (12/12/2013)
I have a collection of records linked by a customer order number. For each like customer order number I want to check the status on them. ...
December 12, 2013 at 12:41 pm
Shadab Shah (12/12/2013)
Why do we used aggregate function in pivot operator and cross tab queries . Any link to blog or video explanning my question can do.Thanks.
No offense intended but...
December 12, 2013 at 10:34 am
mario17 (12/12/2013)
I have this setup and need to do calc on this columns, is there any anylitical function that I can apply directly to get int=2.5 fro this
I...
December 12, 2013 at 10:28 am
Scalar functions are notoriously poor for performance. You have a scalar function nested inside of a scalar function. Then you call that same scalar not once but twice in your...
December 12, 2013 at 7:56 am
tsandeep1407 (12/11/2013)
...but raiserrror() is executing from catch block not the try block....
HUH?
You have a RAISERROR in both the TRY AND the CATCH.
I would think that if you are trying to...
December 11, 2013 at 2:53 pm
tsandeep1407 (12/11/2013)
trying to create a storeproc for error handling...so that all my team members call this sp in their catch blcoks...could it be even better than below?
Did you try this?...
December 11, 2013 at 2:28 pm
ramyours2003 (12/11/2013)
Hi,its not the db mail i wanted to add\update a value in view
alter YourView as
select [OriginalColumns], YourNewColumn
from ...
December 11, 2013 at 8:57 am
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...
December 11, 2013 at 8:55 am
eobiki10 (12/10/2013)
Thanks, I will try that tomorrow in office
No problem. Make sure you read that article. This code is highly unlikely to work as is on your system. 😛
December 10, 2013 at 3:27 pm
Viewing 15 posts - 6,136 through 6,150 (of 15,381 total)