WayneS

Forum Replies Created

Viewing 15 posts - 2,326 through 2,340 (of 5,588 total)

RE: Need help with some code..

The problem is what you are doing in your case statement... specifically your date math.
You are taking the value returned from the GetDate() function, and subtracting one year from it.
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

November 23, 2010 at 11:14 am

#1254627
RE: Temp table (#tname) causing database blocking on 'drop table #tname' call w/in stored procedure

cheshirefox - thanks for posting this. This is very good information.
One point:
cheshirefox (11/23/2010)
Please notice the second bullet – this is what was causing our problem. The stored procedure created...
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

November 23, 2010 at 10:05 am

#1254570
RE: Converting Rows into Columns

This should get you going. Just duplicate it for the other 26 columns.
Also, please check out the Cross-Tab/Pivot tables, Parts 1 and 2 links in my signature.
-- See how this...
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

November 23, 2010 at 9:58 am

#1254563
RE: Can SQL Job schedules be used by more than 1 job?

Ahh Craig... you're always good for a chuckle! 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

November 22, 2010 at 6:37 pm

#1254135
RE: temp table in sysobjects

Seth Kramer (11/22/2010)
Okay but where does the numbering at the end of the underscores correspond to the spid that created it?
Hypothetically, lets say I wanted to see what spid owned...
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

November 22, 2010 at 6:31 pm

#1254134
RE: temp table in sysobjects

mbova407 (11/22/2010)
Correct sql is
select * from tempdb..sysobjects where name like '%#testvm%'
Try this:
in one query window, run:
CREATE TABLE #testvm (RowID INT IDENTITY);
In a different query window, run your command:
IF EXISTS...
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

November 22, 2010 at 6:04 pm

#1254128
RE: Are the posted questions getting worse?

Alvin Ramard (11/22/2010)
Jack Corbett (11/22/2010)
Thanks for all the well wishes folks. Still haven't seen the cardiologist, but have seen his nurse practioner, an internal medicine doc amd his...
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

November 22, 2010 at 3:46 pm

#1254104
RE: Using Case or If Else statements within joins

Sounds like you need to use a LEFT JOIN to the table that might be null, and an additional join to the other field/table. Select using COALESCE(table.column.that.might.be.null, value.to.use.if.other.is.null) for the...
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

November 22, 2010 at 3:44 pm

#1254102
RE: Little Devices

Jeff Moden (11/22/2010)
I just don't ever want to be that "productive". Down-time is very important to me.
Yes, but I refer back to what Steve posted above:
If a device...
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

November 22, 2010 at 3:41 pm

#1254100
RE: Can SQL Job schedules be used by more than 1 job?

Craig Farrell (11/22/2010)
I wouldn't do this, too hard to realize what-all is connected to the same schedule.
Really?
In SSMS, open up a job. In the Job Properties screen, select "Schedules"....
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

November 22, 2010 at 3:39 pm

#1254098
RE: need help with loading a string

kevin4u06 (11/22/2010)
There is one more added complexity , in some recordds the state has for example
Arizona
New Jersy
instead of just their abbreviation
The spaces in this are going to complicate things greatly...
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

November 22, 2010 at 3:32 pm

#1254096
RE: Little Devices

Grant & JP: I want to thank both of you for responding back. I hadn't been that interested before; now that I can see how it could be helpful, you'll...
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

November 22, 2010 at 1:11 pm

#1253993
RE: cursor appropriate?

ChrisM@home (11/22/2010)
MonsterRocks (11/22/2010)
Chris.. the links in ur signature u want me to check out?
@MonsterRocks - Sorry mate, got tied up, but Wayne jumped in with solution.
@Wayne - cheers mate,...
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

November 22, 2010 at 12:51 pm

#1253974
RE: Are the posted questions getting worse?

Lynn Pettis (11/22/2010)
Latest tweet this morning from Jack indicating that there was no heart problems, cholesterol is high so a change in diet. Also, he was fighting a headache.
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

November 22, 2010 at 10:57 am

#1253893
RE: fine tune query

LutzM (11/22/2010)
Looks like a catch-all query issue.
See Gails blog[/url] for details.
Lutz - wouldn't the temp tables that I used handle that? Otherwise, you end up with 4 procs to handle...
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

November 22, 2010 at 10:50 am

#1253885

Viewing 15 posts - 2,326 through 2,340 (of 5,588 total)