Sean Lange

Forum Replies Created

Viewing 15 posts - 6,331 through 6,345 (of 15,381 total)

RE: calculating a date in the future

a20213 (11/5/2013)
@sean-2, are you sure 5th May is a Saturday ? in this case i want to May 6th 2014.
Its allright to assume 4 weeks each month ?
hehe Nope,...

November 5, 2013 at 11:38 am

#1664207
RE: Help with Text search

I am now thinking that perhaps I did this backwards. You have everything split out and you want to pack it all together. Take a look at this article for...

November 5, 2013 at 10:00 am

#1664191
RE: Help with Text search

No problem. Take a look at the link in my signature about splitting strings. In there you will find the DelimitedSplit8K iTVF.
Please notice how I posted ddl and sample data...

November 5, 2013 at 9:58 am

#1664188
RE: calculating a date in the future

a20213 (11/5/2013)
hello,
i was trying to find dates in the future when a few doubts arise
with this sql i can calculate, lets say all tuesdays starting from today till 2015
declare @dt...

November 5, 2013 at 9:46 am

#1664183
RE: API?

Given that this is a sql server site you are far more likely to get a decent response on a MySql site.

November 5, 2013 at 9:09 am

#1664174
RE: Count

This is where you post ddl and sample data for your problem. Please take a few minutes and read the article in my signature about how to post questions.

November 4, 2013 at 12:04 pm

#1663924
RE: Consolidating an entire year into a single query

Something like this?
SELECT COUNT(Orders) as MonthlySales, MONTH(OrderDate) as OrderMonth
FROM Sales
WHERE YEAR(OrderDate) = 2013
GROUP BY MONTH(OrderDate)

November 4, 2013 at 12:01 pm

#1663922
RE: Sp runs from 7 sec to 10 min (UnitPricingTrans)

RVO (11/4/2013)
Ten Centuries,
Is this something you're looking for?
I used sys.dm_exec_procedure_stats
object_id: 965578478
database_id: 55
proc name: UnitPricingTrans
cached_time: 2013-11-04 07:53:43.937
last_execution_time: 2013-11-04 08:08:29.953
total_elapsed_time: 541171953
avg_elapsed_time: 700999
last_elapsed_time: 161245222
execution_count: 772
No, post the actual execution plan.

November 4, 2013 at 9:38 am

#1663879
RE: Sp runs from 7 sec to 10 min (UnitPricingTrans)

RVO (11/4/2013)
SSChampion,
I re-compiled procedure using local variables.
But... first run with ( @P_UNIT_TYPE = 'VEH' )
took 11 seconds.
Next run ( @P_UNIT_TYPE = 'COM' )
is taking more than 2 min... and still...

November 4, 2013 at 9:20 am

#1663869
RE: Regarding storedprocedure

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1510847-392-1.aspx

November 4, 2013 at 8:32 am

#1663849
RE: Regarding storedprocedure

Please keep to one thread for all questions. There are at least three for this one.
Here is my response from one of the others. Let's use this on as the...

November 4, 2013 at 8:32 am

#1663848
RE: how to create a loop???

soniaedis (11/3/2013)
fairly new with advanced queries and need help.. how can I make the statement below automatic (loop) so I do not have to add rows everytime I use this?...

November 4, 2013 at 8:30 am

#1663846
RE: Aggregation With Condition

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...

November 4, 2013 at 8:17 am

#1663844
RE: Regarding storedprocedure

I started by formatting your proc so we can read it. If you post this stuff in a code block (using IFCode shortcuts on the left when posting) it will...

November 4, 2013 at 8:09 am

#1663838
RE: Regarding storedprocedure

Duplicate post. Direct replies to the original thread. http://www.sqlservercentral.com/Forums/Topic1510846-391-1.aspx

November 4, 2013 at 8:03 am

#1663834

Viewing 15 posts - 6,331 through 6,345 (of 15,381 total)