Viewing 15 posts - 22,471 through 22,485 (of 26,490 total)
You have to tell us if it is right or wrong. Does it provide you with the results you are expecting and are those results correct?
February 13, 2009 at 3:09 pm
Mike Levan (2/13/2009)
ALTER VIEW [dbo].[Budget]
AS
Select *
from Budget_R
union all
select *
from Budget_PA
ACtually in my query vwBud and Budget are the views, you can check the view above.
What happens if you change the...
February 13, 2009 at 3:04 pm
Did you do this for me yet?
Do this: select dateadd(mm, datediff(mm, 0, getdate()), -2)
Note the return value, then do this: select Cycle_Cutoff_DT from TIPTest02
What was the results?
February 13, 2009 at 3:01 pm
Ivan b (2/13/2009)
No, column names are PersonID, PersonName, etc.
A* is criteria for searching data in Access query.
I know that I should create View, select...
February 13, 2009 at 2:56 pm
Roy Ernest (2/13/2009)
Michael Valentine Jones (2/13/2009)
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspx
I don't know about that. Here's a thread with links to...
February 13, 2009 at 2:49 pm
I'd also look at Matt's suggestion about UNION'ed select's.
Also, I would suggest getting away from writing queries like this:
SELECT mst.CICS_DIM.CUST_KEY -- 4- and 3- part names here is being depreciated
FROM
stg.STG_CUSTOMER_INTEG
INNER...
February 13, 2009 at 2:38 pm
You want something like this:
STG_CUSTOMER_INTEG
INNER JOIN mst.CICS_DIM
ON ((STG_CUSTOMER_INTEG.CUST_CIS_ID = CICS_DIM.CUST_CICS_ID)
OR (STG_CUSTOMER_INTEG.CUST_CRD_ID = CICS_DIM.CUST_CICS_ID)
OR (STG_CUSTOMER_INTEG.CUST_CSS_ID = CICS_DIM.CUST_CICS_ID)
...
February 13, 2009 at 1:09 pm
From what I have been reading, you don't have a problem. The mirroring is working just as it is supposed to work. Stop worrying until you have something...
February 13, 2009 at 12:09 pm
kingstonnadar (2/13/2009)
(
SELECTROW_NUMBER() OVER ( ORDER BY Col1 ) AS Row, *
FROMtblCountSpeed
)
SELECTC1.Col1, C1.col2, ( C2.Col2 - C1.Col2 ) / ( C2.Col1 - C1.Col1 ) AS QueryColumn
FROMcteCountSpeed C1
LEFT OUTER JOIN...
February 13, 2009 at 11:59 am
Mitch2007 (2/13/2009)
Unfortuantly i'm not getting any results and this may be due to the DataType for the field I am using.
I have the Datatype as...
February 13, 2009 at 11:56 am
Well, My BS degree is a dual major in Computer Science and Business Administration and my MA is a dual major in Computer Information Resource Management and Space Systems Management...
February 13, 2009 at 11:50 am
All updates occur on the main server (for sake of this example FacilityID = 8888), and all records on this server have the FacilityID coded as 8888, correct?
All updates and...
February 13, 2009 at 11:39 am
Roy Ernest (2/13/2009)
Lynn Pettis (2/13/2009)
Ninja's_RGR'us (2/13/2009)
bitbucket (2/13/2009)
February 13, 2009 at 11:32 am
Not much we can do without the DDL for the original tables/views, sample data for the tables, and expected results to test against.
February 13, 2009 at 11:30 am
Viewing 15 posts - 22,471 through 22,485 (of 26,490 total)