RE: i should know this BUT.....
Showing my SQL Age substring(mystring,1,2) + '/' + substring(mystring,3,2) + '/' + substring(mystring,5,2)
2003-08-19
Aggregates
RE: Saturday Week Day
Actually, I changed it so instead of adding 7, I add 0. I was thinking that Saturday was still weekday 6, not 7.
2003-08-18
1 reads
RE: QOD 8/7/03
I think it is indicative of a poorly worded/minimally relevant question when only 12% of SQL Server professionals answer correctly. Unfortunately the choice that I would have selected if it had been available would be "Does this really matter?"
2003-08-08
1 reads
RE: QOD 8-4-2003 Disagree with answer...
Hi Scott, I guess that is one of those things I must not understand. I've downloaded my SP3 (a?) BOL update from M$ website. Now, where can I definitely see which BOL version I'm running? Cheers, Frank
2003-08-04
RE: float problems (with front-end Java app.)
Hi Michelle, sorry, just came across your response. quote: However, our test data was inserted for that example as: 0.054, but when a quick SELECT * FROM tblName is run.. we got the "funky" output 5.3999999999999999E-2 🙂 Another insert into the same field, different value: 0.106, come out just as it went in.. go figure […]
2003-07-29
RE: Dropping a PrimaryKey takes forever..
aha! Yes the PK is clustered..and on investigation I don't think it's a good candidate for it. I'll consider the non clustered approach for this key. Also, it was the first of all the index drops, so I've changed my code to drop all others first then lastly, the PK. Thanks for the advice.. I'll […]
2003-07-24
1 reads
RE: Join temporary table with another table
I am refering temp table from store procedure. I got 0 records back when I ran the query for sysobjects. Below is the temp table I am creating: CREATE PROCEDURE sp_temp_NumofEvents AS Create table #NumofEvents ( people_id numeric, site_name varchar(100), NumofEvents numeric ) Insert into #NumofEvents select distinct p.people_id, st.site_name, (select distinct count(event.event_date))as NumofEvents from […]
2003-07-24
RE: How to determine persons age
Whoops, I think I replied to one of those threads in a link. Out of curiousity, why do you need to be concerned with leap years when determining a person's age? Were you thinking about dividing days into years or something? This is how I'd do it: declare @bd datetime select @bd = '1976-12-2' select […]
2003-07-24
2 reads
RE: How to Encrypt or Decrypt .....
we had some encrypted procedures in a production system for a while. However when it came to troubleshooting it became a pain, as we couldn't be 100% sure of the version in production. so all new procedures going to the system are now unencrypted.
2003-07-16
1 reads
RE: Alternative for TOAD
What functionality are you looking for; perhaps if you explain what you're looking for, we could point you in the right direction. Any specific capability you need?
2003-07-11
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers