Hi

What version of SQL server are you attempting to run the dtsx package from, and what version of vs studio was the dtsx created in?

Hi

Within Reporting Services there is a Global variable called [UserId].

You will need to create a report parameter and assign its default value to use the [UserId] global variable. You...

Hi

Could you provide some more detail such as what information are you wanting to return about the user & what application are you using e.g are you using reporting services.

Hi

Can you reply with a sample of your code? What application are you writing this in?

Thanks

-Matt

Hi

My mistake I missed some info out of my previous example.

SELECT T1.ADID, T1.COUNTRY, ISNULL(T1.STATE,'the text you want instead of NULL')

FROM yourtable AS T1

Hi

If I've understood you correctly, you are wanting to replace a NULL value in a SELECT statement, try using ISNULL, e.g.

SELECT ISNULL( , 'string')

Have a look at IsNull in books...

Hi

I had a similar scenerio - where files were being created every few seconds.

The solution I used was to create a Windows Service, which utilised FileSystemWatcher component, which watched...

Hi Jim

Not sure if this fully resolves your problem, but you maybe able to adapt the code.

I've used the following to create a 'pop-up' window in a Reporting Services...

Hi

You could try using a report subscription to email the report. The subscription will run based on a schedule.

Thanks

-Matt

Hi

You could try setting defaults on each of your report parameters. Set the default parameter value to '%' , your WHERE clause would then look something like this:

WHERE region...

Hi

You could try creating a seperate report for each chart, then add these as subreports to a 'parent' report arranging them in the layout you desire.

Hi

If you are using SQL2005, have a look at the PIVOT function in Books on-line.