Viewing 15 posts - 1,006 through 1,020 (of 1,228 total)
For your third question >
http://msdn.microsoft.com/en-us/library/ms130214(SQL.105).aspx
Don't forget about Books online as this continues to be a valuable resource. Since you have a background things will come back, learning the new...
May 20, 2014 at 5:39 pm
I know this is a SQL forum, but for crazy Excel imports, I've found creating macros in VBA to be very helpful. One can move the data to a new...
May 20, 2014 at 5:30 pm
Will this work if the next time you get "This is effective as of May 5, 2014" ? - just giving a heads up in case you are using a...
May 20, 2014 at 5:23 pm
In SSIS 2008, you can right click the Project (top node) in the VS solution explorer. From there go to Properties , Debugging , Run64BitRuntime... set this property to false....
May 20, 2014 at 5:17 pm
Fantastic solution Lowell, I reckon you meant
WHERE Datediff(dd, T1.discharge_date, T2.admit_date) < 30
?
May 20, 2014 at 4:58 pm
If you look at the execution plan of a query using the BETWEEN operator you will see that it is converted to a >= and <=.
Good Point, thanks.
May 20, 2014 at 4:36 pm
You don't necessarily need to use a join, try the WHERE EXISTS clause. Look it up on MSDN.
May 20, 2014 at 2:06 pm
I've come across somewhere that using BETWEEN is slower that actually using the less than/greater than operator. I have not done any testing on it. Any quick feedback on...
May 20, 2014 at 2:00 pm
It would be good to investigate how the tables are joined, are the indexes appropriate, is it fast when you call it from ssms? As mentioned by others taking the...
May 19, 2014 at 5:55 pm
The query is going to return a result to the screen from your select and the insert two columns into your non temp table. If you want to automate email...
May 19, 2014 at 5:51 pm
A typical update using a IF could look like
IF (month(getdate())=4)
begin
update t1
set t1.columnA=t2.columnA
from table1 as t1 inner join table2...
May 16, 2014 at 5:38 pm
Were you disabling your indexes when employing SSIS? Or only when using t-sql?
May 16, 2014 at 5:19 pm
You don't need a script task to export a table in SSIS , chose a dataflow task within SSIS. Make ole db the source and make a flat file...
May 9, 2014 at 5:46 pm
Do you have anything configured under report properties for available values and default values that might cause this behavior?
May 7, 2014 at 3:26 pm
LutzM (5/3/2014)
...which is refrenced across 63 columns in 40 + tables...
Just wondering: Why is a PK column refernced by more than one column of another table?
There are cases when it...
May 4, 2014 at 1:07 am
Viewing 15 posts - 1,006 through 1,020 (of 1,228 total)