WayneS

Forum Replies Created

Viewing 15 posts - 361 through 375 (of 5,588 total)

RE: Using Wildcard with a date column

Internally, a datetime is a numeric. That's why you can do a "SELECT GETDATE() -1".
If you are always looking for a month, then check out the "Date/Time routines" link 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

July 28, 2015 at 1:13 pm

#1815539
RE: Are the posted questions getting worse?

SQLRNNR (7/28/2015)
Brandie Tarvin (7/28/2015)
Careful, guys. Gail-baiting is a sure way to encourage the use of katanas.
Those are used for cutting steak right?
Or are they the spindle-y things that they stack...
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

July 28, 2015 at 9:33 am

#1815466
RE: Are the posted questions getting worse?

Brandie Tarvin (7/28/2015)
Careful, guys. Gail-baiting is a sure way to encourage the use of katanas.
Well, we'll just have to take her out to dinner then.
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

July 28, 2015 at 9:28 am

#1815460
RE: can I safely use top n for select/delete in a while loop?

sqlguy-736318 (7/27/2015)
Hi, can I safely use top n select/delete in a while loop? For example:
declare @FieldVal int
while (select count(*) from @MyTempTable) > 0
begin
select top 1 @FieldVal = FieldVal from...
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

July 27, 2015 at 5:43 pm

#1815284
RE: shortcut for table variables?

sqlguy-736318 (7/27/2015)
Hi, are you aware of any shortcut strategies for table variables similar to shortcut strategies for temp tables? For example, the following SQL will create a temp 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

July 27, 2015 at 5:40 pm

#1815283
RE: Grouping by records that are already grouped.

brody.rathman (7/27/2015)
I have results from a query that have anywhere from 1-4 results. I have a subid of 1-4 which is grouped by a certain criteria. so for example...
id ...
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

July 27, 2015 at 5:36 pm

#1815282
RE: Unable to Shrink log on simple recovery mode database

SQLRNNR (7/27/2015)
Your Loginfo results are a bit wonky.
It shows that the first vlf is 8kb and the second vlf is ~1090mb. This is not normal.
Second piece of wonky 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

July 27, 2015 at 3:13 pm

#1815262
RE: Are the posted questions getting worse?

So...
If I were to say that one of Gail's answers wasn't, well, entirely accurate... do you think this would get her out to Summit this year to whoop on me...
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

July 27, 2015 at 11:34 am

#1815218
RE: non trusted constraints vs performance

ScottPletcher (7/27/2015)
Yes, non-trusted constraints could seriously degrade your performance because SQL won't be able to use the index associated with those constraints and thus might have to scan the 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

July 27, 2015 at 11:11 am

#1815202
RE: How to insert from Table 1 to Table 2 only if record doesn't exist in Table 2.

shezi (7/27/2015)
This works great but when there is null value in any of the fields then the checking fails and keep inserting duplicate rows. Please advise
Did you try the solution...
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

July 27, 2015 at 10:56 am

#1815200
RE: Delete and recreate identity column and fetch the newly created values in an update statement

karthik82.vk (7/25/2015)
I have a four tables called plandescription, plandetail and analysisdetail. The table plandescription has the columns DetailQuestionID which is the primary and identity column and a QuestionDescription column.
The 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

July 27, 2015 at 10:39 am

#1815196
RE: Are the posted questions getting worse?

jasona.work (7/27/2015)
And I just realized that until we get a TLog backup, it's in "pseudo simple" mode, ain't it...
Pseudo-simple is a new database in the full recovery model that hasn't...
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

July 27, 2015 at 8:51 am

#1815159
RE: How to insert from Table 1 to Table 2 only if record doesn't exist in Table 2.

shezi (7/24/2015)
I'm inserting from TempAccrual to VacationAccrual . It works nicely, however if I run this script again it will insert the same values again in VacationAccrual. How do ...
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

July 24, 2015 at 9:15 am

#1814808
RE: Help selecting records not between 2 dates

That's going to be a bit more difficult. For one thing, there isn't a row being returned for these machines for that year in that subquery... the NOT IN ensures...
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

July 23, 2015 at 8:29 pm

#1814621
RE: selecting max between two dates for a given year

Luis Cazares (7/23/2015)
This seems to be what you're asking for. However, it seems awkward that you consider the enddate as an enrollment date.
SELECT EMP.ID,
EMP.NAME,
...
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

July 23, 2015 at 2:02 pm

#1814557

Viewing 15 posts - 361 through 375 (of 5,588 total)