Viewing 15 posts - 6,736 through 6,750 (of 26,490 total)
isuckatsql (4/14/2014)
Based on research and the lack of response, i guess it can't be done in SQL.Let's try C#.
Again, answer the question asked below, what value do you expect this...
April 14, 2014 at 9:43 am
yuvipoy (4/14/2014)
FROM
--TABLE1 M (NOLOCK), -- Use of NOLOCK is HIGHLY Suspect and can provide erronous data
--TABLE2 OM (NOLOCK) -- including missing and/or...
April 14, 2014 at 9:23 am
Miller (4/14/2014)
SELECT * FROM [dbo].[BetterSplit] ('the; quick; ...
April 14, 2014 at 8:34 am
Sean Lange (4/14/2014)
Lynn Pettis (4/14/2014)
Sean Lange (4/14/2014)
Lynn Pettis (4/9/2014)
Sean Lange (4/9/2014)
Lynn Pettis (4/9/2014)
Well, looks like Sean and I have similar but different solutions.
Yes indeed. One suggestion I would offer is...
April 14, 2014 at 8:11 am
halifaxdal (4/14/2014)
FYStart = DateAdd(mm,-2,DateAdd(yy,DateDiff(yy,0,DateAdd(mm,2,Getdate())),0))
FYPrevStart = DateAdd(yy,-1,FYStart)
FYPrevStart = DateAdd(yy,-1,DateAdd(mm,-2,DateAdd(yy,DateDiff(yy,0,DateAdd(mm,2,Getdate())),0)))
...
April 14, 2014 at 7:53 am
Sean Lange (4/14/2014)
Lynn Pettis (4/9/2014)
Sean Lange (4/9/2014)
Lynn Pettis (4/9/2014)
Well, looks like Sean and I have similar but different solutions.
Yes indeed. One suggestion I would offer is to include an order...
April 14, 2014 at 7:45 am
Reformatted your code and made some annotations. Be sure to read them.
SELECT
M.*,
COL1, -- Based on the DDL you provided all of...
April 14, 2014 at 7:30 am
Jeff Moden (4/13/2014)
Miller (4/13/2014)
April 13, 2014 at 11:16 am
As much as I hate saying this, since semicolons are statement terminators not statement begininators, try putting a semicolon in front of the WITH of the CTE declaration. I.E....
April 13, 2014 at 10:22 am
Port1433 (4/12/2014)
I can't grasp the meaning of instance as it is being used in various contexts. For example SQL SERVER 2000,SQL server 2005, SQL Server 2008 and 2012 are...
April 12, 2014 at 11:14 am
Okay, based on the following call to the procedure:
EXEC @return_value = [dbo].[zzNewTable2]
@fromRec = 0,
@toRec = 9,
@OrderType = N'asc',
@OrderBy = N'posteddate'
It appears that you want to sort the data being returned...
April 12, 2014 at 8:57 am
Based on the sample data, what is the output supposed to look like?
April 12, 2014 at 8:37 am
At this point I would suggest contacting Microsoft regarding this issue rather than relying on volunteers who may not have experienced the same problem as you are having at this...
April 12, 2014 at 8:35 am
There is another way, look at the last Fiscal Year calculation:
WITH SAMPLE_DATE(XDATE) AS
(
SELECT CONVERT(DATETIME2(0),XDATE,120) AS XDATE
FROM (VALUES
...
April 12, 2014 at 8:22 am
Actually, you still haven't provided anything we can work with here. Please post the DDL (CREATE TABLE statement) for the table(s) involved, sample data (in the form of INSERT...
April 12, 2014 at 7:34 am
Viewing 15 posts - 6,736 through 6,750 (of 26,490 total)