I took out your variable for my testing so you will need to add it back in... Anyway, I think this does what you need - eventhough it is extremely ugly. I would keep looking for a better way to do it. I don't think this will be very effecient.SELECT r.year, r.qtr, r.industry_code FROM rpt_calc_data […]
2005-02-21
Frank - I understand. We are planning another addition to our family and I share the household duties. The wife works (sometimes longer hours than I do). I, too, have the stories - Cinderella and Snow White are big, my favorite Alice was kind of a dud.
2005-02-14
Morning AllWhen I run the following TSQLselect * from sysdatabasesit give me the location for my master Database asd:\mssql\MSSQL\data\master.mdfHowever, if I check the Db properties through Enterprise Manager, it reports it asd:\sql\MSSQL\data\master.mdfBoth files exist, have virtually the same timestamp, and are the same size. How do I establsh which is correct?ThanksGary
2005-01-31
At the risk of being accused of being facetious, here are the differences between C# and VB.NET:- C# uses { and } to delimit blocks, whereas VB.NET generally uses new lines and tokens that are English wordseg if (condition) { true-block } else { false-block }versusIf condition Then true-block Else false-block End If- […]
2004-12-16
Thank you for the input. I was wondering how often DBA's reboot their sql server boxes? Should this be done on a regular basis or only as needed for upgrades, security updates, etc.Juanita
2004-11-16
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers