Viewing 15 posts - 10,261 through 10,275 (of 13,461 total)
ok i think i followed your logic; this was fun for me. made me think hard about how to get a calendar in 12 increments.
correct me if i'm wrong, but...
December 8, 2009 at 11:13 am
if the first query returns 6 rows, and the second returns 1, that is the results of the cartesian join we warned you about.
you have to determine what joins the...
December 7, 2009 at 9:43 am
you'll want to use the datediff function; but would you want a value in minutes if the difference was say 1823 minutes, or would you rather see 30 hours and...
December 7, 2009 at 9:17 am
can you connect with SSMS to the server 'targetsvrname' as the user sql2000login?
if the server was rebuilt, the login sql2000login might not exist and need to be re-added.
December 7, 2009 at 9:11 am
does this work? if your SQLs return just one line, this look good, otherwise it'd do a cartesian join unless you add a where statement.
SELECT
X.MemoryPages, X.MemoryAvailableMbytes, X.ProcessorTime, X.[DateTime], Y.MemoryPages_1
FROM
(
...
December 7, 2009 at 9:01 am
RP this is the syntax i've always used,a dn works without any problems for me:
here i'm connecting to a SQL instance named "DBSQL2K5", but for fun, I'm aliasing it as...
December 7, 2009 at 8:45 am
both Standard and Enterpise will only install on server versions of windows: 2000 Server/Advanced Server, 2003 Server, etc.
Express, Professional, Workgroup, etc versions will install on any Windows Operating system, as...
December 5, 2009 at 4:20 pm
something like this might get you started.
for any given week, this returns the starting date of monday(@12am, the start of friday, and the last possible datetime of friday.
from there, you...
December 5, 2009 at 1:51 pm
as others have pointed out, without a WHERE clause, you are updating every row.
here's an example, which uses the output clause, so you can see how to use it:
Create Table...
December 4, 2009 at 10:08 am
developer version is only a fifty dollar investment.
December 4, 2009 at 5:35 am
xp_cmdshell is the method that opens the door to operating system commands ; once granted you have access to do just about everything.
what you should do is create a...
December 4, 2009 at 5:33 am
that's easy.
there is no way to ENFORCE a relationship between two databases; Foreign keys,constraints,etc can only exist within a database. if you cannot use the built in fuinctionality of...
December 3, 2009 at 7:36 am
here you go: i had this saved in my SQL2000 snippets.
it produces results like this:
TableName IndexName ...
December 3, 2009 at 6:39 am
no; you can change the color of the text in the textbox, but not format PART of it's value, as far as i know.
you could put bold text before...
December 2, 2009 at 1:18 pm
you can select the results of any calculation as a column in your query.
SELECT
COLUMNA ,
Modifier,
(COLUMNA * Modifier) As Result
from MyTable
December 2, 2009 at 10:57 am
Viewing 15 posts - 10,261 through 10,275 (of 13,461 total)