Viewing 15 posts - 61 through 75 (of 1,185 total)
I don't think the format is an issue UNLESS the data in your table is a VARCHAR, SQL should not care if you pass WHERE date = '2005-10-10 8:30AM' vs...
October 10, 2005 at 12:17 pm
How bout CASE WHEN FieldDt BETWEEN '2002-10-01' AND '2003-009-30' THEN 'FY2003'
May need to look at creating a xref table to house Month / Year in it along with Quarter and...
October 10, 2005 at 5:44 am
I would review the software design 1st. Are you using stored-procedures and NOT adhoc queries via the web? IF NO then this is a good time to change that. May...
October 7, 2005 at 1:13 pm
If this is not going to be a one shot pony make sure that the UPDATE doesn't update records that are already -3....
October 7, 2005 at 1:09 pm
As far as SQL is concerned IT doesn't care. HOWEVER,
As a general rule IF you start with the SMALLEST table and work outward your queries will run better. This will...
October 7, 2005 at 1:08 pm
This may not be SQL related however, we have already started working on addressing the issue here at my company.
Current logic (in a stored-procedure) is for START find 1st Sunday...
October 6, 2005 at 5:47 am
1. Data is inserted into Tables ??
2. AFAIK they should be equal. If they aren't there would be a problem because you would have deleted more rows than inserted...
October 6, 2005 at 5:41 am
I don't think you can access 64BIT from 32BIT. I know you can do the reverse however. Also, there are certain things that will not run in 64BIT only 32BIT...
October 3, 2005 at 6:34 am
Search here for row to column or PIVOT should help you find the threads to help you
October 3, 2005 at 6:03 am
It is. Search here for rows to columns or PIVOT or ... + in SQL 2k5 it is by using PIVOT keyword....
September 30, 2005 at 5:45 am
You could/can do may different things
September 28, 2005 at 6:56 am
It looks like Reporting Services is using SQL-DMO to pull reports. I would look at whatever application(s) that are set-up using RS and see when they run (possibly at 5...
September 28, 2005 at 6:51 am
SELECT * FROM [LinkedServer].DB.Owner.Table
WHERE NOT EXISTS (SELECT * FROM Production.DB.Owner.Table)
???? Possibly ??? See BOL for more information on NOT EXISTS (my syntax may need tweaking)
September 28, 2005 at 6:48 am
?!?!?!? IF I understand the question "I want to have VB.Net manage SQL backups" THEN the answer is Yes you can.
WHY you want to is another matter.
Research SQL-DMO for more...
September 28, 2005 at 6:46 am
Viewing 15 posts - 61 through 75 (of 1,185 total)