nickg21

	Common Table Expression Grouping numbers incorrect 11 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everyone, I'm using CTEs to try and get the totals of two different criteria queries that I want to group by Month depending on the associated Inquiry Date. Here is what I have right now; ;With CTE(total, InitDate) as ( SELECT count(Inquiry.ID), Inquiry.Date from Inquiry Inner Join Inquirer on … Databases mssql 0 0 81
	Query counts different when Joining table; why? 11 Years Ago 11 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everyone, I have the following two queries, and want to know why the first one would return a count of 52, but the second would return a count of 51 when technically they should be the same; SELECT count(*) from Inquiry Inner Join NoDecision on Inquiry.ID = NoDecision.InquiryID_fk Inner … Databases mssql 0 3 137
	Conversion failed when converting date and/or time.. CTEs 11 Years Ago 11 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey Everyone, I am using the below query to try and group together values by the month of the date selected. the problem is that sometimes CTE2 will not have the same dates as CTE and those values end up omitted. Is there anyway I can just group these on … Databases asp.net conversion expression mssql server sql 0 5 258
	Nested SELECT Statement in Where Clause 11 Years Ago 11 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everyone, I am looking to write a query that I think can be solved a nested select but I am not yet that fluent in MySQL to be able to get the query working correctly. Basically what I want to do is this; SELECT count(*) from Inquiry Inner Join … Databases mysql nested select server sql 0 3 732
	Easy Date conversion from "April 12, 2012" to "2012-04-12" 12 Years Ago 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everyone, Basically everything im trying to do is summed up in the subject line. I have a "DatePicker" control on my site, that when a date is selected, is displayed in the textbox as "April 12, 2012" or whatever the subsequent date may be. However, when I save this … Web Development asp.net 0 2 117
	Conversion from string "" to type 'Date' is not valid. 12 Years Ago 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everyone, I know that there are hundreds of articles online about this same error, but I have been going at this for almost 2 days and it's time I just started a thread of my own. In my application, I have a textbox that has a CalendarExtender hooked up … Web Development asp.net convert date 0 6 334
	System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow in parameterized query 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everyone, I am lost on the exception that I have getting thrown at me right now. SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. What I am trying to do on my site, which is Windows Authenticated on an internal network, is capture the users … Web Development asp.net exception overflow visual-basic 0 0 126
	Using TrackFocus(), keeping focus in TabContainer on PostBack 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everybody, I've been scouring the internet and forums for days now trying to solve this issue, that seems to me like it should be pretty simple. Basically I have a multi-step form with multiple tabs in a TabContainer. There are a couple radiobuttonlists that perform autopostbacks, and I want … Web Development asp.net focus setfocus tabcontainer 0 0 91
	Parameters.Add in For Each Loop VB 12 Years Ago 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everyone, my issue is a little strange, I have a form that has checkboxes, and depending on the selection, a textbox might appear for further info. I want to loop through the controls that have been selected, if it's only a checkbox than just add the Value of the … Web Development asp asp.net vb.net 0 2 351
	Comparing Control Values to DataSet Values 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everyone, I'm going to do my best to explain this easily, even though the code might not be the easiest to follow. I have an "Edit" form made out of a TabContainer and TabPanels that I am populating with results from a few different datasets, after a user clicks … Web Development asp.net 0 0 64
	Using Scope_Identity() variable in a different SQLDataSource ad-hoc 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hello everyone, I am making a set of tables that have relational keys associated with them like an order system. Basically I am trying to store the Customer Info, then the order and so on and so forth, but I need to store the "customer" ID in the Order table … Web Development asp.net vb.net 0 0 76
	Using SelectCommand Result in InsertCommand Statement 12 Years Ago 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everyone, What i'm doing is building a step through form that will basically store relational keys between databases. I begin by storing Information about the individual asking about the program, I then want to query the table this was stored in to get the Unique ID that is being … Web Development asp.net 0 2 154
	Data Type MisMatch in Insert Statement with SqlDataSource 12 Years Ago 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everyone, I'm fairly new to .Net and I am just starting to write some queries to begin using my database files, and I keep running into these errors. I have stepped through numerous tutorials and reference guides and still cannot seem to get things working properly. Basically I have … Web Development asp.net vb.net 0 1 168
	CheckChanged event doesn't work dynamically 12 Years Ago 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hello, The issue that I am having right now is that I have a multiview form that steps through gathering information from the user and depending on the information selected, some fields are displayed/hidden in other views of the form. Basically, what is going on is that I have a … Web Development asp.net studio vb.net 0 2 266
	Getting checkbox "Text" value in controls loop 12 Years Ago 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Hey everyone, I'm fairly new to ASP.Net and VB, but I have been learning pretty well. I have created a loop to go through one "View" section of a MultiView step form, and find which checkboxes have been checked. Depending on the boxes checked, I am trying to create new … Web Development asp.net vb.net 0 1 200