Topics
Started by
Posts
Last post
I run 2 queries at the same time with include actual execution plan, and it says query A is taking …
1 replies
Hi guys I'm starting to delve into the advanced TSQL world and could use some assistance. Basicall…
5 replies
I have a table with these columns: price product 1 toy 2 toy 3 toy 4 toy 5…
3 replies
Can anyone explain why it would be more beneficial to store date and time values separately, rather…
4 replies
I have the following code that I'm trying to implement. I have a successful solution using SQL CLR…
1 replies
SELECT T1.col1 FROM Table1 T1 INNER JOIN Table2 T2 ON T2.col2 = 'somestring' WHERE T1.col2 <>…
7 replies
Hi, I have the following query: select @drawdrownPct AS largestDrawDownPct ,avg(pctAccountChange)…
5 replies
I have a query design question related to using CASE statements vs. INNER JOINs and the effect on p…
3 replies
I have the following table: drop table #trades go create table #trades ( tradeId int not null prim…
5 replies
Hi all, can this query be written to get rid of the SORT in the execution plan? First it does an I…
8 replies
Which is better approach 1. Multiple SPs for similar functionality or 2. Separate proc for each fun…
9 replies
i,can any one help me in populating time dimensions in sql from 2000 to 2030 for every 15 min.now i…
3 replies
I have a scenario in which the Primary name and the secondary names gets defined in columns for a S…
3 replies
I have some data in SQL Server I'd like to join with an XML document on the internet. The document …
7 replies
Recently we replaced cursors with while loop and table variables. The block is something similar to…
20 replies
Viewing 15 topics - 8,866 through 8,880 (of 10,647 total)
You must be logged in to create new topics.