WayneS

Forum Replies Created

Viewing 15 posts - 5,041 through 5,055 (of 5,588 total)

RE: Dynamic TSQL Error using insert with nested select - boolean expression expected

shadigirgis (7/7/2009)
Can anyone tell me what is the right way to code the following. Simply, when I do the insert without the where clause, its works. I add...
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 7, 2009 at 5:22 pm

#1021394
RE: please help! Cursor or loop?

Here you go.
Note that you don't actually have a NULL value in Field2; instead you have the string "NULL'. The code handles this.
-- with this clustered index, the following update...
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 7, 2009 at 5:05 pm

#1021390
RE: please help! Cursor or loop?

kenny_scriber (7/7/2009)
Hi Guys, I am trying to write an update query that will update null rows with the last non null row. My data looks like this:
PK 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 7, 2009 at 12:25 pm

#1021264
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

Ooooookay.... and I thought I had a good idea here.:sick:
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 6, 2009 at 9:37 pm

#1020852
RE: Change the clustered index on a large table.

Duplicate post, please post replies here.
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 6, 2009 at 9:33 pm

#1020849
RE: Change the clustered index on a large table.

Duplicate post, please post replies here.
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 6, 2009 at 9:32 pm

#1020846
RE: SQL Split query

Sorry, post appeared to hang and accidentally double-posted.
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 6, 2009 at 9:25 pm

#1020843
RE: SQL Split query

Jeff,
I'm pretty sure I know what your Tally table test is doing... but what is the difference between your "XML" and "XML2" tests? Would you be able to post your...
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 6, 2009 at 9:20 pm

#1020841
RE: How do I add a column to one dataset from another?

If you go back to the original post, and press the quote button, you well see that the element are in mixed case. Your browser may display them as upper...
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 6, 2009 at 9:05 pm

#1020836
RE: How do I add a column to one dataset from another?

This web site has a history of mucking up xml text. I suggest that you attach a file with your xml code in it - save it as a .txt...
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 6, 2009 at 8:52 pm

#1020832
RE: What's new in SQL Server 2008

kishorech17 (7/6/2009)
Can anybody give few quick points on new features in SQL 2008, I really appriciate:-)
http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx
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 6, 2009 at 8:45 pm

#1020827
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

You don't have to give "blocks" of numbers out.
If you had tables like:
CREATE TABLE Company (
CompanyID int NOT NULL identity PRIMARY KEY,
...
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 6, 2009 at 8:40 pm

#1020825
RE: Anyway of getting ride of this cursor?

Edward (7/6/2009)
Hi thanks for that but I only want the oldest record for each ID. That is why I am using the cursor. get all the disinct IDs 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 6, 2009 at 7:20 pm

#1020800
RE: Flakey behavior of code windows on SSC

Steve Jones - Editor (7/6/2009)
Please drop examples of issues in here.
Steve,
I can read this two different ways, and I can't tell which way you mean:
1. Post all examples of 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

July 6, 2009 at 7:00 pm

#1020797
RE: Find the substring in string

This should do it.
declare @test1 table (Tname varchar(1000))
insert into @test1 (Tname) values ('<>Agenda and Minute')
insert into @test1 (Tname) values ('<>Agenda and Minute')
insert into @test1 (Tname) values ('<>Agenda and Minute')
insert into...
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 6, 2009 at 6:53 pm

#1020794

Viewing 15 posts - 5,041 through 5,055 (of 5,588 total)