Forum Replies Created
Viewing 15 posts - 421 through 435 (of 468 total)
-
RE: cannot update table
i will indeed look into sorting out this query. the query(s) were written in 1997-1998 and have worked since then , hence my belif that they were not at fault....
-
RE: cannot update table
my job has finally started moving! one stage of the job has a lot of locks on a table all at once. could this be slowing down the job (...
-
RE: cannot update table
this job has run fine for the past year so i dont think thats the problem sergiy.thank you though for the suggestion. i will check to see what is locked
-
RE: removing duplicates from a table with no id column or pk
thank you. that was most helpful!!
-
RE: cannot select into
its cool. sorted it, was looking at the wrong columns completely. should have been looking at @ProgramID and @customerID. they both need an alias. thanks all
-
RE: getting last 6 months of data only from table with no date column
thats hard coding dates and strings, and thats the last thing i want to do. just to clarify, i inherited this system when i started this job. its been in...
-
RE: using a date in a where clause without hardcoding it
here is my new query
SELECT
* INTO #MSSalesTemp
FROM
MSS_SalesDate
WHERE
(
DATEPART(
-
RE: using a date in a where clause without hardcoding it
apologies, you are correct. there is a problem in my logic. if the date is the january 2006, then my query will return nothing,in feb 2006 it will only return...
-
RE: using a date in a where clause without hardcoding it
<quote>
that will only work once a year, at the end of june, won't it?
</quote>
I think it will do exactly what i want, it will only return the last 6 months...
-
RE: using a date in a where clause without hardcoding it
hi. i ended up using datepart, which converts the required part of a date into an integer , which is easily compared logically;;
SELECT * FROM
PSS_consolidated
-
RE: how does excel pivot table/report connect to my cube?
on further investigation i believe the connection data is stored in a file with extension ".mso" but i cant find this file. can anyone advise where or how i can...
-
RE: Finding service account a DTS package is runing under
that clears things up. thanks for your help.
-
RE: limiting the amount of data getting into my cube
yes, that was quite helpful. in the source table filter text box, does it require MDX or SQL? there's no button to bring up an MDX builder or anything
Thanks
-
RE: update statement trouble
thank you. thats something i didnt know and would have bothered me for ages.
-
RE: problem removing duplicates
worked a treat, thanks so much. can someone explain precicely the logic behind this, as i feel that i have some misconceptions about how MAX is working in this suituation.
thanks...
Viewing 15 posts - 421 through 435 (of 468 total)