ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,806 through 5,820 (of 10,143 total)

RE: replace

elham_azizi_62 (8/28/2012)
...
my string is parameter that fiil from one function and function returns '0,0,'',0,'',0'
now how do i do?
I can only guess what you are trying to say here, it makes...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2012 at 5:11 am

#1530706
RE: replace

elham_azizi_62 (8/28/2012)
hello all.
I have one string like this:'0,0,'',0,'',0' and i want to my result this:'0,null,'',0,'',0' please guide me how to do i do for this result?
thanks
No...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2012 at 4:35 am

#1530685
RE: table sub division on sql server 2000

raghuldrag (8/27/2012)
table-1
employee details
...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2012 at 4:05 am

#1530668
RE: subdivision on output query in server 2000

ChrisM@Work (8/28/2012)
raghuldrag (8/28/2012)
alter procedure Goals_history
...
What version of SQL Server is your database?
OP answered in a PM, he's using SQL Server 2000.
Raghuldrag, please post in the SQL Server 7, 2000 forum...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2012 at 4:03 am

#1530665
RE: subdivision on output query in server 2000

raghuldrag (8/28/2012)
alter procedure Goals_history
...
What version of SQL Server is your database?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2012 at 3:52 am

#1530663
RE: increment values on day basis on column

Generating your own identity values isn't as straightforward as it might at first appear, the code for preventing concurrency issues is fairly complex. Why don't you use the identity column...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2012 at 3:18 am

#1530648
RE: Split a name on to new columns in a table

amarkhowe (8/28/2012)
Monring,
If I have a name all in one cell on a column such as
"Mr Simon ASHWORTH"
How can I split the name so that I could have Mr on...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2012 at 2:23 am

#1530620
RE: Create view with no outer joins

jdbrown239 (8/27/2012)
Sorry for the initial messy post.
I think you guys are right. I have tried writing the view without joins and the result set is never the same. I will...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2012 at 2:11 am

#1530614
RE: Use Of TableValueConstructor

TVC implies a set of row value expressions; single-row value expressions can be very useful, see this article [/url]by Dangler Dwain.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 24, 2012 at 9:58 am

#1529835
RE: Tsql procedure to mutiple rows if it has duplicate id

SQL Kiwi (8/24/2012)
ChrisM@Work (8/24/2012)
Try converting it to a read-only fast-forward cursor, and change
WHERE CURRENT OF reader
to an explicit UPDATE with a supporting index.
I didn't write it for performance (it's...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 24, 2012 at 9:28 am

#1529812
RE: Tsql procedure to mutiple rows if it has duplicate id

Luis Cazares (8/24/2012)
After several runs (with consistent results) that might not be enough to prove something real. I found out that the explicit RBAR (from Paul) beated the hidden RBAR...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 24, 2012 at 8:35 am

#1529769
RE: Substrating the columns from two queries

dwain.c (8/24/2012)
Grant Fritchey (8/24/2012)
Jeff Moden (8/23/2012)
ChrisM@Work (8/23/2012)
Brandie Tarvin (8/23/2012)
... Tootsie Rolls...
Are we back on Clinton??
It Depends... are you wearing a blue dress? :-):-D:-P:hehe:
I thought we had an agreement. You wear...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 24, 2012 at 6:31 am

#1529682
RE: Substrating the columns from two queries

Shadab Shah (8/23/2012)
Hi,
I have one query as SELECT A FROM TEMP1.
And the other query as SELECT B FROM TEMP2.
Now i want the answer to be shown as A-B.
I don't know...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 24, 2012 at 6:03 am

#1529675
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

SQL Kiwi (8/24/2012)
ChrisM@Work (8/24/2012)
It looks to me that APPLY evaluates the row where Stringy = NULL and returns NULL, which is subsequently retained by OUTER APPLY and discarded by CROSS...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 24, 2012 at 5:57 am

#1529673
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

SQL Kiwi (8/24/2012)
Usman Butt (8/24/2012)
I guess was not able to convey it properly :unsure: The only thing I was talking of that CROSS APPLY would work as INNER JOIN and...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 24, 2012 at 4:34 am

#1529645

Viewing 15 posts - 5,806 through 5,820 (of 10,143 total)