Viewing 15 posts - 2,431 through 2,445 (of 2,894 total)
The length of "'COPY /Y D:\TEST.xls /B D:\'+ @XPRACTICE +'.XLS'" when @XPRACTICE = 'SQLSERVERCENTRALFORUM' will be 51.
Therefore you have cut-off in result. Don't be greedy :-D, declare @FILENAME as VARCHAR(255)...
August 10, 2010 at 10:20 am
andyc209 (8/10/2010)
first when i COPY a template...
August 10, 2010 at 9:33 am
I wonder what you expect from your current query?
It is kind of LEFT JOIN, but you filtering results for A.COL2 = B.COL2, why bother to have A.COL1 *= B.COL1?
Your...
August 10, 2010 at 9:24 am
I believe that Surface Area Configuration settings are stored in the Windows registry, or, may be some in config files but not in the Database.
Theoretically speaking you can use T-SQL...
August 10, 2010 at 9:11 am
transfering (8/9/2010)
August 10, 2010 at 9:07 am
You can generate INSERT script using VARBINARY datatype. Read the article by Oleg Netchaev:
August 10, 2010 at 8:45 am
I need to know more details in order to help you!
1. Are values in revno column unique in OBBEAVER.USPA_check.dbo.RevID table? PK or Unique index? DDL of OBBEAVER.USPA_check.dbo.RevID whould help.
2. What...
August 6, 2010 at 9:42 am
Tara-1044200 (8/6/2010)
August 6, 2010 at 9:23 am
If only the possible values in yuor dpaid column are 0 or 1 then you can do:
update TOP (10000) dbo.Adm_History2
set fixpaid = abs(rc.dpaid-1)
from dbo.Adm_History2 as ht inner join
OBBEAVER.USPA_check.dbo.RevID rc...
August 6, 2010 at 7:45 am
You write a query you want (or you can wrap it into stored proc), then,
using SQL Server Management Studio, you can create a job in SQL Server Agent, which will...
August 6, 2010 at 7:38 am
That will not be called a "trigger"!
You need to look into SQL Server Agent. You can create SQL Job which can be scheduled to run with requested frequency...
August 6, 2010 at 5:02 am
I also recommend to change
select name, 2 grp, DENSE_RANK() OVER(ORDER .....
to:
select DISTINCT name, 2 grp, DENSE_RANK() OVER(ORDER ...
the above should make smaller cross joins
August 5, 2010 at 10:51 am
drew.allen (8/5/2010)
...From the following link: http://msdn.microsoft.com/en-us/library/ms180878.aspx#UsingOperatorswithDateandTimeDataTypes
Date and Time Arithmetic Operators
To add and subtract for all date and time data types, use DATEADD and DATEDIFF.
...
You should read this article in full!
You...
August 5, 2010 at 10:32 am
Chris Morris-439714 (8/5/2010)
CELKO (8/4/2010)
...Also, start using COALESCE() instead of ISNULL() ...
Why is that, Joe? I use COALESCE() if I want to return the first non-null value from a comma-delimited list...
August 5, 2010 at 2:57 am
drew.allen (8/4/2010)
Even though dates are stored as real numbers, you really should be using DateAdd().
Drew
Why? Is it faster (for three rows)? Is any condition where code will produce wrong results?
Looking...
August 5, 2010 at 2:48 am
Viewing 15 posts - 2,431 through 2,445 (of 2,894 total)