Wednesday, June 26, 2013

[SQL Server] General Question

[SQL Server] General Question


General Question

Posted: 26 Jun 2013 02:56 PM PDT

Hi Every One, Can we implement/run an application with huge data without using any database like oracle,ms sql etc..is there any way to run an application like CDSS(CLinical Decision support system) what i heard they never used any database...any one has any idea????Thanks..

SSRS / IsNothing problems

Posted: 10 Jun 2013 08:57 AM PDT

I'm trying to write an expression in SSRS to allow for different fields to display based on the result set. This example is for the Title line, and obviously it would be adjusted for the row containing the data. [u]Objective:[/u]if SectionCategory is null and SectionType is null, then nothing;if SectionCategory is null and SectionType is not null, then "Type"'if SectionCategory is not null, then "Category"[u]Expression:[/u]=switch( Fields!SectionCategory.Value is nothing and Fields!SectionType.Value is nothing, nothing, iif (Fields!SectionCategory.Value is nothing and (IsNothing(Fields!SectionType.Value)="No"), "Type", nothing), iif ((IsNothing(Fields!SectionCategory.Value)="No"), "Category", nothing) )Is it possible to nest IIF statements in a Switch statement? I've experimented several different ways and I'm getting "#Error" in Preview.

Return sepcifc data on query

Posted: 26 Jun 2013 02:37 AM PDT

If I run a query to return an email address from an emails replied to, I get some returnes with multiple email addresses with the email address I want at the end. Example - Service, Customer Support, Customer123@provider.comHow do I remove the info I don't want in these rows but not affect the other rows that are correct?

ERD Lookup

Posted: 26 Jun 2013 07:01 AM PDT

Designing the ERD ..I am trying to create a lookup entity for my Header(Entity) which has Producttype as one of the attributes.Header_---- Tablename(Entity)--------producttype ---- columnname(attribute)---------ProductLookup------Tablename(Entity)Producttype PK (Varchar)columnname(attribute)Is this a good approach ?

trigger causes job to fail

Posted: 26 Jun 2013 05:31 AM PDT

Sorry, please disregard this post.

Help - Need to parse out some values in the a long text field

Posted: 26 Jun 2013 02:40 AM PDT

Hello all, i have the following example(s) of values in a varchar field, but need to parse out specific attributes for analysis.Here are two examples of the data;12/15/2012 19:41:05 : CustList : ReportSubmit : my region code = US, my segment number = 3, my main terr number = 53 - John Smith (802313)12/15/2012 19:45:58 : Summary : my region code = US, my segment number = 0, my main terr number = 0 - Scooter Brown(98513) - (Impersonated, by: Casper Ghost (883599))In the first, i need to parse the date "12/15/2012", then "CustList" between the colons, and last "John Smith(802313)"In the second example, same attributes "12/15/2012", then "Summary" between the colons, then "Scooter Brown(98513)", but need to add "(Impersonated, by: Casper Ghost (883599))"any way this can be done? The dataset contains these two examples throughout, i could get by with running two sql statements, one for the true user (first example), then run a second to get the additional field for impersonatiton.Any help would be greatly appreciated.

No comments:

Post a Comment

Search This Blog