T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Can you please help me to get the median using the cursor

  Can you please help me to get the median using the cursor How I wrote the following code using the …

  hoseini_akram

  5 replies

  13 years, 10 months ago

  By: Ron McCullough

• Derterministic & non-deterministic result

  Can any one describe that what exactly is a Deterministic & non-deterministic result?

  ankit.singh484

  3 replies

  13 years, 10 months ago

  By: ankit.singh484

• comparing string column with GetDate()

  Hi, I have following table: USE [Test_Shamshad] GO /****** Object: Table [dbo].[mTable1] Scrip…

  shamshad.ali

  2 replies

  13 years, 10 months ago

  By: rhythmk

• Need help in a query which return a field base on calculation

  Hi All, I need write a query that will return a filed which base on the calculation of the data. He…

  kate8tt

  4 replies

  13 years, 10 months ago

  By: kate8tt

• FROM clause challenge

  Is the statement below correct? I.SKU will be used to retrieve a record from from ITEMMAST when eit…

  JayWinter

  9 replies

  13 years, 10 months ago

  By: ScottPletcher

• Minimum missing value - Query help

  CREATE TABLE #Contact ( ContactID INT, FirstName NVARCHAR(255), MiddleName NVARCHAR(255), LastName …

  Smash125

  2 replies

  13 years, 10 months ago

  By: ScottPletcher

• performance issues with query

  Im trying to figure out how to further performance tune a query. A look at the execution plan show…

  jfriedl

  1 replies

  13 years, 10 months ago

  By: Sean Lange

• Query Help

  I am having a problem, Here is my problem. I am creating a SSRS Report. In Sales report i have two …

  rocky_498

  4 replies

  13 years, 10 months ago

  By: rocky_498

• Complex query

  Hi, I have 2 tables witht he following structure. MyTable1 ---------- CustomerId INT Transacti…

  a2zwd

  4 replies

  13 years, 10 months ago

  By: Andy Hyslop

• Help with Query - group by error

  Hi there, I have the below query. I was using this for one team, but now it needs to be used across…

  Kazmerelda

  19 replies

  13 years, 10 months ago

  By: Ant-Green

• Aggregate Query question

  I'm sure I'm overlooking the obvious, and this is simplified, but given a table... Items Item, IN…

  Les Cardwell

  109 replies

  13 years, 10 months ago

  By: Dwain Camps

• why can't we create a clustered index for the views.

  hi, i created a view without schema binding. and i tried to create a clustered index for that view.…

  Kumara1011

  7 replies

  13 years, 10 months ago

  By: Gazareth

• is there any difference between dates

  hi, i have two statements as below select * From doctor_list where doctor_registered_date between '…

  dastagiri16

  5 replies

  13 years, 10 months ago

  By: Jeff Moden

• Subtracting a Millisecond...

  Why do the following scripts return unexpected results? /* version Microsoft SQL Server 2008 R2 (S…

  dkschill

  9 replies

  13 years, 10 months ago

  By: dkschill

• Help with permissions for all databases

  I've been tasked with finding the logins that have DBO or db_datawriter on all the databases across…

  jerrycutshaw

  4 replies

  13 years, 10 months ago

  By: jerrycutshaw