Viewing 15 posts - 361 through 375 (of 5,503 total)
Jonathan Marshall (11/12/2013)
I like that idea of using a computed...
November 12, 2013 at 12:47 pm
hunchback (11/12/2013)
Have the descriptor in a separated file and do the concatenation at the command side using COPY.c:\>copy f1 /B + f2 /B f3 /B
Why would someone use the file...
November 12, 2013 at 12:35 pm
Your question is incomplete since ther WHERE clause is missing the "= something" part. But that's just as a side note...
If my limited knowledge is correct, you'll end up with...
November 12, 2013 at 12:21 pm
something along those lines should help:
SELECT DISTINCT
ISNULL(IA.TeamsRSF, 'Not Provided') AS 'Teams RSF'
,ISNULL(IA.TeamSupervisor, 'Not Provided') AS 'Teams Supervisor'
,ISNULL(IA.AssignedWorker, 'Not Provided') AS Worker
,ISNULL(TA.TotalAssignments,0) AS TotalAssignments
,ISNULL(PA.PriorAssigned,0) AS PriorAssigned
,ISNULL(NA.NewAssigned,0) NewAssigned
,ISNULL(CA.Completed,0) Completed
October 21, 2013 at 5:30 pm
duplicate post. No replies please.
original post: http://www.sqlservercentral.com/Forums/Topic1506446-3077-1.aspx
@OP: Even though you don't like the answers you received so far, therer's no reason whatsoever to open a new thread for...
October 20, 2013 at 9:51 am
It looks like something along those lines might help (untested due to missing sample data in a ready to use format...):
WITH cte AS
(
SELECT DISTINCT articulo
FROM unknown
)
SELECT
uk.articulo,
uk.bodega,
uk.cant_disponible,
uk.cantidad,
uk.fecha_hora_transac
FROM cte
CROSS APPLY
(
SELECT TOP...
October 20, 2013 at 5:25 am
I'm not sure what you mean by "settings", but one method you could use to make the update statement "fail" is to add a constraint:
ALTER TABLE #a WITH CHECK
ADD...
October 20, 2013 at 4:51 am
Yes, it's possible to have mdf and ldf files on different drives, including the MODEL database.
October 20, 2013 at 4:41 am
If those files are on a network share, ask your admin responsibe for that share if a backup from last week is available and if they're able to restore the...
October 20, 2013 at 4:35 am
There are several issues:
1) "a query not using the cluster index. It is running a full scan."
A "full scan" (of the table) acually returns all data from the...
October 18, 2013 at 3:26 pm
I'm just slightly confused: The current process having Excel files, MS ACCESS and the like involved is obviously "secure enough", but SQL Server is questioned? :doze:
Has there ever been a...
October 17, 2013 at 12:26 pm
An insert statement can only have one target table at a time.
Even if it would technically be possible, I don't see any logical way to make it work: just assume...
October 16, 2013 at 4:42 pm
I wonder if the code you provided is actually correct...
As far as I can see, this code will never insert a single row into DB2.dbo.CUSTVEND, since
DB1.dbo.CUSTVEND c1
where c1.ACCTNO+c1.SUBC not...
October 16, 2013 at 3:57 pm
Just as a side note:
Whenever dealing with a date type in character format, I'd prefer the ISO format 'YYYYMMDD', so '20131015' instead of '10/15/2013'
Just use SET DATEFORMAT DMY in a...
October 16, 2013 at 12:16 pm
I'm not sure what you mean by "a lot of indexing"... The number of indexes you described is moderate, at least from my perspective...
Depending on the ratio of the messages...
October 16, 2013 at 12:03 pm
Viewing 15 posts - 361 through 375 (of 5,503 total)