Viewing 15 posts - 1,681 through 1,695 (of 2,452 total)
EdVassie (4/29/2013)
If your reseller is a Microsoft Gold artner then Microsoft accept full liability for any advice they give..
Hi any pointers to official / supporting docs re. the point...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 29, 2013 at 9:49 am
Gina
in the examples you give code/spreadsheet can you please clarify what pre exists as data and what you are calculating.
sorry for being thick 😛
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 24, 2013 at 11:39 am
Hi Gina
just back from work...so sorry for delay.
I must admit that I am struggling to understand your reqs.
there are rows for exactly same date/time/lotid...with a qualifying column of lotidbalseq...have you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 23, 2013 at 2:58 pm
ben.brugman (4/16/2013)
J Livingston SQL (4/16/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 22, 2013 at 9:56 am
deleted
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 21, 2013 at 10:27 am
VegasL (4/21/2013)
I am trying to combine multiple tables, and then show only when value [Qry] when it is greater than 1 after combining the tables, below is what i wrote...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 21, 2013 at 9:33 am
jkury (4/20/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 20, 2013 at 2:29 pm
gcresse (4/20/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 20, 2013 at 1:49 pm
is the following any where near what you are looking for?
note...rounding issues...used for simplicity
SELECT PudID
, TranDate
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 20, 2013 at 11:56 am
one way to consider
SELECT
A.Empid,
ISNULL(B.WeekoffChangeDate, A.WeekoffDate) AS ActualWeekOffDate
FROM Table_A AS A
LEFT OUTER JOIN Table_B AS B ON A.WeekoffDate = B.WeekoffDate
AND A.Empid =...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 20, 2013 at 7:56 am
SELECTPudID,
TranDate,
TranQty,
RunBal,
PudIDPct,
LotID,
PudIDLotBal,
LotIDBalSeq,
'help?'PudIDAsOfBal
may be I am being particulalary thick this morning but I cant seem to follow your spreadsheet for "Runbal" and "PudIDLotBal"....are these columns in your database table that are already...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 20, 2013 at 3:40 am
NineIron (4/17/2013)
Can I have another hint? I'm at the end of my rope trying to get this.
what exactly are you struggling with...??
care to share what code you so far?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2013 at 1:28 pm
an idea to get you started
SELECT COUNT(MRN) AS visits,
DATEPART(MONTH, ApptDt2) AS monthno,
DATEADD(day, 6 - DATEDIFF(day, 6, ApptDt2) % 7, ApptDt2) AS...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2013 at 12:00 pm
rs80 (4/16/2013)
In the merge join transformation, when I do an inner join I only get 1 record back. However, when I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 16, 2013 at 2:18 pm
NineIron (4/16/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 16, 2013 at 2:03 pm
Viewing 15 posts - 1,681 through 1,695 (of 2,452 total)