Viewing 15 posts - 691 through 705 (of 859 total)
mohammed moinudheen (4/4/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 4, 2012 at 7:26 am
please continue discussion in the original topic so your question does not get fragmented accross multiple threads.
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 4, 2012 at 7:15 am
duplicate post discussion is here
http://www.sqlservercentral.com/Forums/Topic1277841-391-1.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]
April 4, 2012 at 7:14 am
if what jeff posted is not what you were looking for, here is the link to the microsoft download of the northwind and pubs sample databases.
http://www.microsoft.com/download/en/details.aspx?id=23654
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 3, 2012 at 9:35 pm
just talked to my girlfriend she left the truckstop that got hit just down the road from the schneider yard about 20 min before the tornado came through. 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 3, 2012 at 9:27 pm
Lynn Pettis (4/3/2012)
capn.hector (4/3/2012)
lukebaker (4/3/2012)
I have reformated the dates in my table and used the below query and it worked 🙂
SELECT *
FROM v_stafftrainingDetails
WHERE (expiry_Date...
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 3, 2012 at 4:22 pm
Lynn Pettis (4/3/2012)
Evil Kraig F (4/3/2012)
Lynn Pettis (4/3/2012)
The Dixie Flatline (4/3/2012)
Lynn Pettis (4/3/2012)
Some people really shouldn't be allowed near SQL Server systems.I too resemble that remark.
Not you either, but I...
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 3, 2012 at 4:09 pm
pixelwiz (4/3/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 3, 2012 at 4:06 pm
lukebaker (4/3/2012)
I have reformated the dates in my table and used the below query and it worked 🙂
SELECT *
FROM v_stafftrainingDetails
WHERE (expiry_Date >= DATEADD(dd, DATEDIFF(dd,...
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 3, 2012 at 2:58 pm
No problem
original / thread with replies is at http://www.sqlservercentral.com/Forums/Topic1277637-391-1.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]
April 3, 2012 at 2:53 pm
Lynn Pettis (4/3/2012)
GilaMonster (4/3/2012)
Lynn Pettis (4/3/2012)
Some people really shouldn't be allowed near SQL Server systems.Wasn't me. Haven't been near a real server all day.
Nope, not you either.
cant be me, i...
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 3, 2012 at 1:06 pm
Stefan Krzywicki (4/3/2012)
GSquared (4/3/2012)
capn.hector (4/3/2012)
GSquared (4/3/2012)
Brandie Tarvin (4/3/2012)
Revenant (4/2/2012)
AUI, meaning Administering Under Influence.
Isn't that illegal?
I'm sure there's some sort of law against that... Or is the law for it? I...
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 3, 2012 at 12:01 pm
GilaMonster (4/3/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 3, 2012 at 11:58 am
dcsurfer67 (4/3/2012)
Is it possible to increase the size of the DB on the fly without messing anything up?
that is exactly what the auto growth does, when it hits the limit...
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 3, 2012 at 11:56 am
SQLKnowItAll (4/3/2012)
Cadavre (4/3/2012)
S_Kumar_S (4/3/2012)
I need a query(or function) that filter the names(column name) which have consecutive 3 alphabets. basically I want to filter out those garbage names. e.g. sabcmm has...
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 3, 2012 at 11:47 am
Viewing 15 posts - 691 through 705 (of 859 total)