Search results for query: *

In order to improve readability and performance, can I simplify the query below to a select query? DECLARE @ProductCodes TABLE(ProductCode nvarchar(3), IsProcessed bit DEFAULT 0) INSERT INTO @ProductCodes(ProductCode) VALUES('ABC') INSERT INTO @ProductCodes(ProductCode) VALUES('DEF') INSERT...

I'm using SQL Server 2008 R2. I have a table with a xml data type column. I'm trying to query one of the elements from the column's value, but getting the following error: Msg 2389, Level 16, State 1, Line 12 XQuery [tblEmailFollowup.OptionalParameters.value()]: 'value()' requires a singleton...

Below is the structure of my web application. - Site.Master - MappingTable.Master - DataPage.aspx (Content Page) From Site.Master, I need to disable a button on the DataPage.aspx. How would I do that? Thanks!

I'm using VS2012. I'm trying to follow an exercise from a book. Here is the code for my custom server control: namespace ServerControl { [ToolboxData("<{0}:menucustomcontrol runat=\"server\"></{0}:menucustomcontrol>")] public class MenuCustomControl : Control { protected...

I have a table with the table name, column name, column values and whether the column values should be included or excluded. This table is used to filter what data should be loaded. Here is an example TableName ColumnName ColumnValue Include/Exclude tblProduct ProductID 1 Exclude tblProduct...

I have a table structure (tblmapping) like the following: TableName ColumnName ColumnValue Product ProductID 1 Product ProductID 2 Product ProductName Keyboard Product ProductName Mouse I want to convert from column based data to row based data. I tried the following query, but...

If I pass a date and the days that should be subtracted I need to find the next weekday. Here is what I have: static DateTime GetFileDate(DateTime BusDate, int DayLag) { DateTime FileDate; FileDate = DateTime.Today; switch...

I need to write a function that converts a time from GMT to EST taking daylight savings time into consideration. On a high level I was thinking of doing the following: a) a table that holds the daylight saving dates for this year and upcoming years. does anyone know a website that has these...

Can anyone recommend java books? I have experience in C#.

One of our engineers is having a problem installing SQL Server 2008 R2 on a Windows 2003 R2 machine. When we click on setup.exe the installation wizard doesn't show up. Is this because Sql Server 2008 R2 cannot be installed on a Windows 2003 R2 machine? Thanks!

There was a production change that changed a field from char(2) to char(3). I didn't realize that this field is being used by views. When the view was called by a stored proc, an error came up saying that "The (maximum) expected data length is 2, while the returned data length is 3.". So...

I've started reading about how bcp does bulk insert. I'm not sure how sql server does validation (i.e., data type). Using bcp, if 5 records are sent to sql server does sql server perform validation record by record and then insert the 5 records all at once? Thanks for the help!

I'm trying to convert the query below to use table variables, but it isn't giving the same results: UPDATE #TEMP1 SET #TEMP1.ExternalTradeID = ( Select #TEMP2.ExternalTradeID From #TEMP2 WHERE #TEMP2.TOLNK = #TEMP1.TOLNK ) WHERE #TEMP1.TOLNK <> '' AND #TEMP1.ExternalTradeID = '' Conversion...

I have a drop down list that fetches the data for the Products or the Order table into a dataset. This dataset gets bounded to a gridview. The data in the gridview has to be editable. I was thinking of dynamically creating itemtemplates w/ textboxes depending on the number of columns in the...

I'm using the WebDirectoryCreate task part of the tigris ms build tasks (https://github.com/loresoft/msbuildtasks) to create a virtual directory. But I get the following error: Error HResult E_Fail has been returned from a call to a COM component. I'm not sure what this error means. Here is...

In the code line below, I'm getting the errors below. I copied this from a web.config to the web.config I'm using: <configSections> <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings...

I have old product ids that I need to add as new product ids. All old product ids starting with 565 should increment starting from 123-00000. So 5650406316 should be 123-00000 and 5650406415 should be 123-00001. All old product ids starting with 566 should increment from 123-40000. Here is...

I'm enhancing a SP that is using 4 or 5 temp tables to store data. At the end a select query is done joining the temp tables. I wanted to see if the performance of the SP would improve if I used table variables with primary keys. What would be a good way to test the performance between the...

I read this post: http://www.tek-tips.com/viewthread.cfm?qid=1531953 and just want to make sure I've understood the difference between clustered index and nonclustered index. Clustered Index: actually sorts the data on the field(s) indicated. Nonclustered Index: doesn't sort the data, but has...

I was going thru a msdn tutorial and there was a property that was being validated in a class. Is the best practice to do this in a class or on the client side of a presentation layer? I see the advantage of doing it in a class that you can reuse the code among web pages. I see the advantage...