Viewing 15 posts - 61 through 75 (of 117 total)
Do you have an example of the table structure and data we can look at?
Hi Doug, don't really have a table structure, it would be from one column - varchar...
October 28, 2009 at 6:43 am
Hi, if I were to do this in MSSQL I would use the following script, would this work in Access?
CREATE TABLE Colors
(
Color VARCHAR(32)
)...
October 20, 2009 at 10:33 am
GilaMonster (9/1/2009)
p.s. the way you've written those queries is highly inefficient. By putting a function on the column, you're forcing a table scan, SQL cannot use...
September 1, 2009 at 7:35 am
Bob Hovious (8/20/2009)
--...
August 20, 2009 at 1:48 pm
--
select getdate() as today
,DATEPART(wk,getdate()) as WeekOfYear
,left(DATEADD(wk,DATEDIFF(wk,0,getdate()),-1),6)+ ' - '
+left(DATEADD(wk,DATEDIFF(wk,0,getdate()),5),6) as weekRange
--
Hi Bob, that does work, but does that just work for this week and today?
The nested datediff function,...
August 20, 2009 at 11:41 am
select
datepart(wk, datefield1) as 'WeekOfYear',
--put daterange column here,
sum(col1) as 'Col1Base',
sum(col2) as 'Col2Base'
from
tbl_Base
where
datepart(mm, datefield1) between 1 and 8
group by datepart(wk, duedate)
with rollup
Ok, I think this works, seems a little hacky, if...
August 20, 2009 at 10:17 am
It's a reporting services parameter to select months, the user can select multiple months.
May 19, 2009 at 9:23 am
Samuel,
Having trouble pulling the first selected parameter into this calculation… if we use lastperiods in place of lag… how can we get the first selected month from list of parameters...
May 19, 2009 at 9:05 am
Thank you Samuel, that does make more sense.
.mf
May 19, 2009 at 8:19 am
Hi samuel, I've tried 'lag' but it only allows for one value, I'd actually like to pull data from a range of months. I'll look into the periods to...
May 19, 2009 at 8:05 am
Thanks Mark, that's what i was looking for...
February 25, 2009 at 12:06 pm
Hi thanks for your help, if I repoint the location of my databases should I leave the master db on the server that sql is running on?
June 27, 2008 at 11:14 am
Thanks Lynn, your suggestion sounds like a safe plan.
June 9, 2008 at 12:28 pm
Thanks Lynn, I unchecked my 'compress drive to save disk space' check button in the disk management properties session and the worked. If I store my data bases on...
June 9, 2008 at 12:05 pm
Thanks John, this solution worked well and was actually pretty simple, thanks for providing me with a different perspective.
June 9, 2008 at 9:08 am
Viewing 15 posts - 61 through 75 (of 117 total)