Viewing 15 posts - 24,331 through 24,345 (of 26,490 total)
gomikem (8/26/2008)
How do I convert the following from SQL to T-SQL?>=Now()-14
I've looked all over the internet and I can't find anything that I'm sure is working correctly. Thanks!
>= dateadd(dd,...
August 26, 2008 at 3:57 pm
bhovious (8/26/2008)
August 26, 2008 at 11:45 am
Could you provide the DDL (create statements) for the table, some sample data for the tables (in the form of insert statements that can be cut, paste, and run to...
August 26, 2008 at 9:45 am
Jeff Moden (8/25/2008)
skenzie (8/25/2008)
August 25, 2008 at 10:01 pm
Hopefully, I'd do the right thing. I have been in such a situation. I was working for a computer manufacturer many yers ago as a computer operator. ...
August 25, 2008 at 4:01 pm
Right and Wrong. Black and White in my book. Shades of gray occur in implementation, also known as justification. Sometimes, you have to agree to disagree.
If you...
August 25, 2008 at 2:43 pm
Perry Whittle (8/25/2008)
Lynn Pettis (8/25/2008)
why the joins, group bys, and having count(*) >the group by would be required for the count function i think
True, but my knowledge of the...
August 25, 2008 at 2:19 pm
Yelena Varshal (8/25/2008)
Steve Jones - Editor (8/25/2008)
August 25, 2008 at 1:56 pm
marius.draganescu (8/25/2008)
It's not all the "distinct" records I need to return, it is all records with a duplicate SSN that I am interested in. I tried the query, and it...
August 25, 2008 at 12:14 pm
If you are looking for distinct rows (based on the sample data), why the joins, group bys, and having count(*) > 1? I'd think the following would work just...
August 25, 2008 at 10:37 am
Timothy (8/25/2008)
Jack Corbett (8/25/2008)
August 25, 2008 at 10:13 am
If you can, I'd test on a much smaller database. If you have access to SQL Server 2005 Developers Edition ($50 USD), you could install it on your desktop,...
August 22, 2008 at 4:02 pm
Yamachari (8/22/2008)
August 22, 2008 at 3:58 pm
Then I would carefully test the use of the COPY_ONLY. One of two things will happen. One, it won't work. Two, you may not be able to...
August 22, 2008 at 3:51 pm
Be careful with the COPY_ONLY option. You may not get what you are expecting. I am assuming that the file group backup is being taken for DR purposes.
😎
August 22, 2008 at 3:37 pm
Viewing 15 posts - 24,331 through 24,345 (of 26,490 total)