Viewing 15 posts - 226 through 240 (of 859 total)
kaushal_shah26 (8/1/2012)
capn.hector (8/1/2012)
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
August 1, 2012 at 3:25 pm
i have a couple of things in mind but i think the OP is looking for an UPDATE statement. the question i have is that i cant see why...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
August 1, 2012 at 3:06 pm
gordon.davis (8/1/2012)
Could you Please help me to get Output like below.
SNLabel StartDate EndDate
...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
August 1, 2012 at 12:59 pm
Here is the basic format to get the first and last day of the previous 3 months.
SELECT DATEADD (MM, DATEDIFF (mm, 0, GETDATE()) - 1 - N, 0), DATEADD (MM,...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
August 1, 2012 at 12:05 pm
I would look at http://www.sommarskog.se/dyn-search-2008.html as it describes exactly what you want to do. it also offers several ways to accomplish the task which are safe from sql injection...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 27, 2012 at 3:45 pm
JAZZ Master (7/27/2012)
jasona.work (7/27/2012)
SQLRNNR (7/27/2012)
Cliff Jones (7/27/2012)
capn.hector (7/27/2012)
Scott D. Jacobson (7/27/2012)
Perry Whittle (7/27/2012)
rhythmk (7/26/2012)
Cliff Jones (7/26/2012)
jasona.work (7/26/2012)
Ray K (7/26/2012)
crookj (7/26/2012)
Revenant (7/26/2012)
SQLRNNR (7/26/2012)
opc.three (7/26/2012)
Daniel Bowlin (7/26/2012)
BeginTRY
catch
END CATCH
Catch-All
Catch 22
Ketchikan
Alaska
Himalaya
Everest
Katmai
Kathmandu
Bob Seger
Bob Saget
BYOY
Tequila
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 27, 2012 at 3:39 pm
well now in the morning im even more embarrassed at the mistake i made.
on another note my head hurts, where is my aspirin.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 27, 2012 at 7:59 am
Scott D. Jacobson (7/27/2012)
Perry Whittle (7/27/2012)
rhythmk (7/26/2012)
Cliff Jones (7/26/2012)
jasona.work (7/26/2012)
Ray K (7/26/2012)
crookj (7/26/2012)
Revenant (7/26/2012)
SQLRNNR (7/26/2012)
opc.three (7/26/2012)
Daniel Bowlin (7/26/2012)
BeginTRY
catch
END CATCH
Catch-All
Catch 22
Ketchikan
Alaska
Himalaya
Everest
Katmai
Kathmandu
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 27, 2012 at 7:55 am
well no more tequila and coding late at night. just made an *** of my self.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 26, 2012 at 11:05 pm
dwain.c (7/26/2012)
capn.hector (7/26/2012)
------Almost pure moden splitter modified slightly to take a NVARCHAR(MAX)
and have a cteTally big enough and eliminate the OR when calculating the start of the string-----
------Aaron version...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 26, 2012 at 10:26 pm
Ok so here is the response im planning with code. i cant account for the major difference in time. as i state i make only minor changes to...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 26, 2012 at 10:14 pm
Jeff Moden (7/26/2012)
dwain.c (7/26/2012)
capn.hector (7/26/2012)
so now that jeff has posted his response shall the SSC Dog Pile commence??
Good idea. I was utterly dumbstruck by his performance ranking of the...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 26, 2012 at 8:25 pm
Jeff Moden (7/26/2012)
ChrisM@Work (7/26/2012)
WayneS (7/26/2012)
You'll might find this interesting: http://www.sqlperformance.com/2012/07/t-sql-queries/split-stringsVery interesting. Thanks, Wayne.
I know I enjoyed it. Gave me a chance to try out my new 4 band porkchop...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 26, 2012 at 7:56 pm
have you configured the windows firewall to allow SQL Server traffic? I have had that issue my self.
http://msdn.microsoft.com/en-us/library/ms175043.aspx
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 26, 2012 at 3:52 pm
SQLKnowItAll (7/26/2012)
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 26, 2012 at 3:37 pm
Viewing 15 posts - 226 through 240 (of 859 total)