Hi, Here is the problem I am trying to solve. I need to extract some information from a table, say Tab2, using a matching key from another table, say Tab1. Tab1 has two columns, Col1 and Col2. Col1 is digits (1, 2, 3...) Col2 has letters (AA, Aa, aA, aa, AB etc) I need to use Col2 to join to Tab2...
Thanks! We'll email you when relevant content is added and updated.
Is it possible to retrieve data from two tables, located in two different SQL Servers in one domain, and then add the data and save the result in another table in a third SQL Server?
Thanks! We'll email you when relevant content is added and updated.
I have table called country having one column called complete_name (varchar(max)) which is as under [table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> [tbody] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent;...
Thanks! We'll email you when relevant content is added and updated.
I want to optimize my stored procedure in SQL Server, as it takes some time to execute. It uses a temporary table to store some data, and then it uses a dynamic query that we execute using the EXEC statement. How can I remove temporary table or, in general, how can i improve performance of this...
Thanks! We'll email you when relevant content is added and updated.
I have an Excel spreadsheet with 3 fields being used. (1) Material x(30) Key (2) Description x(30) (3) Extended Description (text) I want to create a table that I can match to an existing table where the key is the Material and update the description and extended description on the existing table....
Thanks! We'll email you when relevant content is added and updated.
I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url as text into my sql table. My...
Thanks! We'll email you when relevant content is added and updated.
I recently found that a couple of my tables in SQL Server 2008 R2 with no clustered indexes defined. However, there are non-clustered indexes defined (so basically they're on HEAP). After I did some searching, I learned that some select statements were using a filter on the columns defined (in...
Thanks! We'll email you when relevant content is added and updated.
I have added the "domain admin" group to the Sql Server, and set permission as "Deny" to connect to the database engine. All employees of this group can still select from any table. The sql server "public" role does not have any permissions on any database table. The "domain admin " group has local...
Thanks! We'll email you when relevant content is added and updated.
I have a dataset in an XML file that needs to load into an existing SQL Server 2005 table. It also needs to check existing rows before loading. What will be a good way to do that?
Thanks! We'll email you when relevant content is added and updated.
One of my family members needs some help! He has a table in SQL Server 2008 with the attributes name and ID. The ID is a generated value like this: INSERT INTO table (name) VALUES('bob');Now, he's looking to get back the ID in the same step. How can he do this?
Thanks! We'll email you when relevant content is added and updated.
Now in SQL Server 2005, I know there are different ways to create and populate a numbers table. But, what's the best way? I'm looking for the best way to optimize these characteristics:Table created with optimal indexingrows generated fastestsimple code used to create and populate
Thanks! We'll email you when relevant content is added and updated.
Our business is using an older version of SQL Server (2005 in fact) and all we're trying to do is add a column, with a default value, to an existing table. Can someone point us in the right direction?
Thanks! We'll email you when relevant content is added and updated.
Now in SQL Server 2008, is there a way that I can query for names in all tables that contain the column with name. Something along these lines:%myName%
Thanks! We'll email you when relevant content is added and updated.