Viewing 15 posts - 616 through 630 (of 790 total)
Another point for experience to work with these problems!
October 4, 2008 at 4:18 pm
hmm are you sure that every day has 7 hour or it is different with any other day!?
October 4, 2008 at 4:07 pm
...or if you want to know this information usually, you can use this procedure:
Creating the Procedure:
CREATE PROCEDURE USP_FIND_INDEX_ID
@TABLE_NAME VARCHAR(200)
AS
SELECT O.NAME, I.OBJECT_ID, I.NAME, I.INDEX_ID, I.TYPE_DESC
FROM sys.objects O INNER JOIN sys.indexes I...
October 4, 2008 at 3:57 pm
For fast information try this:
SELECT OBJECT_ID, NAME, INDEX_ID, TYPE_DESC FROM sys.indexes
WHERE NAME= 'yor_index_name'
Hope it helps you!
:hehe:
October 4, 2008 at 3:48 pm
Jeff Moden (10/4/2008)
quote]
Yes Jeff your link in your sig really no...
October 4, 2008 at 3:40 pm
Hmm can you put more info here about your problem ...I'm sure if you post the table structure and some sample data we will find the solution for you ...be...
October 4, 2008 at 8:22 am
Can anyone tell me this SSMA can help me to migrate from Oracle 8i to SQL Server 2005 ...!?
October 3, 2008 at 9:07 am
As I understand you are listing the things what can you do with Tally Table!?
In my experience I used Tally table to find out the missing numbers in my...
October 3, 2008 at 4:33 am
I agree with Jacob Sebastian!
Structure of the table and sample data ( not original data )!
😎
October 3, 2008 at 2:19 am
OK! Now parsing without errors!
Philip Horan:
What about the results?
October 2, 2008 at 1:35 pm
Hmmm I don't think so that the PARTITION BY will work without ORDER BY ...!?
October 2, 2008 at 1:16 pm
Philip Horan (10/2/2008)
Jacob that is perfect, what did you change?Finally was my approach valid in constructing a query to use in a report?
Many Thanks,
Phil.
Eeeeh, the responses coming up from SQL...
October 2, 2008 at 1:01 pm
Daryl Smith (10/1/2008)
if exists(SELECT material_codeFROM MATERIAL_UPDATES
GROUP BY material_code
HAVING count(*) > 1)
BEGIN
select "Table has Duplicates"
RETURN
END
else
select "No Duplicates"
-- your query here
little nice stuff here...
October 2, 2008 at 12:46 pm
Junior_DBA (10/2/2008)
Thank you.. I am going to proceed installing Excel 2007 and test it the way you said...I hope it works...thanks.
Sure it works in this way I'm exporting the data...
October 2, 2008 at 12:21 pm
Viewing 15 posts - 616 through 630 (of 790 total)