Topics
Started by
Posts
Last post
I have contact and contact_log tables. They can be joined via contactid. As you can imagine it is 1…
6 replies
I am currently going through some of my predecesors code and came across something that does not ma…
3 replies
I've tried several approaches to this including an older one that cursored through the tables to di…
5 replies
can DISTINCT keyword be replaced with " IN" for better performance in some scenarios?
6 replies
I have a select query where I do 7 sums The total number of rows in the query is not more than 150 …
3 replies
hi experts, i have two databases one is live the other is test db, on the test db i've created a vi…
4 replies
Dear All, I wish to create a stored procedure whereby I will retrieve either all the lastNames if t…
5 replies
I have written a fairly complex query but I got the last part and it fails with the old "Msg 4104, …
2 replies
I have a table that stores address information. All of the columns are varchars. When I execute t…
15 replies
Simplified, but the source table is like: [inc_id] player -------------- 1 Ned 1 Bob 1 Steve…
3 replies
Hello, Was wondering - if someone has any suggestions - whereby which we can add time durations. Ex…
3 replies
Hi All, I am trying to build a summary report for companies, when ever the company name is entered …
10 replies
Is it possible to conduct a query across two tables that are in two different connections ? I resto…
1 replies
I am transferring, cleaning, upgrading data from our old FoxPro system to SQL Server. I am current…
19 replies
Hi all, I have ran the nested select below and it produces a list of 150 records. However when I t…
10 replies
Viewing 15 topics - 7,441 through 7,455 (of 12,230 total)
You must be logged in to create new topics.