Viewing 15 posts - 4,411 through 4,425 (of 9,722 total)
Stefan Krzywicki (5/17/2012)
GSquared (5/17/2012)
Stefan Krzywicki (5/17/2012)
Steve Jones - SSC Editor (5/17/2012)
Thanks to new data mining abilities I think I read that they have the ability, to 75% or 90% or...
May 17, 2012 at 11:40 am
If you want an answer, you should post the name of the solution you found and ask for reviews.
There are several third party tools and not everyone knows them all...
May 17, 2012 at 11:24 am
Unless you've been auditing the logins, there's no good way to tell. Nothing in the system, that I am aware of, can give you this information.
Sorry.
EDIT: On the other hand,...
May 17, 2012 at 11:22 am
John,
Gail is asking you to save the execution plan as a .sqlplan and attach it to your post. Do you know how to do this?
May 17, 2012 at 11:21 am
You are welcome.
Just an FYI, though. You posted your question in the wrong group. Try General under 2008 or Business Intelligence under 2005 (which covers both 2k5 & 2k8).
May 17, 2012 at 11:19 am
Hey, Steve, can you change the birth year in my profile to read 1776, please?
😀
May 17, 2012 at 11:06 am
Revenant (5/17/2012)
Stefan Krzywicki (5/17/2012)
Steve Jones - SSC Editor (5/17/2012)
Thanks to new data mining abilities I think I read that they have the ability, to 75% or 90% or something like...
May 17, 2012 at 11:06 am
In SSIS, you can use a MERGE JOIN transformation task, I believe. Or you can use Slowly Changing Dimensions. It depends on your business rules, etc.
Check them out in...
May 17, 2012 at 11:02 am
Here's another method:
CREATE TABLE dbo.BrandieTemp (MyID INT NOT NULL, TestCol1 VARCHAR(35),
TestCol2 VARCHAR(10));
GO
INSERT INTO dbo.BrandieTemp (MyID, TestCol1, TestCol2)
VALUES (1,'Mickey','Mouse'), (2,'Donald','Duck'), (3,'Goofy','who?');
SELECT MyID, TestCol1, TestCol2
INTO #MyTemp
FROM dbo.BrandieTemp;
ALTER TABLE dbo.BrandieTemp
...
May 17, 2012 at 10:53 am
Eugene Elutin (5/17/2012)
Brandie Tarvin (5/17/2012)
...I'm a little confused. Why don't you just ALTER the table and set AllocationID as an IDENTITY field? You wouldn't have to fuss with variables, then.
Could...
May 17, 2012 at 10:49 am
Have you Googled the first part of the error?
Also, this may not be related to the actual report but something to do with your hardware or software.
May 17, 2012 at 10:42 am
Alexeins (5/17/2012)
1)
DECLARE @L_ZERO INT
SELECT @L_ZERO = IdMyTable FROM MyTable WHERE ColumnRef = 1000
SELECT ISNULL(@L_ZERO, 0)
OR
2)
DECLARE @L_ZERO INT
SET @L_ZERO = ISNULL((SELECT IdMyTable FROM MyTable...
May 17, 2012 at 10:38 am
SJanki (5/17/2012)
AllocationID is a PK.
Depending on certain condition I have to insert multiple records in Allocations table.
I get the...
May 17, 2012 at 10:35 am
I tasted homemade grape schnapps one summer when I was in Austria. Delicious! I need to go find a good recipe for it to see if I can make it...
May 17, 2012 at 6:43 am
saidapurs (5/16/2012)
May 16, 2012 at 10:37 am
Viewing 15 posts - 4,411 through 4,425 (of 9,722 total)