Viewing 15 posts - 451 through 465 (of 859 total)
Can you post the complete Create table statement and Insert statements for your tables? Please see the link in my signature for directions.
The reason i ask is im wondering...
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]
April 23, 2012 at 5:51 pm
Lynn i continue to learn from you. my kludge looks awful compared to the datemath you did. {facepalm} for not realizing i could just add 9 months 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]
April 23, 2012 at 5:27 pm
crookj (4/23/2012)
EL Jerry (4/23/2012)
SQLRNNR (4/23/2012)
crookj (4/23/2012)
Daniel Bowlin (4/23/2012)
L' Eomot Inversé (4/20/2012)
crookj (4/20/2012)
WOTD - PerennialEphemeral
unending
Neverending
abending
BSODing 🙂
BYODing 🙂
voiding
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]
April 23, 2012 at 4:37 pm
cidr (4/23/2012)
Date Fiscal_Year Identifier
30-Mar-11 11-12 ...
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]
April 23, 2012 at 4:13 pm
i think this get you what you want. being that i guessed your fiscal year column is a char or varchar field it got ugly. if you convert...
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]
April 23, 2012 at 3:33 pm
Grant Fritchey (4/23/2012)
And I'm out.Oh well, you can't say I didn't try.
im going to let it die at my last comment. yelling at grant insulting Lynn. thats 2,...
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]
April 23, 2012 at 2:41 pm
riya_dave (4/23/2012)
I AM ALREADY PUTTING IT INSIDE CURSOR BUT ITS REPEATING AGAIN AND AGAIN
those of us who know the threads know you are putting what ever you are trying 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]
April 23, 2012 at 2:23 pm
SQLKnowItAll (4/23/2012)
Jeff Moden (4/23/2012)
capn.hector (4/23/2012)
+1 however i saw this same question as homework for one of my sql classes.
Interesting! Where did you take such a class?...
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]
April 23, 2012 at 12:21 pm
polkadot (4/23/2012)
nope, it's different. That one wants the first segment of the path ie. Beverages. This one wants what comes after.http://www.sqlservercentral.com/Forums/Topic1281987-392-1.aspx
yep your right, off to modify that code real...
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]
April 23, 2012 at 11:46 am
all ready been posted im looking for the thread now.
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]
April 23, 2012 at 11:42 am
just upgrading should work after reading the liscense requirements with all I Am Not A Lawyer caveats. however you should back up your master msdb and user databases (Might...
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]
April 23, 2012 at 9:34 am
dwain.c (4/22/2012)
I believe the following will get you what you want although I played a bit fast and loose with your problem description.
--Create a table to hold the data.
DECLARE @tbl_Data...
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]
April 23, 2012 at 8:44 am
GSquared (4/23/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]
April 23, 2012 at 8:33 am
andersg98 (4/20/2012)
This is a job for SSIS.
+1 however you could also bulk insert into a staging table and use substring functions to break your data into the correct columns and...
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]
April 20, 2012 at 8:48 pm
what is the end time you are using to figure out the difference in min. and can you post the DDL and Sample data in a more consumer...
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]
April 20, 2012 at 7:00 pm
Viewing 15 posts - 451 through 465 (of 859 total)