Viewing 15 posts - 1,996 through 2,010 (of 2,452 total)
Jeff Moden (2/10/2012)
wurkenmomz (2/10/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 11, 2012 at 10:00 am
suggest this to work with two digit dates
[Date]= convert(datetime,right(DT,20))
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 10, 2012 at 2:21 pm
look up GROUP BY and COUNT in BOL
alternatively please provide more details in the form of table create scripts and sample data (if you are not sure on how...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 10, 2012 at 12:22 pm
here's a thought...any good?
USE [tempdb]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[T_VOL_USAGE]') AND type in (N'U'))
DROP TABLE [dbo].[T_VOL_USAGE]
GO
CREATE TABLE [dbo].[T_VOL_USAGE](
[VOL_NAME] [nvarchar](5) NULL,
[NODE_NAME] [nvarchar](5) NULL
) ON [PRIMARY]
GO
INSERT INTO...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 9, 2012 at 4:09 pm
this thread may give you some more ideas
http://stackoverflow.com/questions/4937933/ms-access-pass-through-dependent-on-form-value
hope it helps and good luck
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 9, 2012 at 2:23 pm
can you provide the SQL for your query
I am no Access expert, I think that you are having problems relating to Form!
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 9, 2012 at 1:23 pm
does " execute spfiscalsocialstatsnotsatorholidays forms!f_main!txtbegindate, forms!f_main!txtenddate" run successfully when executed from a command on Form "f_main" ?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 9, 2012 at 1:10 pm
right click on the results pane in SSMS
"copy with headers"
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 9, 2012 at 11:03 am
I believe the COUNT(*) needs to be COUNT(DISTINCT VendorName) to allow a single vendor to have more than one presence in the city.
absolutely agree...but should it be VendorID (not vendorName)...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 9, 2012 at 7:45 am
Hi...seems that from your previous posts that you are currently a student.
...no probs with that, but you will learn a lot faster if you at least provide what you you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2012 at 3:33 pm
lonex (2/8/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2012 at 1:42 pm
perhaps if you can explain what your ETL process is doing, we can then provide some advice.
there are many ways to perform "ETL".
kind regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2012 at 1:25 pm
hmmm...maybe I am misusing your code
but try with this data
Insert Into dbo.PerfMonData (TrackTime, TrackValue)
Values ('1:13:08 AM', 0.150998),
('2:13:13 AM', 1.476516),
('2:13:18 AM', 0.094423),
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2012 at 12:39 pm
try this
USE [tempdb]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Table_1]') AND type in (N'U'))
DROP TABLE [dbo].[Table_1]
GO
CREATE TABLE [dbo].[Table_1](
[ddate] [nvarchar](255) NULL,
[ddate2] [datetime] NULL
) ON [PRIMARY]
GO
INSERT INTO [dbo].[Table_1]([ddate])
SELECT N'01...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 7, 2012 at 12:21 pm
can we assume that there are no indexes on table bigw.PL0_NEW_ALL ?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 7, 2012 at 11:56 am
Viewing 15 posts - 1,996 through 2,010 (of 2,452 total)