Forum Replies Created
Viewing 15 posts - 1,546 through 1,560 (of 3,544 total)
-
RE: Need help on joins
Sergiy's solution will not show databases that have never been backup up which may be the reason why one is missing, this is my solution
SELECT DISTINCT sd.name,bs.backup_finish_date
FROM master.dbo.sysdatabases sd
LEFT...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Select statement with a join where result depends on an if statement
use left joins in Grants answer, eg
SELECT i.ItemNo_, i.ItemDescription, COALESECE(a.Description,b.Description,'')
FROM Item i
LEFT JOIN ItemExtraDescription a ON a.No_ = i.No_ AND a.LanguageCode = ''
LEFT JOIN ItemExtraDescription b ON...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Very tough Challenge.....
Easy to forget that one doh! 
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Date ranges: per calendar week
...see alternative solutions posted by others, often yourself, which are often better than my original solution... Especially with Jeff's...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Deleting multiple lignes from a table
1. Extract one row for each combination of unique columns (3) to another table
2. Truncate original table
3. Insert data (1) back into original table
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Searching Query problem..
Between works quite well Especially if bigints
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Very tough Challenge.....
So, explain the code Gail wrote for you... I wanna make sure you actually learned something other than... Far away is close at hand in the images of elsewhere.
Anon. -
RE: The Microsoft Religion
Kendall,
Hippo Birdy !!!
Far away is close at hand in the images of elsewhere.
Anon. -
RE: return error from isql process?
Add -b parameter to the isql command line
p.s. also check the use of the -m errorlevel parameter as well
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Database Design Question
In addition
Add an IDENTITY column (I'm sure I'll get flamed for this
) so that data can be tracked in insertion order (if required),...Far away is close at hand in the images of elsewhere.
Anon. -
RE: SQL coding convention/format/style
Why is this done Personal preference.
What is... Far away is close at hand in the images of elsewhere.
Anon. -
RE: Dynamic export
I can't allow every user to do this and the report should run at a particular time overnight,... Far away is close at hand in the images of elsewhere.
Anon. -
RE: How do you convert in to Excel file
include the header in copy or save Not possible to include headers in copy or save for Grid results...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: How do you convert in to Excel file
Set output to text and tab format*, execute query, copy and paste results.
* Done in Tools, Options
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Any help with my code?
M("BASE_" + unit_b) is retrieving by name, make sure unit_b is one of K, KG, MTR or ST
M(unit_a) is retrieving by ordinal number, your query has a maximum of 9 columns, make sure...
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 15 posts - 1,546 through 1,560 (of 3,544 total)