Topics
Started by
Posts
Last post
CREATE TABLE #Contact ( ContactID INT, FirstName NVARCHAR(100), MiddleName NVARCHAR(100), LastName …
8 replies
I have a table of ItemID's associated with OrderID's and I would like to query the table to find al…
4 replies
update TblGas set MedianCo= (SELECT MedianCo FROM TblGas INNER JOIN Total ON TblGas.ID_NO= Total…
4 replies
Can you please help me to get the median using the cursor How I wrote the following code using the …
5 replies
Can any one describe that what exactly is a Deterministic & non-deterministic result?
3 replies
Hi, I have following table: USE [Test_Shamshad] GO /****** Object: Table [dbo].[mTable1] Scrip…
2 replies
Hi All, I need write a query that will return a filed which base on the calculation of the data. He…
4 replies
Is the statement below correct? I.SKU will be used to retrieve a record from from ITEMMAST when eit…
9 replies
CREATE TABLE #Contact ( ContactID INT, FirstName NVARCHAR(255), MiddleName NVARCHAR(255), LastName …
2 replies
Im trying to figure out how to further performance tune a query. A look at the execution plan show…
1 replies
I am having a problem, Here is my problem. I am creating a SSRS Report. In Sales report i have two …
4 replies
Hi, I have 2 tables witht he following structure. MyTable1 ---------- CustomerId INT Transacti…
4 replies
Hi there, I have the below query. I was using this for one team, but now it needs to be used across…
19 replies
I'm sure I'm overlooking the obvious, and this is simplified, but given a table... Items Item, IN…
109 replies
hi, i created a view without schema binding. and i tried to create a clustered index for that view.…
7 replies
Viewing 15 topics - 5,566 through 5,580 (of 10,647 total)
You must be logged in to create new topics.