Hello....can someone tell me how I can view my project in Microsoft Project 2013? I have completed the steps to connect to Project Server through Microsoft Project Professional 2010 and has been saved my project, but I can't seem to view it in Project Server. Any help would be greatly appreciated.
I created a new column "Actual Finish". Some of cells have a shaded rose colored background...can someone tell me what causes this. The data in these cells are in date format i.e. 05/23/2013. It does not occur in all cells. Thanks in advance
I removed the memory from my Dell Dimension 8200 to take to get more memory, which they didn't carry anymore. I came back replaced the memory that I had taken out and the PC will not boot up. It makes long beeping noises. I removed the memory and and replaced it again. Can someone point me...
Working in SSRS 2005 and I am trying to get the column heading to stop repeating for example
Group 1
type item # size
23 1234 5
type item # size
25 5678 9
type item# size
19 6789 7
for every line within the group the column headings repeat...
I have a Tabular report in SSRS 2005. When I created the report I am grouped by sales type and I checked the check box to include subtotals. The subtotal is in the header instead of the footer. How can I get the subtotal to appear in the footer?
I have a query that has two conditions in my where statement, for example
WHERE CUSTOMER = 'ABCDE' AND ITEMNMBR = '1234'
My problem is that if it finds ITEMNMBR = '5678' for CUSTOMER = 'ABCDE' then it should appear in the report and it does not...can someone tell me what I am doing wrong?
I have set up date parameters in SSRS 2005 that are not working. Under reports I click report parameters and enter the following criteria:
Properties:
Name BeginDate
Data Type: DateTime
Prompt: BeginDate
Allow blank value is checked.
Available Values = Non-queried
Default values = Null
I...
I am trying to modify a column of datatype char(31) to varchar(3)
ALTER TABLE dbo.zyx_abcdef_hdr
MODIFY vc_xxx_zzz varchar(3)
I am getting error message:
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near vc_xxx_zzz'
Any suggestions?
I have two databases database1 & database2. I can retrieve most of my information from a table in database1, but there is a column from a table in database2 that I need to complete my query. Is there a way to join this column from database2 to my ouput from data retrieved from database1?
I have a column within a table that is pulling the date, folder and file name as:
#2007\12\12\15\DOCFILE1.TXT
Is there a way to convert this in SQL to get just the date?
2007\12\12
Is it possible to add days to a date? For example I have a date column with a date of 10/09/2007 then I have a column named date diff with 365. When adding 365 to 10/09/2007 it should give me 10/09/2008 in the final date column. I am not sure how to do this since the date and the value in the...
I have the below SQL statement in the beginning of my ASP page
MySQL = "SELECT * FROM ShipSummary (NOLOCK) where ShipDate = DateDiff(d, 0, GetDate()+1)"
If there are no records found the program stops and gives me an error: ADODB.Recordset error '800a0bcd'...this is because there are no...
I have been trying to display a break between date groupings without luck (using ASP Classic). I have tried many suggestions found in FAQ's or by searching Google..but nothing that works. It must be something that I am doing wrong...can someone help?
body = "<HTML<STYLE...
I have the below code and I am trying to insert a blank row when the date changes (column early_shpdte). I have tried multiple things such as char(13)+ char(10) but nothing works. I am just a beginner trying to master this skill. Can someone help me out?
SELECT CASE
when...
I am trying to insert a blank line between categories. My output is:
Shoes 12
Shoes 11
Shoes 10
Shoes 09
Socks 19
Socks 11
Socks 17
Socks 22
Boots 19
Boots 25
Boots 76
What I am trying to get is each category with a blank line in between like:
Shoes 12
Shoes 11
Shoes 10...
I have the below code I am trying to subtotal by date
MySQL = "SELECT ship_id, adrnam, prtnum, early_shpdte, shpsts, cponum, stgdte, host_ordqty, inpqty, stgqty, sum(host_ordqty-stgqty-inpqty) FROM ShipReport (NOLOCK) where (host_ordqty-stgqty-inpqty <> 0) GROUP BY ship_id, adrnam, prtnum...
I am receiving error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/*****/*****.asp, line 21
MyRecordSet.OPEN MySQL, ssddbb
dim stgdte
if MyRecordSet.fields("stgdte") <> "" or...
I am trying to format a date in an ASP page in which the date already appears (prior to formatting). I would like the date to appear as 9/07/2007 instead of 2007-09-07 11:13:08.000. See code below
FormatDateTime(------, vbshortdate)
I am not sure what to put in place of the dashes. If I...
I am trying to sum quantities by date and I am having some difficulties, this is what I have so far:
body = body + "<TR><TD BGCOLOR=""" & SHADE & """ COLSPAN=3 ALIGN=""CENTER""><b>Total:</b> </TD><TD ALIGN=""RIGHT"" BGCOLOR=""" & SHADE & """><B>" &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.