Viewing 15 posts - 2,776 through 2,790 (of 9,643 total)
Well you can have as many WHEN statements in a CASE as needed and you CAN nest CASE statements. This can get ugly and hard to maintain so you...
September 22, 2010 at 7:57 am
What does SELECT @@LANGUAGE return? Date Formats are set based on the server's language setting.
Can you share the actual offending code? The table definitions would help as well.
September 22, 2010 at 7:46 am
You have to use CASE in a select or update statement. I think what you want is something like this:
Update
tbl_UL
Set WR = vtbl_Combined.BW
From
...
September 22, 2010 at 7:41 am
This is a bit simpler and uses the newer objects in the SYS schema:
SELECT
SM.definition
FROM
sys.triggers AS T JOIN
sys.sql_modules AS...
September 22, 2010 at 7:35 am
There's no way I know of to do this in T-SQL as least not easily. I think it can be done using PowerShell. You should check out the...
September 22, 2010 at 7:28 am
I have this one in my office, and unfortunately the the second part is way to accurate for my office.
September 22, 2010 at 7:21 am
I'd agree that SSIS is probably the best way to go, depending on what the processing is that you need to do. Are all the databases on the same...
September 22, 2010 at 7:17 am
The easiest way to do this is to use something like SQL DataCompare.
The only way to do this without resorting to some type of dynamic SQL is something like this:
Select
...
September 22, 2010 at 7:14 am
So you only want to create the delete statements from the SSIS package?
Why not do the delete within the SSIS package? You can do an Execute SQL...
September 22, 2010 at 7:05 am
Can you post the table structures, including indexes?
It looks like the issue with the "slow" plan is because it is doing a NESTED LOOPS join.
I definitely think indexes can fix...
September 22, 2010 at 7:00 am
I believe, that because you are accessing other databases, you need to sign the procedure with a certificate. I don't think EXECUTE AS will work. See this article...
September 22, 2010 at 6:29 am
rushi.reddy (9/22/2010)
Thnx a lot, the link of Glenn Berry's u have given is really useful for me. Can you please send me the same for sql server 2000...
September 22, 2010 at 5:50 am
CirquedeSQLeil (9/21/2010)
RichardDouglas (9/21/2010)
I'm sure there's some BI peeps here who'll slice & dice the posting stats for the last 30 days and produce odds from that.
don't even need to go...
September 21, 2010 at 9:28 pm
That script returns any dropped objects. The ObjectType column tells you what type of object was dropped.
No, the database does not need to be in the Full...
September 21, 2010 at 9:44 am
ricardo_chicas (9/21/2010)
September 21, 2010 at 9:40 am
Viewing 15 posts - 2,776 through 2,790 (of 9,643 total)