Viewing 15 posts - 2,926 through 2,940 (of 6,036 total)
Christopher Stobbs (8/7/2008)
ah Chris my bad,I'm 2005, wierd that the results are different it must do with the Percent and Order by clause combination.
Ankur
What is your default collation?
August 7, 2008 at 4:18 pm
Well, I see you guys had a lot of fun here.
OK, I read this thread as well.
And I cannon figure out one thing.
Everyone agreed the puzzle was designed to...
August 6, 2008 at 3:20 pm
UPDATE PP
SET Reference = m.NewRef
FROM Products PP, Mappings m
WHERE pp.Reference = m.OldRef
August 6, 2008 at 3:05 pm
vkres1 (8/3/2008)
I don't want all the rows to be order by that is the thing right. i want only set of rows order by:)Thx
What in your rows groups them...
August 3, 2008 at 9:51 pm
Once again.
It does not matter which order you use to insert data into a table.
In most cases it will be resided in the table in different order (depending on table...
August 3, 2008 at 8:05 pm
vkres1 (8/3/2008)
I know you are every where. I am just catching up some ideas to post to different forums. some body was telling to try this query, I haven't tried...
August 3, 2008 at 7:16 pm
You better don't use C:\ ever.
Giving users full access to C:\ folder on a server is not the bast idea.
Use shared folders or URL locations.
August 3, 2008 at 6:03 pm
Are you sure folder C:\ on server USUARIO is open for writing for your user?
August 3, 2008 at 5:30 pm
There are some notes which should help you to sort it out.
1. Your migration solution when finished to be applied to Production system where there are no new tables. So,...
August 3, 2008 at 5:14 pm
This should work for you:
USE master
GO
IF EXISTS (SELECT name FROM sysobjects WHERE name = N'SP_AllIndexes_Properties' AND type = 'P')
DROP PROCEDURE SP_AllIndexes_Properties
GO
CREATE PROCEDURE dbo.SP_AllIndexes_Properties -- must be...
July 31, 2008 at 9:06 pm
Francisco (7/30/2008)
July 31, 2008 at 5:02 pm
I guess I've got it wrong 1st time.
This should be closer:
SELECT
u.Unit
, e.EquipmentDesc
...
July 31, 2008 at 4:47 pm
Should it be something like this?
SELECT {WHATEVER}
FROM dbo.Unit u
INNER JOIN dbo.Equipment e ON ???
INNER JOIN dbo.Location...
July 31, 2008 at 4:10 pm
When I do >> select * INTO NEW_TABLE from Table_Name, The count in NEW_TABLE is 56,000,000
How do you know that?
By running select COUNT(*) FROM NEW_TABLE ?
If so then COUNT(*)...
July 31, 2008 at 4:01 pm
This should be really useful for you:
USE master
GO
CREATE VIEW INFORMATION_SCHEMA.Indexes
AS
SELECT O.Name as ObjectName, i.name, i.status, first, {whatever else you want to know about indexes}
FROM sysobjects O
inner join sysindexes i...
July 29, 2008 at 7:51 pm
Viewing 15 posts - 2,926 through 2,940 (of 6,036 total)