Simple example

The code below is what you would use to test your results

DECLARE @clientage varchar(10)

set @clientage = '26'

select name, age, gender

from customer

where age = @clientage

This is how it...

Thanks for all the replies much appreciated

@ weitzera your spot on I've changed the other parameters to null and its finally returned data in the 'Query Designer' window, thanks for...

Many thanks for your reply

@Neal I've checked through the parameters in SSRS and that doesnt seem to be the problem. I've attached a word document of the steps that...

Thanks for your reply Lowell and kvishu83

@lowell its just a portion of the SP I've created. You are completely right with your advise it has solved the problem:-)...

@j-2 Livingston SQL many thanks for the script that is exactly what i needed.

@ Ninja's_RGR'us want I wanted is to subtract 1 month from the capture date...

Hey SQL Ninja thanks for are help and all who replied

I used the following which has worked perfectly

BULK INSERT Test.dbo.CSVTest

FROM 'C:\csvtest.txt'

WITH

(

...

I'm not too sure what you mean by your second point, are you saying i should remove that line

BULK

INSERT Test1

FROM 'c:\csvtest.txt'

WITH

(

FIELDTERMINATOR = ','

)

GO

Thanks i tried to do a dummy bulk insert but i cant seem to get it to work. Can you have a look at let me know where I'm going...

I'm not to sure how you go about using bulk insert or OPENROWSET. Do you have any info for a beginner on this??

I've got services running shown in the imagine that i've attached.

I've completely uninstall and reinstalled SQL Server now, i'm in the process of installing SQL service pack 3

i'll let...

Never came across a way to turn on labels but i would suggest clicking on the chart type such Line or bar then placing your cursor over the image again....

It could be two reasons

1) A config issue

2) You lost connection to your server so when you tried to perform an action the error message appeared - 401.1:...

Thanks for your reply Jayanth_Kurup

At the moment there is no error message because there is no instance for me to connect

I've attached an image of what i'm viewing

Your right didn't spot that one works perfectly thanks

I've done the google search and i understand that SSRS only uses the column names as a key not the table + column names. I've changed it to the following...