.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

create multiple columsn based on a passed in variable

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
 
Hi, I am clueless as to how the following would be done. Would appreciate imputs: i would be passed in a StartDate and EndDate along with a Period(Week,Month,Quarter,Year).  this would be an INT which is calculated in the following way -- Suppose he selects StartDate = 2010-01-01, EndDate = 2010-02-28, and Period = Weeks ---> Which would mean my resultset would have a additional 9 columns (9 weeks using DateDiff(Week,@startdate,@enddate) The number of fixed columns always will be 4 Total # of records that would always come back is > 10 something like this CategoryTypeId(int),ParentCategory(uniqueidentifier),Id(uniqueidentifier),Name nvarchar(50),Wk1,Wk2.....Wk9 1,xxxx,xxxx,'Shopping',650,300,1275....1000   (i dont't need to total the wk,month,qurter or yearly.This would be taken care on the front end) Thanks!


View Complete Post


More Related Resource Links

Windows Forms: Give Your .NET-based Application a Fast and Responsive UI with Multiple Threads

  

If your application performs any non-UI processing on the thread that controls the user interface, it may make the app seem slow and sluggish, frustrating users. But writing multithreaded apps for Windows has long been restricted to C++ developers. Now with the .NET Framework, you can take advantage of multiple threads in C# to control the flow of instructions in your programs and isolate the UI thread for a fast and snappy user interface. This article shows you how. Also, it discusses the pitfalls of multiple threads and presents a framework for safe concurrent thread execution.

Ian Griffiths

MSDN Magazine February 2003


Want to create Page URL rewrite based on Users GUID and Display name?

  

hi,

I am using the asp.net membership. 

On my site I have a Profile.aspx page.

In the code behind of this page,  i get the logged in UserId (Guid) and pass

this to a method in my DAL. GetUserByUserId()

 

In my database I have a Table called Member which the method gets the data from

and displays details on the page about  the user.

 

What I want to happen is when they have logged in and are diverted to Profile.aspx,

the page URL shows www.MyWebSite/Profile/UsersName 

for example

www.MyWebsite/Profile/JohnSmith.aspx

 

is this possible. In my Member table I have FirstName and LastName columns or do I get the

name from the membership table.

 

even better would be they go straight to www.MyWebsite/JohnSmith.aspx

 

thank you for any help

 

P

 

 

 


How to store and retrieve multiple values in a single session variable .

  

I want to store employee name,designation and department in session variable and
retrieve in another page how to do this.


How do you create a custom BDC data field that allows for multiple selected values?

  
I need help creating a custom data field using the BDC column as a base.  We need to allow for multiple selected values instead of just a single one.  I can't find anything on the net which shows how to do this.

Create a dimension based on 2 fields

  
Hello I have a table as follow: No   Placestart    Placeend 1      DK                USA 2      UK                USA 3      USA              DK Now, I want a dimension called Country, which selects either of the rows where a value exist In SQL it would be ex (SELECT * FROM table WHERE placestart = 'USA' OR placeend = 'USA) So, when I select USA in the dimension all 3 rows are listed, as USA is included either in placestart or placeend. If I select DK row 1 and 3 is selected etc... Is this somehow possible?      

How to create an activity that allows multiple exit paths similar to FlowSwitch and FlowDecision

  
There have been several threads around this type of request but none have provided a definitive outcome for my requirements:I am looking to emulate the FlowSwitch or FlowDecision in a custom activity so as to simplify end user workflow authoring in a rehosted environment.Currenty I am limited to linking my custom activity to a FlowSwitch or FlowDecision to allow for simple logic to be visually composed. This creates additional complexity that I am trying to avoid.I understand that these are sealed types and even the abstract FlowNode base class of these types does not have any overridable types by design as WF 4.0 favours composition over inheritance.What options do I have to accomplish my objective?If activity composition is the response to my question then could I kindly request that some samples or links to samples are provided?

How to create SharePoint workflow[Visual studio] with Infopath multiple views?

  
Hi Every body,I have Travel Request infopath form with 3 views(Requester/Manager/Traveldesk).Ones the user submitt the data then workflow will be start. In manager view he will select next level approver also. Ones manager approve/reject then pass to Traveldesk and they will forward travel inforamtion to user.I am new to workflow so How to approach my requirment any ideas and examples.Thanks in advance  

Receive/Delete Multiple FTP Files based on condition using SCRIPT(VB) TASK

  
I am trying to receive and delete multiple FTP files from a remote FTP server using Script task Below is the code   Dim FTPConnMgr As ConnectionManager FTPConnMgr = Dts.Connections("FTP Connection Manager") Dim FTPClientConn As FtpClientConnection = New FtpClientConnection(FTPConnMgr.AcquireConnection(Nothing)) Dim FileTimeStampNew As String = "20100913021807" Dim remoteFileNames(0) As String remoteFileNames(0) = Dts.Variables("FtpRemoteDirectory").Value & "*" & FileTimeStampNew & ".*" 'Below hardcoded FileName works good. But the problem is there are lots of file in the FTP folder that I dont want to receive 'remoteFileNames(0) = Dts.Variables("FtpRemoteDirectory").Value & "Company_alpha_Full_20100913021807.xml" Dim localPath As String = Dts.Variables("FtpLocalDirectory").Value FTPClientConn.Connect() FTPClientConn.ReceiveFiles(remoteFileNames, localPath, False, False) FTPClientConn.Close() Dts.TaskResult = ScriptResults.Success End Sub End Class If i specifically mention the RemotefileNames this works fine but, when I say *.* it executes succefully but doesn't receives the file. Please advice how to receive multiple file based on a variable BR, AWM

How to create single wsp for multiple projects sharepoint 2010 solution

  
We have multiple projects (4 projects) in single sharepoint 2010 solution. We want to create single wsp deployment for this. But when I right click on any project, it creates package means wsp on its own. How to create single wsp for multiple projects sharepoint 2010 solution? Is wsp builder which we are using for sharepoint 2007 project (works really great) also works in sharepoint 2010?

What are my options when I need to create a report with data from multiple sources?

  
Hello all,  What are my options when I want to create a report that will get records from multiple data sources based on data from a parameter? The user will enter the customer ID, I have to check that ID against 5 different data sources. Have you guys done anything similar? Should I leverage SSIS on this request, adding an extra layer of complexity? Should I do this all from SSRS? What are my options?

Cannot create email alerts for multiple users

  
Hello, I created an email alert for a document in a library. In the "Send Alerts To" box, I added multiple user names separated by semicolons and saved the alert. However, when I open the alert again, only my user name appears and the additional user names are gone. Why is this happening and how do I fix this problem?  Thank you in advance.

How can create site in sharepoint foundation 2010 based on WSS 3.0 template(.stp file)

  
Hi,   I  want  to migrate wss3.0  site into sharepoint foundation 2010 site . earlier we  were creating site based on .stp file  in WSS 4.0 . but now we  have   to build same site in sharepoint foundation 2010. I followed  the old way  intall the .stp file  and  based on that trying to create new  site  but getting some error  old version template is not supporetd my this version. how could  l able to create  site  in sharepoint foundation 2010 based on wss 3.0 template . Please help Thanks in advance Jandel Singh

How can create site in sharepoint foundation 2010 based on WSS 3.0 template(.stp file)

  
Hi,   I  want  to migrate wss3.0  site into sharepoint foundation 2010 site . earlier we  were creating site based on .stp file  in WSS 4.0 . but now we  have   to build same site in sharepoint foundation 2010. I followed  the old way  intall the .stp file  and  based on that trying to create new  site  but getting some error  old version template is not supporetd my this version. how could  l able to create  site  in sharepoint foundation 2010 based on wss 3.0 template . Please help Thanks in advance Jandel Singh

How 2 join Multiple Keys based table???

  
I have a table INC with 2 Columns/Fields, i.e. YR and CL set as primary keys by selecting both the columns and selecting primary key symbol with right click. How to set up a FK with the other table INC_DTL's CL which I seek to be restricted to a combination of the INC's 2 fields? Thanx in advance.

Create a progress bar based on progress of AJAX handler

  
I've got a plain C# web page that uses jQuery to call a handler page using AJAX. While the handler content is loading, a message "Please Wait, loading..." is displayed. Once I've got the content back from the handler I hide the loading message and display the content.What I'd like to do is after the loading message, display a percentage of how far through the handler page is. All the handler page does is loop through a list of members, powered by a web service, and adds them to the database so I know exactly how many members are being added to the database so I can tell how far I am through.The problem I'm having is because all of this goes on in a handler, how can I send the progress percentage back to the main web page while the handler was still loading.Any ideas? If I could do the exact same task but differently which would allow me to create the progress bar, I'd be happy to hear any suggestions.

Multiple Values to the Variable, HOW?

  
Hi All, I'm trying below query which is working fine:- DECLARE @FULLNAME VARCHAR SET @FULLNAME = 'PQR, ABC L.' SELECT ID FROM TABLE-NAME WHERE LAST_NAME = SUBSTRING(@FULLNAME, 1, PATINDEX('%,%', @FULLNAME) -1) AND FIRST_NAME = LTRIM(RTRIM(SUBSTRING(@FULLNAME, PATINDEX('%,%', @FULLNAME)+1 , PATINDEX('% %', @FULLNAME)))) But when I include two values to the same variable something like this:- DECLARE @FULLNAME VARCHAR SET @FULLNAME = 'PQR, ABC L.', 'LMN, XYZ' SELECT ID FROM TABLE-NAME WHERE LAST_NAME IN SUBSTRING(@FULLNAME, 1, PATINDEX('%,%', @FULLNAME) -1) AND FIRST_NAME IN LTRIM(RTRIM(SUBSTRING(@FULLNAME, PATINDEX('%,%', @FULLNAME)+1 , PATINDEX('% %', @FULLNAME)))) It is giving me error as:- "Incorrect syntax near 'SUBSTRING'." This is because my @FULLNAME will be an SSRS report parameter and which is going to be multi-value parameter. Any Help Please? Thanks Regards, Kumar
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend