[SQL Server] General Question |
- General Question
- SSRS / IsNothing problems
- Return sepcifc data on query
- ERD Lookup
- trigger causes job to fail
- Help - Need to parse out some values in the a long text field
| 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.. |
| 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. |
| 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? |
| 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 ? |
| 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. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment