Topics
Started by
Posts
Last post
does joining on more than one column between two tables increase speed of a query?
1 replies
Hello, I'm having a brain freeze... Please help. I have two tables tblfunds and tbltransactions an…
7 replies
Hi, I found an article on this matter: http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/200…
2 replies
Hi , I am using a store procedure where i am creating a query dynamic , but query size is increasi…
4 replies
Hi all, I have a table like T1 ================== Name Address …
4 replies
Hi all, I have a store procedure that generates this dynamic output Execute generate_email '1'; E…
2 replies
Hi, I'm running several SELECT .. INTO Statements, one after another, without an explicit transacti…
21 replies
I have an application with known X and Y points, I'd like to run a function that would calculate m …
5 replies
I am not sure how to update existing data in an xml field when we add elements and remove them. fo…
1 replies
When should I use sp_refreshview? Here are two scenarios: 1. In the following example, should I ca…
3 replies
I have a table with 6120 records 2275 records = Unique LicenseNumber 1941 records = duplicate x2 1…
4 replies
Hi Guys I have a table containing order information. An example is shown below (trimmed down versio…
7 replies
Anyone know a more efficient way of doing this. Obviously my code scans the table three times. I im…
1 replies
I want to convert values from a xml column into a text column. Example: UPDATE tblTest set textData…
2 replies
i have a column which holds the date in string format and is as given below yyyymmddhhmm is there a…
8 replies
Viewing 15 topics - 6,646 through 6,660 (of 12,234 total)
You must be logged in to create new topics.