Viewing 15 posts - 1,411 through 1,425 (of 3,500 total)
I think I should be able to do this with SQL Server Express (provided I could even install it somewhere there). 10GB of space should be plenty for bare minimum...
November 16, 2017 at 5:48 pm
Just a guess, but maybe because the file SSRS outputs is likely an XML file, so it's converting Word to a real Word file when it saves?
November 16, 2017 at 4:30 pm
Okay, got it. Thanks! I'll watch a video or two until I get my head around it. Just want to have some idea of what I might be doing before...
November 14, 2017 at 6:47 pm
Matt,
Thanks for the pointers!
Okay, so I could basically use Access as a temporary "container" for the data, and then do something like...
1. export from SAP to...
November 14, 2017 at 2:30 pm
Sounds like you need this article: Crosstabs and Pivots by Jeff Moden...
November 13, 2017 at 6:29 pm
db_owner is a ROLE, not a schema.
https://technet.microsoft.com/en-us/library/ms180977(v=sql.90).aspx
The default SCHEMA is dbo.
November 9, 2017 at 9:40 pm
Having a "date purchased" column in Stores doesn't make any sense, unless you were recording the date the store was purchased. Normally, if a column doesn't describe the "subject" of...
November 8, 2017 at 11:19 pm
Maybe watch this video... I watched it several times when trying to get my head around subreports. You can download their sample database so you can work along with the...
November 1, 2017 at 2:55 pm
here's one solution using LAG. Requires SQL Server 2012 and later.
use tempdb;
go
create table #data(ProductID INT
, LocationID CHAR(4)
, EventDate DATE
, Qty...
October 30, 2017 at 11:07 am
Couple things jump out as odd... First:
dt_close_time VARCHAR(23)
Why not use a DATETIME datatype?
Second, there seem to be only two records that meet the criteria (or did...
October 24, 2017 at 4:56 pm
Use ROUND?SELECT Amount,ROUND(Amount,0) AS rounded
FROM Green;
October 9, 2017 at 7:42 pm
Did you try COALESCE instead?
DECLARE @LastName VARCHAR(20) = NULL;
SET NOCOUNT ON;
SELECT p.[BusinessEntityID]
,p.[Title]
,p.[FirstName]
,p.[MiddleName]
,p.[LastName]
,p.[Suffix]
,pp.PhoneNumber
FROM [Person].[Person] p INNER JOIN [Person].[PersonPhone]...
September 21, 2017 at 8:31 pm
Maybe something like this? (Might get shredded for this one, but live & learn!)
/* populate dummy table */SELECT PatientID, Gender, Birthdate
INTO #Dummy
FROM dbo.Patient p
September 19, 2017 at 1:39 pm
Nashville, TN has a ridiculous number of Healthcare IT jobs, especially SQL Server and .NET. If you can do those, you can almost write your own ticket here. Not sure...
September 19, 2017 at 12:59 pm
Viewing 15 posts - 1,411 through 1,425 (of 3,500 total)