Viewing 15 posts - 12,301 through 12,315 (of 15,381 total)
Lynn Pettis (4/20/2012)
SQLRNNR (4/20/2012)
The Dixie Flatline (4/20/2012)
I am enjoying a lighthearted chuckle at your expense. I'm also thinking about writing up a 12-step program for you guys.
I...
April 20, 2012 at 12:24 pm
Excellent job posting ddl, sample data and desired output.
I think you looking for something like this:
select ISSUE, MIN(ROW_Date) as Row_Date, SUM(Duration) as Duration
from #group
group by Issue
April 20, 2012 at 12:19 pm
The Dixie Flatline (4/20/2012)
I am enjoying a lighthearted chuckle at your expense. I'm also thinking about writing up a 12-step program for you guys.
I have now found...
April 20, 2012 at 10:08 am
Greg Edwards-268690 (4/20/2012)
The Dixie Flatline (4/20/2012)
I am enjoying a lighthearted chuckle at your expense. I'm also thinking about writing up a 12-step program for you guys.
12 Steps...
April 20, 2012 at 10:03 am
sqlquest2575 (4/20/2012)
I've moved this topic to Replication forum. I am not sure how to delete this from here
No worries. As the OP stated this is a duplicate. Please direct all...
April 20, 2012 at 9:43 am
And just because nobody else has said it yet...the order of data when you insert is irrelevant. SQL tables have no order so ordering your data before an insert does...
April 20, 2012 at 8:52 am
I don't think you can if the target is not sql server. I don't have any link servers setup to a non sql database so I can't confirm that.
April 20, 2012 at 8:47 am
Is there system documentation? I am not sure what you mean by you can't see the tables. I have a feeling you are talking about intellisense. Intellisense does not work...
April 20, 2012 at 8:27 am
smknox (4/20/2012)
Additional comment:Another approach would be to build the entire SQL statement in the frontend and skip the dynamic SQL on the backend. Which is preferred or industry standard?
Building sql...
April 20, 2012 at 8:23 am
You need to provide a bit more detail. What is @cmd1?
To be honest this has the look of a catch all query. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D
April 20, 2012 at 8:22 am
hughesj23 (4/19/2012)
April 20, 2012 at 7:45 am
evevea (4/19/2012)
As a newbie I am looking for some kind of Readme file with step by step instructions on how to instal SQL Server 2005 service pack 4. Official...
April 20, 2012 at 7:40 am
If you want those types of statistics you have to collect the data. In other words you would need to store all your data and certain periods (daily, weekly, monthly,...
April 20, 2012 at 7:36 am
Sachin 80451 (4/20/2012)
I need something in java script for CRM 4.0
As already said you will find a lot more help using google than a sql forum for javascript help. However...
April 20, 2012 at 7:27 am
Viewing 15 posts - 12,301 through 12,315 (of 15,381 total)