Viewing 15 posts - 6,616 through 6,630 (of 7,191 total)
Fairly basic stuff, this... I would recommend you spend some time reading about T-SQL programming.
UPDATE b
SET Actiontype = 4,
ActionNum = f.pluginid
FROM Routesteps a
JOIN Routesteptasks b
ON a.Routestepid = b.Routestepid
JOIN...
January 18, 2007 at 10:20 am
SELECT * FROM MyTable t JOIN
(SELECT DISTINCT DistinctRow FROM MyTable) d
ON t.DistinctRow = d.DistinctRow
John
January 18, 2007 at 9:52 am
Stacey
If I understand what you're saying, you're trying to connect from a computer on the same network as the server. Have you looked at the Server/Client Network Utilities (or whatever...
January 18, 2007 at 8:20 am
Stacey
Are you running SSMS on the server or remotely? If remotely, is there a firewall between the two computers? What is the authentication mode of the server, and how are...
January 18, 2007 at 7:59 am
Jules
Is this what you're after?
declare
@i int
exec test @out = @i
January 18, 2007 at 7:42 am
Or you can use the undocumented extended stored procedure xp_readerrorlog, if you have auditing set up.
John
January 18, 2007 at 7:07 am
The + operator doesn't work with text data types. I would suggest you change the column to varchar (surely you can't need over 4000 characters for a file path?) If...
January 18, 2007 at 6:04 am
Works for me. What data type is the gdetail column?
John
January 18, 2007 at 5:11 am
UPDATE heatgen
SET gdetail = 'H:\2007' + RIGHT(gdetail, CHARINDEX('\', REVERSE(gdetail)))
This is fairly basic stuff - I recommend that you spend some time learning the fundamentals of T-SQL, since you are...
January 18, 2007 at 3:24 am
Alex
Different types of objects have different ways of generating the scripts. Views, stored procedures and functions are similar, but constraints, indexes, tables and users are different. Your best bet is...
January 17, 2007 at 10:03 am
OK - that's why I asked at the beginning whether all the files were in the same place. It seems your problem is more complicated than it appeared. What you...
January 17, 2007 at 9:52 am
That's because it's doing what you told it to: it's replacing every instance of "C:\" with "H:\2007". So what you need to do is include more than just "C:\" in...
January 17, 2007 at 9:13 am
Then I'll leave the rest to you: look up the REPLACE syntax in Books Online. If there's any aspect of it that you don't understand, please let us know.
John
January 17, 2007 at 8:51 am
Are all your files in the same folder on the C drive, or are they spread over more than one? If they're in the same one, you are on the...
January 17, 2007 at 8:46 am
Meeta
You will probably find it enlightening (and also maybe a bit bemusing) to read this article and the discussion that followed it:
http://www.sqlservercentral.com/columnists/dpeterson/lookuptablemadness.asp
John
January 17, 2007 at 7:44 am
Viewing 15 posts - 6,616 through 6,630 (of 7,191 total)