WayneS

Forum Replies Created

Viewing 15 posts - 3,496 through 3,510 (of 5,588 total)

RE: Adding a back button on a child report

tsmith-960032 (8/30/2010)
WayneS (8/27/2010)
Are you rendering this in a browser? Because on the child report all you have to do is click the browser's back button... or press backspace.
If you are...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 3:45 pm

#1213968
RE: did you leave a secure job, what pushed you to move and how did you get on?

The reasons that you've stated are all good reasons for leaving. Your concerns about leaving are also valid.
Have you talked with your supervisor about the rut you're in?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 3:37 pm

#1213964
RE: How to generate script for existing profile in Database Mail?

Check out this link
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 3:23 pm

#1213960
RE: Import to SQL from VFP table programmatically

jesuslives01 (8/30/2010)
I'm getting an error pointing to the last ')'; however, that may not be the real problem. Anyone know what is wrong?
I tried it with and without the ';User...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 3:21 pm

#1213959
RE: Trigger On Update

vrkn82 (8/30/2010)
How trigger works on update statement affecting more than one row?
If coded properly as a set-based operation, just fine.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 3:18 pm

#1213957
RE: Join to table if date in range or no range exists

Remove your where clause completely - this is filtering the result set.
Make your from clause:
FROM
@Timecards TC LEFT JOIN @ProtectionFactors PF
...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 2:41 pm

#1213952
RE: Join to table if date in range or no range exists

Excellent start.
One question: Based on the sample data provided, what should the result set look like?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 2:31 pm

#1213948
RE: Upgrading from 32bit version of SQL Server 2000 (on 64bit OS) to 64bit version of SQL Server 2005

Oh - one other thing.
Run DBCC CHECKCATALOG while you are in SQL 2000 (you should run DBCC CHECKDB also).
This will detect if any system tables have orphaned records, from where...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 2:25 pm

#1213944
RE: Upgrading from 32bit version of SQL Server 2000 (on 64bit OS) to 64bit version of SQL Server 2005

CirquedeSQLeil (8/30/2010)
Here is the doc that should be useful and that explains the need to do a side by side for situations such as yours.
http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displayLang=en
Thanks Jason, I should have put...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 2:18 pm

#1213940
RE: Are the posted questions getting worse?

CirquedeSQLeil (8/30/2010)
Steve Jones - Editor (8/30/2010)
WayneS (8/30/2010)
Anyone here going to the SQL Server Connections in Las Vegas Nov 1-4?
I will be there. Look me up
I will.
Wayne, call me when you...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 2:09 pm

#1213937
RE: Upgrading from 32bit version of SQL Server 2000 (on 64bit OS) to 64bit version of SQL Server 2005

You will not be able to do an in-place upgrade, where the existing server is upgraded, since you are going from 32-bit to 64-bit.
1. script logins/custom messages/jobs/operators from existing server....
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 1:54 pm

#1213933
RE: insert missing rows from table1 to table2, both use identity columns

Does this get you the data that you're looking for?
SELECT [IndexName] = so.name,
[IndexPos] = sik.keyno,
...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 1:44 pm

#1213928
RE: Are the posted questions getting worse?

Anyone here going to the SQL Server Connections in Las Vegas Nov 1-4?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 1:18 pm

#1213918
RE: insert missing rows from table1 to table2, both use identity columns

To reinsert the rows that were copied from table1 into table1_save, and subsequently deleted from table1, keeping the original identity value:
SET IDENTITY_INSERT table1 ON
INSERT INTO table1 (list of all columns...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 1:02 pm

#1213911
RE: The NONUpgrade from 2005

Dan,
These links might also be helpful:
How to: Migrate a Reporting Services Installation
Moving the Report Server Databases to Another Computer
Seems like you can just restore your databases on the new server.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 30, 2010 at 11:02 am

#1213842

Viewing 15 posts - 3,496 through 3,510 (of 5,588 total)