Viewing 15 posts - 556 through 570 (of 747 total)
What size of drive?
What version of Windows? 7 or 8?
Dell?
December 7, 2021 at 6:08 pm
This is a duplicate of https://www.sqlservercentral.com/forums/topic/problem-understanding-sum-function-with-group-by
December 7, 2021 at 4:01 pm
Glenn,
You need a license for CData's API Server if that's what you're trying to use -- according the message, you can request a trial license. API Server is a paid...
December 3, 2021 at 7:41 pm
I recommend creating a matrix (e.g., in a spreadsheet) for yourself when working with such problems so that you can visualize the options that result in true:
PARAMETER...
December 2, 2021 at 11:24 pm
Here's a way to grab first name:
DROP table IF EXISTS #users;
create table #users
(
user_name VARCHAR(255) NOT NULL PRIMARY KEY
...
December 2, 2021 at 8:39 pm
max doesn't appear to directly correlate to values in any of the columns What is max/how is it derived?
xp is apparently experience, and count is # of rows for experience value.
December 2, 2021 at 7:12 pm
I missed that reviewing MS doc for data types. Thank you.
I worked in 2008 for a few years, but have not for a while now.
December 1, 2021 at 10:28 pm
Do you mean in table edit/view mode? You can open the table in design view and set the format to mm/dd/yyyy. Or in a form or report (in which case...
December 1, 2021 at 8:15 pm
I assume your description was of a physical server rather than a VM? 4-socket/2-core: Old Xeons or Opterons?
I believe you'll only get to use 2 cores -- SQL Server Express...
November 30, 2021 at 5:13 pm
Just execute the second query after the first within your try block.
If the first statement succeeds, the second statement will execute.
If the first statement fails, it will jump to the...
November 29, 2021 at 8:24 pm
If you are using the GUI, in the advanced tab, see the "On failure action" dropdown. In addition to the more common "Quit the job reporting failure" or "Quit the job...
November 29, 2021 at 4:57 pm
StatusId is in dbo.Revision, so I think you'd need to adjust slightly to something like the following
DECLARE DocsToExport CURSOR LOCAL FAST_FORWARD FORWARD_ONLY FOR
SELECT RevisionAttachmentItem.DisplayFileName
...
November 24, 2021 at 2:21 pm
Do the clients fully understand the risk of lost data and uptime in testing on the live system? Would a test on duplicate environments suffice. Variables (IP addresses, server names,...
November 23, 2021 at 6:16 pm
Any time you do a comparison such as =, <>, or LIKE in a where clause (or inner join), you are implicitly excluding rows where that column is null, since...
November 23, 2021 at 5:56 pm
Viewing 15 posts - 556 through 570 (of 747 total)