ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,136 through 9,150 (of 10,143 total)

RE: Error: Conversion failed when converting datetime from character string.

sunilibn (12/15/2008)
Can any one help me out Actually i want list of people who have not logged in for last 90 days.
In addition to correcting the error pointed out by...
^{“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

December 15, 2008 at 6:24 am

#912413
RE: error-An expression of non-boolean type specified in a context where a condition is expected

Did you test the code I posted, Viji?
^{“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

December 15, 2008 at 4:17 am

#912368
RE: error-An expression of non-boolean type specified in a context where a condition is expected

There are too many errors in the code to list them all, this should work:
[font="Courier New"]WHERE locationkey IN (SELECT locationkey
   FROM dbo.ClientTbl_DimStores
   WHERE (CASE @StoreAttribute
       WHEN 'Country'...
^{“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

December 15, 2008 at 3:43 am

#912355
RE: Order by clause

Hi Sanjay
I'm still not totally sure of your requirement but try this - it will generate the sort order you're expecting from the given sample data.
DROP TABLE #Temp
CREATE TABLE #Temp...
^{“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

December 15, 2008 at 2:57 am

#912343
RE: Order by clause

rbarryyoung (12/14/2008)
Hmm, I think that we must have interpreted his post differently, Chris.
Heh - yeah, think so. I didn't read it properly first time. "1" first, followed by everything else...
^{“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

December 15, 2008 at 2:17 am

#912337
RE: Order by clause

ORDER BY RIGHT('00000'+MyColumn, n)
where n is the length of you column. Ensure that there are enough 0'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

December 14, 2008 at 1:42 pm

#912260
RE: SQL fn (convert(.......,............,) as xxx

What is the datatype of p.birth_date? Can you provide a few sample values?
^{“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

December 14, 2008 at 8:33 am

#912195
RE: Which is better

Lynn Pettis (12/12/2008)
Jack Corbett (12/12/2008)
I like tabs and I use 6 and I like to set it to 6 even if I change set it to use spaces. One...
^{“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

December 12, 2008 at 2:32 pm

#911922
RE: Are the posted questions getting worse?

Steve Jones - Editor (12/12/2008)
Why did this thread start?
I think Gail's on the Kalen track of working entirely too much. Guess that's why she goes to throw people around 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

December 12, 2008 at 8:32 am

#911675
RE: what is mean by '' ? + in where clause

karthikeyan (12/12/2008)
ok.
but if we have unordered data...what will happen ?
you sample data has ordered, so we no need to worry about the result...
i think we can use ORDERBY clause...but again...
^{“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

December 12, 2008 at 8:17 am

#911668
RE: what is mean by '' ? + in where clause

karthikeyan (12/12/2008)
ok.
but if we have unordered data...what will happen ?
you sample data has ordered, so we no need to worry about the result...
i think we can use ORDERBY clause...but again...
^{“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

December 12, 2008 at 7:08 am

#911611
RE: what is mean by '' ? + in where clause

Karthik, pick up a telephone directory sometime. Here's a hint or two:
DROP TABLE #t1
create table #t1 (name varchar(15))
insert into #t1
select 'Guna' union all
select 'Jonny' union all
select 'kamatchi' union all
select 'karthik'...
^{“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

December 12, 2008 at 6:46 am

#911599
RE: what is mean by '' ? + in where clause

karthikeyan (12/12/2008)
Any more inputs ?
What do you want to know?
Why should it be any different to
select * from emp where name > 'Karthik'?
^{“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

December 12, 2008 at 5:44 am

#911584
RE: How to convert detail data into columns?

Hi Herman
Here's a few more kids to play with:
INSERT INTO #KIDS(ID, REQ_ID, NAme, Birth_DAte)
SELECT 1,1,'Harry', '20010101' UNION ALL
SELECT 2,1,'Betty', '20020101' UNION ALL
SELECT 3,2,'Hank', '19991111' UNION ALL
SELECT...
^{“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

December 12, 2008 at 5:31 am

#911575
RE: insert currency name and symbol

in the recordset SELECTED for the user, or the server-side table?
^{“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

December 12, 2008 at 4:59 am

#911564

Viewing 15 posts - 9,136 through 9,150 (of 10,143 total)