WayneS

Forum Replies Created

Viewing 15 posts - 4,261 through 4,275 (of 5,588 total)

RE: SQL Server gets confused, insert instead update

PSSQL (4/28/2010)
What I can not understand is if the record is found, why the error is telling about an Insert, that I am not using at all.
Probably because, behind 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

April 28, 2010 at 9:48 am

#1159081
RE: full text search to match pipe separated data

SandeepGupta (4/28/2010)
I have a column with datatype nVarchar which contains pipe separated data like 1|10|11|5|4.
Is there any way to match exact number(s) using full text search or any other way?
If...
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

April 28, 2010 at 9:35 am

#1159059
RE: Missing numbers in a series

Raj.. (4/28/2010)
I have the data like 1,2,4,5,7,8,11,12,13,15,17,19,20. How to find the missing numbers in the series?
Please help me
Thanks in advance..!!
Raj,
Since you are showing a comma-delimited list, this solution 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

April 28, 2010 at 9:24 am

#1159051
RE: Are the posted questions getting worse?

Does anyone happen to know where a Microsoft reference exists that defines the XML index structures in SQL 2008? I'm looking for both the Primary and Secondary XML index structures.
For...
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

April 27, 2010 at 9:03 pm

#1158623
RE: Special Grouping with ROW_NUMBER

I think I'm going to have to start forcing myself to try using CROSS APPLY until I get the hang of 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

April 27, 2010 at 6:07 pm

#1158599
RE: Date Periods

jrizzo-1083740 (4/27/2010)
Thanks Wayne,
Got it to work.
Great!
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

April 27, 2010 at 3:09 pm

#1158536
RE: Are the posted questions getting worse?

Lynn Pettis (4/27/2010)
Don't know, but as the forum indicates he is still logged on, I hope I didn't scare away this OP.
Just asked for what we always ask for 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

April 27, 2010 at 1:38 pm

#1158472
RE: Are the posted questions getting worse?

Lynn Pettis (4/27/2010)
Don't know, but as the forum indicates he is still logged on, I hope I didn't scare away this OP.
Just asked for what we always ask for 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

April 27, 2010 at 1:38 pm

#1158471
RE: Date Periods

jrizzo-1083740 (4/27/2010)
Hello I am a newbie so please keep the beatings to a min.
I already have the SP working but I can only use specific dates and not the Year...
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

April 27, 2010 at 12:59 pm

#1158438
RE: Issues with finding MIN value in join.

Since we're having troubles helping you out, I'd like to suggest that you provide us with the CREATE TABLE statements for your tables, INSERT statements for some sample data, and...
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

April 27, 2010 at 12:54 pm

#1158435
RE: Adding StartDate and EndDate to WHERE Clause of a StoredProcedure

brian.cook (4/27/2010)
Hi, I have a stored procedure that currenly has one parameter in it. I want to add a @StartDate, and an @EndDate parameter to it, however I am unsure...
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

April 27, 2010 at 7:34 am

#1158211
RE: DateTime

I was a little bit disappointed that the answer went into how a datatime data type is stored in two ints, and did not discuss why "1" = "1900-01-02".
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

April 27, 2010 at 7:17 am

#1158192
RE: Finding previous record based on a single common field.

mister.magoo (4/23/2010)
Here you go...Wayne had it just about right, but missed the sort order reversal required...
mister.magoo, thanks for catching 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

April 26, 2010 at 1:17 pm

#1157831
RE: First Tally Table T-SQL

Hello,
One of the gurus on this site wrote this function for Delimiting strings. It works on strings up to 8000 chars in length.
IF OBJECT_ID('dbo.DelimitedSplit8K') IS NOT NULL DROP FUNCTION...
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

April 26, 2010 at 12:00 pm

#1157776
RE: Are the posted questions getting worse?

Jeff Moden (4/26/2010)
chandrashekarthota (4/26/2010)
As a site administrator I request you to kindly ignore my Core member comments. I am
closing down my site for few weeks just because of plagiarism and...
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

April 26, 2010 at 8:24 am

#1157648

Viewing 15 posts - 4,261 through 4,275 (of 5,588 total)