Viewing 15 posts - 1,021 through 1,035 (of 1,241 total)
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
UserDatasourceFact
UserID | SourceID
1 | A
2 | A
I have Project Dimension Table:
Project ID | Source
P1 | A
P2 | A
P3 | B
I am wondering if the projects table can serve as a...
----------------------------------------------------
May 2, 2014 at 2:04 pm
Don't know that you install one, they are created within SQL Server. Start with planning what you expect the size to grow to in the future. For each potential table...
----------------------------------------------------
May 2, 2014 at 11:59 am
Viewing 15 posts - 1,021 through 1,035 (of 1,241 total)