Jeff Moden (2/10/2012)

---

wurkenmomz (2/10/2012)

---

Also, he states that using the Distinct will not get the recommended results and can be very unreliable, in these cases. He does this for a...

suggest this to work with two digit dates

[Date]= convert(datetime,right(DT,20))

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...

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...

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

can you provide the SQL for your query

I am no Access expert, I think that you are having problems relating to Form!

does " execute spfiscalsocialstatsnotsatorholidays forms!f_main!txtbegindate, forms!f_main!txtenddate" run successfully when executed from a command on Form "f_main" ?

right click on the results pane in SSMS

"copy with headers"

absolutely agree...but should it be VendorID (not vendorName)...

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...

lonex (2/8/2012)

---

Thanks for revision, now I see how important is to get that sample data and have tried but not getting any luck on that as that is another issue...

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

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),

...

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...

can we assume that there are no indexes on table bigw.PL0_NEW_ALL ?