Viewing 15 posts - 1 through 15 (of 23 total)
I am looking into this now to see if I can get it doing what I need... But right now it's pulling 4 rows, each one with a different provider...
May 9, 2011 at 12:07 pm
Ninja's_RGR'us (5/9/2011)
You need to correlate the base query with the column's subquery so that you only get 1...
May 9, 2011 at 11:50 am
I just want to thank you guys... You have been a huge help.... I have been reading up a lot on this stuff, but to see my data and the...
May 9, 2011 at 11:49 am
No need to loop. Look at my sample again.
I know there is no need to loop.... Please look at my question again... It is about adding it to the...
May 9, 2011 at 11:44 am
Bear with me... I know I'm a newbie... But would I just assemble the needed sql statement to assemble my string then join it in on the bottom with a...
May 9, 2011 at 11:35 am
I've seen context like this, and was reading up on it... But can I join something like that into what I have above, or will I need to pull that...
May 9, 2011 at 11:32 am
Ok...
So now... Imagine we pull the recordset above... Then in a loop a have another select (the clientid of 11145 would normally equal the clientid from last select)
SELECT Deductions.PolicyNumber1,Deductions.Amount,Deductions.ProviderID,
Providers.Name,Deductions.GroupID,Providers.ProviderID...
May 9, 2011 at 11:28 am
Ahhh Ha!
Ok.... Runs fine on my server. Must be from using the express version on my local pc...
Microsoft SQL Server Management Studio9.00.4035.00
Microsoft Analysis Services Client Tools2005.090.4035.00
Microsoft Data Access Components (MDAC)2000.086.3959.00...
May 9, 2011 at 11:20 am
Ninja's_RGR'us (5/9/2011)
Lowell (5/9/2011)
Ninja's_RGR'us (5/9/2011)
It's definitely possible, but if he could run my create db code, then I don't see why it would fail there (never seen that before).
The only thing...
May 9, 2011 at 11:14 am
Lowell (5/9/2011)
mikeincape (5/9/2011)
Yes... This gives me the dataset I need. Thanks!... Still getting that weird error though... Any Ideas?
Ninja's is going to kick me for repeating what he already proved...
May 9, 2011 at 11:11 am
Are you using any 3rd party application that refactors sql?
Using SQL management Studio to execute the queries you are sening me... No 3rd party apps anywhere.
Also, we've done it by...
May 9, 2011 at 11:06 am
Invalid Column Name 'RW' on the most recent sql query from Lowell
May 9, 2011 at 11:04 am
Yes... This gives me the dataset I need. Thanks!... Still getting that weird error though... Any Ideas?
May 9, 2011 at 10:59 am
I posted Lowell's code straight to SQL Management Studio... Added the comma
SELECT
cl.RecordStatus,
cl.ActiveClient,
cl.SystemEffective,
cl.Firstname,
cl.Lastname,
cl.MiddleI,
cl.SSN,
cl.ClientID,
...
May 9, 2011 at 10:57 am
Viewing 15 posts - 1 through 15 (of 23 total)