Viewing 15 posts - 1,006 through 1,020 (of 1,231 total)
Perhaps the OP simply forgot to include the other cases in the where clause
ChrisM , If I can borrow your code...
Use ProdDB
SELECT TOP (100) PERCENT
[Prod No] = p.ProdNo,
[Prod...
May 21, 2014 at 6:03 pm
Just want to mention that I have an old fashioned way of dealing with no data. Be mindful that your report viewers may want to see items that 0 counts,...
May 21, 2014 at 5:40 pm
SSIS is a great tool.Once you connect to your data source within a dataflow task you can create a derived column. Here there are built in string and other operators...
May 20, 2014 at 10:07 pm
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
Viewing 15 posts - 1,006 through 1,020 (of 1,231 total)