No idea which engine yet, we are just investigating ways to improve the speed of the result set.

Anything from NoSQL to the use of CUDA programming.

Hi everyone

Just to let you know what I did.

I created a XLS template with the headers and a hidden/formatted row, this just formats the actual numbers etc. You still need...

the problem with the left join option is that if its not in any of the tables, it will bring back all the records of the main product table, which...

[EDIT]

Ok, after looking at the queries I noticed that its not going to work as the search string needs to be present in all 3 tables.

How would I go about...

Hi there,

I believe a full join would do the trick?

SELECT DISTINCT Main_Account, Primary_Account

FROM #Table_A a FULL JOIN #Table_B b

ON a.Main_Account = b.Primary_Account

Just a note on your IncidentDate...if you specify...

Thanks for the extensive reply Tom, appreciate it.

I think I will go with option 3 then as this allows for better scale-ability in case another category level gets added...

Thanks Howard, when I posted the OP, I went and created a package_variable table, with the ssis task, variable and value and using that to populate and update the variables.

works...

ok, so I have setup my first SSRS project with one report. I have deployed this and can access it via a URL to my reporting server (Report Manager) This...

Thanks Scott

But is it easy to access the reports created with SSRS via a .Net website?

My guess is it would be? Starting this project on Monday.

sorry for the bump, but I would really like to find a solution for this.

There has to be a way that I can make the recordreference part of contributor element...

You can do this by just asking for the data row, in your application, if you dont get any results, you know the login failed

CREATE PROCEDURE [dbo].[sp_check_login]

@username VARCHAR(100),

@password VARCHAR(50)

AS

SELECT l.loginid,...

thanks guys

been doing .Net and SSIS kind of stuff most of my career, been looking into SSAS and SSRS the past month or so, looks like a very interesting field...

We don't have an official DBA, or actually I'm doing everything myself *hides

So I guess to answer your question, there are no traceflags as I haven't setup anything.

Server and all...

Hi GilaMonster

Both db's are on the same server, I was using a normal SQL Script Task, will change it to a DataFlow Task.

I rebuilt the clustered index and ran the...

thanks for all the help Tom, will troubleshoot and let you know.