Viewing 15 posts - 5,281 through 5,295 (of 6,676 total)
Is it possible that the reports are exceeding the limitations of Excel? How many rows are being returned for these salesmen?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 23, 2009 at 1:52 pm
Can you explain what you mean by 'database refresh'? I have no idea what that means.
BTW - why did you post this same message in two separate forums?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 23, 2009 at 1:46 pm
Jack Corbett (4/23/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 23, 2009 at 1:32 pm
Resources to learn powershell - well, let's see...there's that thing called google...that thing called my time...and I just sort of put them together.
Yep, nothing but my time (well, actually the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 23, 2009 at 1:12 pm
Instead of doing this through a SQL query run through SSMS - I would use a combination of powershell and sqlcmd.
Example:
PS> $servers = get-content c:\temp\servers.txt
PS> $servers | % {sqlcmd -S...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 23, 2009 at 12:56 pm
Try disabling anonymous logins in IIS for those sites and enabling windows integrated authentication.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 23, 2009 at 12:20 pm
Did you try Gail's suggestion to see what is actually in each column?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 23, 2009 at 12:09 pm
Actually, Bob's process will not work with a temp table because a temp table created in a procedure would no longer exist when the procedure terminates. You would have...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 23, 2009 at 9:36 am
Your problem here is going to be the dynamic columns. If the columns were fixed, then you could use the following:
CREATE TABLE #temp2 (define all the columns here);
INSERT INTO...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 22, 2009 at 5:31 pm
Again, you should know about the OUTPUT feature of the INSERT and UPDATE statements. Using this will allow you to create a procedure that could update multiple records in...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 22, 2009 at 5:25 pm
In SQL Server the datetime datatype (that is what you are using, right?) is stored as a double. This number is the number of days since 1900-01-01 where this...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 22, 2009 at 5:22 pm
I am curious - what features in SSIS Enterprise do you see as vital to your systems and processes? I am running several processes using Standard Edition with no...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 22, 2009 at 5:07 pm
Okay, there are a couple of things you should know. First, when checking dates and date ranges we need to strip the time portion from the input parameters to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 22, 2009 at 4:29 pm
Select * From sys.server_principals Where type = 'R';
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 22, 2009 at 4:10 pm
This really comes down to how the where clause is formed. You have the following:
where delivery_date BETWEEN '04/15/2009' and '04/22/2009' and
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 22, 2009 at 4:05 pm
Viewing 15 posts - 5,281 through 5,295 (of 6,676 total)