Viewing 15 posts - 61 through 75 (of 137 total)
The Update syntax does not allow to use variable names on left hand side of SET stagement
i.e.,
SET @colname = 'empid'
...
May 5, 2003 at 8:26 am
Can you run the code in debug mode and find out which line the error is appearing and what the error message is. This might give an hint to solve...
May 5, 2003 at 6:02 am
Try the following
Issue sp_dropuser 'username' on the database
in query analyzer.
Then user enterprize manager to set the permissions again on database
May 5, 2003 at 4:33 am
One alternative is to use TOP clause
SELECT TOP 1 date_column,<other columns>,...
FROM table
WHERE <condition>
ORDER BY date_column DESC
May 5, 2003 at 3:03 am
Answer to similar query exists in
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=11768
May 2, 2003 at 5:35 am
I see your point. However in this case you can write a vb program to populate the word document from table and printing it. You can then schedule this program...
May 2, 2003 at 5:25 am
When there is data less than 50 records, what will the request("pagenum") contain (0 or 1 or empty)?
May 2, 2003 at 5:18 am
Sorry, also when you include TOP clause, you can remove count(*) from the select list of sub query.
SELECT *
FROM t_retail
where t_Retail.Pcde6P IN
(SELECT top 100 PERCENT
t_Retail.Pcde6P
FROM t_Retail
WHERE
LEN (LTRIM(t_Retail.Pcde6P)) = 6
GROUP...
May 1, 2003 at 6:59 am
One way is to include TOP clause for subquery
SELECT *
from t_Retail
WHERE t_Retail.Pcde6P IN
(
SELECT TOP 100 PERCENT
t_Retail.Pcde6P,
Count(*) AS Total
FROM t_Retail
WHERE
LEN (TRIM(t_Retail.Pcde6P)) = 6
GROUP BY
t_Retail.Pcde6P
HAVING
Count(t_Retail.Pcde6P) > 2
ORDER BY
Count(*) DESC
)
May 1, 2003 at 6:56 am
Yes. I would imagine so.
Just a reminder, when using @@ERROR, note that it gives the error of most recent sql statement. Hence it is better to store this @@ERROR in...
April 30, 2003 at 6:39 am
I understand your problem of differential backup issues. I did implement this in one of the projects.
At the start of the day a full database back up is stored as...
April 30, 2003 at 6:15 am
Just an update to Robert's Query
1. auto update statistics is periodical
Sql*Server periodically launches this routine.
Hence if your report runs before...
April 30, 2003 at 6:02 am
It may be long way. However one alternative is as follows.
Create a batch file (.bat) with following commands
a) Run the DTSRUN with /A
b) Print the contents of variable to console.
In...
April 29, 2003 at 10:32 am
One reason could be that the bulk insert is using default MAXERRORS 10. Hence it is not aborting on the first error.
Try specifying MAXERRORS = 0 in the WITH clause....
April 29, 2003 at 10:09 am
Can you please elaborate as to what is <description field of column> means ?
Thanks
April 29, 2003 at 8:36 am
Viewing 15 posts - 61 through 75 (of 137 total)