T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Bushy plan vs left-deep

  I have read about Bushy plan and left deep in some articles. Bushy plan will consume more memory as…

  karthik M

  1 replies

  13 years ago

  By: ChrisM@Work

• SQL Refusing to use an index

  I've just had a designer come to me with a really odd problem. A query, joining two tables on a pr…

  Rayven

  5 replies

  13 years ago

  By: Sergiy

• Substring with IF or CASE statement

  Hi, I am trying to import into SQL Server 2008 R2 a list of strings as follows: =KET+N.207-13-F4001…

  Avdecha

  2 replies

  13 years ago

  By: Avdecha

• T-SQL substring replace function

  Hello, I have some data and need to extract the first 9 numbers from this pattern across multiple r…

  ggarcia 73023

  8 replies

  13 years ago

  By: Lynn Pettis

• How is SQL query processed in this example?

  Hi, I have already posted the problem on Stackoverflow. Can you please help? http://stackoverflow.c…

  cnayan

  7 replies

  13 years ago

  By: cnayan

• Table Join using unique values or where Null = all values

  Hi folks, I have a complex query that involves many tables but I am struggling with one particular …

  DerbyNeal

  4 replies

  13 years ago

  By: ChrisM@Work

• Help with query using exclusion table

  I have a metrics database and a few reports running from it. One of them is to report on databases …

  jamie_collins

  1 replies

  13 years ago

  By: jamie_collins

• help with query - am I going down the right path on this

  I'm working on a query that will be comparing columns in tables in 2 seperate databases. If the whe…

  SQL_NuB

  4 replies

  13 years ago

  By: SQL_NuB

• Incrementing code to add code

  Hi, I am trying to join the table to itself many times on a condition. Is there a way to automate n…

  akberali67

  4 replies

  13 years ago

  By: Lowell

• Help with the query!

  I came across a situation as follow CREATE TABLE DAYOFWEEK(WeekID INT IDENTITY,DAY NVARCHAR(50)) C…

  Shadab Shah

  11 replies

  13 years ago

  By: 0409SQL

• problem in select command

  hi please look at this select command : [Code]select top 2 * from dbo.NFFeeds order by id desc [/co…

  pooya1072

  49 replies

  13 years ago

  By: Vedran Kesegic

• asp with sql server 2000?

  hai friends, I m currently using sql server 2000 DB for my asp application my table is create t…

  raghuldrag

  1 replies

  13 years ago

  By: Andrew G

• SP Help

  Hello

  SqlServerLover

  4 replies

  13 years ago

  By: Jeff Moden

• How to get month number like Jan -01, Feb-02 ... Instead of Jan-1, Feb-2

  Hi, Need help on get month number from Date field, I am getting month number as 1 for Jan, 2 for …

  gracebite

  2 replies

  13 years ago

  By: Jeff Moden

• Design of database table and PK update

  We are creating an address database to maintain student address info. I have two tables like this :…

  sqlfriend

  1 replies

  13 years ago

  By: Eugene Elutin