ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,231 through 7,245 (of 10,143 total)

RE: Date Format

LIYA (10/6/2010)
insert into DateFormat
select '2010-06-18 07:33:17' union all
select '2010-06-18 07:40:18' union all
select '2010-06-18 18:40:10' union all
select '2010-06-18 14:45:17' union all
i need the result as follows
Wdate
18/06/2010 07:33:17 AM
18/06/2010 07:40:18...
^{“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

October 6, 2010 at 6:03 am

#1232424
RE: Are the posted questions getting worse?

GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx
No, not at all. You're telling it like it is.
^{“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

October 6, 2010 at 5:28 am

#1232388
RE: Are the posted questions getting worse?

Brandie Tarvin (10/6/2010)
Chris Morris-439714 (10/6/2010)
Brandie Tarvin (10/6/2010)
BrainDonor (10/5/2010)
When I die I'm donating my body to science-fiction.
Oh, is that a promise? I could use a few more cadavers...
@=)
More??? The next...
^{“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

October 6, 2010 at 5:03 am

#1232367
RE: Are the posted questions getting worse?

Brandie Tarvin (10/6/2010)
BrainDonor (10/5/2010)
When I die I'm donating my body to science-fiction.
Oh, is that a promise? I could use a few more cadavers...
@=)
More??? The next question is kinda obvious...
^{“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

October 6, 2010 at 4:55 am

#1232357
RE: Update query

With this number of rows to update, batching becomes attractive. Here's one way to do it, there are many.
-- Assumes trans_headerID is pk for table
UPDATE t SET CARD_NO = left(card_no,6)+'******'+right(card_no,4)...
^{“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

October 6, 2010 at 4:35 am

#1232348
RE: Where are you?

juliekenny (10/5/2010)
Suffolk
England
(UK)
St Peter's brewery! Nice!
^{“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

October 6, 2010 at 2:25 am

#1232301
RE: getting error in where condition in stored procedure

Why don't you put your dates into your table source instead? Like this:
'FROM
(SELECT HeadCount,
StartDate FROM SAR_HeadCount where CampaignID = ' + @CampaignID +
' AND StartDate IN (' + @date1...
^{“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

October 5, 2010 at 10:17 am

#1231878
RE: getting error in where condition in stored procedure

naresh0407 93367 (10/5/2010)
Hi Chris,
Can u tell where i can u in the above stored procedur.
Naresh, I'm sorry - can...
^{“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

October 5, 2010 at 10:01 am

#1231859
RE: Are the posted questions getting worse?

A guess would be a null value for CMD_File_Date_Loaded in the third table, but to paraphrase JBM "a developer should 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

October 5, 2010 at 8:53 am

#1231769
RE: Are the posted questions getting worse?

Alvin Ramard (10/5/2010)
Is it time to implement some sort of entrance exam for SSC? After reading the question I actually spent a few minutes staring at the screen thinking...
^{“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

October 5, 2010 at 8:42 am

#1231759
RE: Import unprocessed rows only

How do you detect whether or not a row from staging has been "processed"?
What is table [dbo].[Files] for? You haven't mentioned it in your dialogue.
^{“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

October 5, 2010 at 8:37 am

#1231755
RE: getting error in where condition in stored procedure

naresh0407 93367 (10/5/2010)
Hi,
In the above stored procedure if i dont have HeadCount for particular date i am getting value as null but...
^{“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

October 5, 2010 at 7:53 am

#1231710
RE: getting error in where condition in stored procedure

StartDate FROM SAR_HeadCount where CampaignID=' + CAST(@CampaignID AS VARCHAR) + ')
@CampaignID is out of scope otherwise.
^{“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

October 5, 2010 at 7:43 am

#1231701
RE: Today's Random Word!

Giant carnivorous mice
^{“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

October 5, 2010 at 7:35 am

#1231694
RE: Today's Random Word!

tosscrosby (10/4/2010)
John Rowan (10/4/2010)
Org.....uh, nevermind.
I hesitated on that one too!
_{Was it her birthday?}
^{“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

October 4, 2010 at 10:12 am

#1231108

Viewing 15 posts - 7,231 through 7,245 (of 10,143 total)