WayneS

Forum Replies Created

Viewing 15 posts - 4,561 through 4,575 (of 5,588 total)

RE: Are the posted questions getting worse?

lmu92 (3/31/2010)
But it's a while back since I've last seen a LMGTFY link...
I still use them... strange how I don't get very many replies to the thread after doing so......
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

March 31, 2010 at 12:52 pm

#1143376
RE: Advice on an OR statement

DrJogalog (3/31/2010)
The PK on my table is PREFIX, DOCMENT and SEQNO. This is the clustered index.
If I run this statement after clearing the SQL buffer (DBCC DROPCLEANBUFFERS) etc, it will...
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

March 31, 2010 at 11:55 am

#1143310
RE: How to convert an Access Last function to SQL Server

Not being an Access developer, I assume that the Last function returns the last (highest) value for a field? If so, try:
select top 1 "Your Field" from "Your Table" order...
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

March 31, 2010 at 11:49 am

#1143307
RE: Are the posted questions getting worse?

Chris Morris-439714 (3/31/2010)
And started it off with Friend...
Or...'dear' :sick:
Ooh don't...one of those really ticked me off a few weeks ago :blush:
How many times can one use "dear" in a post?...
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

March 31, 2010 at 9:49 am

#1143221
RE: Counting results

fish-1021547 (3/31/2010)
but I might get an easier solution when i look at the derived views.
Or you might get an easier, BETTER solution if you were to provide the CREATE TABLE...
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

March 31, 2010 at 9:33 am

#1143201
RE: dynamic sql inside stored procedure?

GilaMonster (3/30/2010)
Beedle (3/30/2010)
From the sound of it you could probably use Case statements.
You can, providing performance is not a major requirement.
If you have three distinct queries that are run, code...
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

March 31, 2010 at 9:27 am

#1143187
RE: The Missing Certification

CirquedeSQLeil (3/30/2010)
If any are interested, I posted my blog on the topic. A greater bit of depth needs to be done with the topic. I figure this is...
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

March 30, 2010 at 8:58 pm

#1142819
RE: Updating a single column within a table using multiple tables

K Cline (3/30/2010)
You're almost there. Just missing the From clause to join the tables. When I have a query with multiple tables I tend to use aliases. Personal preference, it...
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

March 30, 2010 at 7:31 pm

#1142812
RE: CTEs solution is slower than cursor & recursion

I added this index: CREATE INDEX [IX_tPA_SetAuthoFunc_acFuncAbove] ON dbo.tPA_SetAuthoFunc (acFuncAbove)
I changed the CTE procedure to this:create procedure dbo.pPA_FillUserAuthorLogOn6
@nUserID ...
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

March 30, 2010 at 5:59 pm

#1142793
RE: Are the posted questions getting worse?

Lynn Pettis (3/30/2010)
Okay, it's getting mighty deep in here. Time to get the hippo to clear out the tent! 😛
I might be getting deep, but after 6 hrs...
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

March 30, 2010 at 3:18 pm

#1142745
RE: View definition permission issue

Paul White NZ (3/30/2010)
You are just checking server-level (login) permissions.
Write a similar query to check the database-level (user) permissions.
Use sys.database_permissions and sys.database_principals
select perm.*
from sys.database_permissions perm
...
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

March 30, 2010 at 2:11 pm

#1142672
RE: Are the posted questions getting worse?

Fellow Threadizens, if I can get you to check out this link about a sql login permission issue that I'm having, I would really appreciate it!
Thanks,
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

March 30, 2010 at 12:51 pm

#1142583
RE: Add a set number to each group of records in a table

This looks like a HIPAA data feed... I sure hope you sanitized the data before uploading it here.
This should handle what you're trying to do:
-- See how this starts off...
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

March 30, 2010 at 12:26 pm

#1142559
RE: The Missing Certification

Kit G (3/30/2010)
I just realized I'm not understanding the context of a word being used here. That word is "gamer".
From the search I did on the Internet and various...
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

March 30, 2010 at 11:42 am

#1142507
RE: The Missing Certification

Jeff Moden (3/30/2010)
If you ever sat through one of my interviews, you would change your mind about that. I only need an hour or so and no "gamer" can...
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

March 30, 2010 at 11:38 am

#1142503

Viewing 15 posts - 4,561 through 4,575 (of 5,588 total)