Viewing 15 posts - 496 through 510 (of 2,647 total)
This login "SQLALLUSERS"... Is it a group (icon shows 2 people) or a single user (icon simply shows 1 person)? Is it a domain user/group (domainname\SQLALLUSERS)? What server...
July 17, 2012 at 9:05 am
Well, personally, I would create a new maintenance plan with all that is needed and then get rid of the others. Jobs have steps so that you do not...
July 17, 2012 at 7:14 am
Donald Bustell (7/16/2012)
July 16, 2012 at 4:36 pm
ScottPletcher (7/16/2012)
Donald Bustell (7/16/2012)
Database: timetracking
Column: project varchar(50)
Questions:
1. What in the world???
2. How would I craft a trigger to just RTRIM everything on the way in?
Thanks
Donald
CREATE TRIGGER dbo.project_trg_ins
ON dbo.project
AFTER INSERT
AS
UPDATE p
SET
...
July 16, 2012 at 2:01 pm
I'm sorry, but I don't really understand what you are trying to accomplish. Can you please try to break it down again and explain it a bit better?
July 16, 2012 at 1:47 pm
Without knowing how you are accessing the data via Excel, it is really hard to give any advice or thoughts. Of course, it is very possible that the projects getting...
July 16, 2012 at 1:39 pm
Brandie Tarvin (7/16/2012)
SQLKnowItAll (7/16/2012)
Brandie Tarvin (7/16/2012)
The asterick isn't helping you much, either. Try breaking that down to individual column names.
Although I am not a fan of using *, how will...
July 16, 2012 at 12:30 pm
Brandie Tarvin (7/16/2012)
The asterick isn't helping you much, either. Try breaking that down to individual column names.
Although I am not a fan of using *, how will eliminating that improve...
July 16, 2012 at 12:02 pm
Daxesh Patel (7/16/2012)
select distinct b.ParameterID,b.ParameterValue,a.ParameterTimestamp
From #Parameters a
Cross apply (select distinct ParameterId from #Parameters) c
Outer Apply (select top 1 * from #Parameters
where ParameterTimestamp...
July 16, 2012 at 11:55 am
We did this by writing a stored procedure that imported an excel file. The idea was that out inside sales team would track their calls throughout the day into...
July 16, 2012 at 11:48 am
Use google and search for SQL Server CREATE PROCEDURE
You will create a stored procedure in SQL Server that contains all of the code needed. Then Excel will simply execute...
July 16, 2012 at 9:42 am
Personally, I would create a stored procedure and call that from Excel. That way, the user cannot change the query and you can use all of the SQL features.
July 16, 2012 at 9:34 am
You are sending 4.5 million rows of data with over 200 columns to users on a daily basis? They must have an amazing capability to visualize that in their...
July 16, 2012 at 9:30 am
To report an error, you can put this into your catch:
declare @str VARCHAR(MAX) --set size accordingly
select
ErrorNumber=error_number(),
...
July 16, 2012 at 9:24 am
I'm not sure I understand the question.
1. When you are talking about a "maintenance plan," are you speaking of using the wizard to do this in SSMS?
2. Why...
July 16, 2012 at 8:52 am
Viewing 15 posts - 496 through 510 (of 2,647 total)