tHINK iM CLOSE BUT GETTING A CONVERSION ERROR

DECLARE @FISCALDATE DATE

DECLARE @ENDDATE DATE

set @ENDdate = '02/01/2012'

SELECT CASE

...

yes keywords etcc..

I did write a small view then created a job then creates a table from the view

Since its a report server I can run the job overnight...

Thanks for the response,

This may work but I don't think I explained it correctly.

Here is a snippet:

SELECT TOP (100) PERCENT dbo.Client.ID, dbo.RECORDED_SERVICE.STARTTIME, dbo.ClientPayor_Eligibility_Detail.Effective_As_Of_Date

FROM ...

I think I solved it.. I had get values from a query checked in my parameter...

WOW this is so different from Crystal... at least for now!!! lol

Thanks

Thanks for the response, not sure if its the best way , but came up with this using excel:

INSERT INTO dbo.PROVIDER_TO_TRUSTED_PROVIDER_COLLECTION (OID, OID_LINK) VALUES('002771F071C541F4B5478D246381E7E7','CB30DF919B0F468AB203FFD848D11463');

INSERT INTO dbo.PROVIDER_TO_TRUSTED_PROVIDER_COLLECTION (OID, OID_LINK)...

thanks for the quick reponse..

so I have to setup a bunch of selects for each OID in the tabe?

SELECT PROVIDER_TO_TRUSTED_PROVIDER_COLLECTION.OID, PROVIDER_TO_TRUSTED_PROVIDER_COLLECTION.OID_LINK

FROM ...

Thx good advice.. have a great day

U7

Thanks

SO this works!!!

Client.LName + ', ' + Client.FName + ' -' + cast(client.ID as nvarchar) as ClientName

Thanks... fixed it. dumb on my part... thanks

I don't know whats going on with the nolicks, I inherited this.

to be honest, newer at this and not sure what it does,...

Than you.. works great!!

yes definitly datetime, double checked to make sure I haven't lost it.... lol

Mark.. do u hate me yet !! 🙂

Ok so this is what I have and What I "Want" to do....

Want: I want to update recorded_service.starttime with user_defined_data.lastmodifed and ...

Hi Mark,

Sorry I really s*ck at this...

I have this:

declare

@Now smalldatetime,

@NowPlus10Mins smalldatetime

set @NowPlus10Mins = dateadd(MI, 10, @Now)

select @Now = user_defined_data.LastModified

FROM dbo.RECORDED_SERVICE

LEFT...

Hey Mark, thanks for the quick response

I was a bit confusing..

lastmodified is a date on the table

can I use

declare

@Now smalldatetime,

@NowPlus10Mins smalldatetime

set @Now = lastmodified

set @NowPlus10Mins = DATEADD(MI, 10, lastmodified)

update your...

Hope this helps with my ??

Sorry and thanks

Output looks like this

StatusTotal Count0 - 30 Days31 - 60 Days61 - 90 DaysMore than 90 Days

Onhold46 ...