T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Importing excel data with preceding '0's into SQL Server

  Hello, I am trying to import an excel file in SQL Server 2005 through "OPENROWSET" command.…

  supratik.de

  3 replies

  15 years ago

  By: Ed B

• LEFT JOIN and Smallest

  I have two tables A(BookNo) B(BookNoFrom,BookNoTo,ChangeBookNo) Create table A(BookNo char(4)) Crea…

  nguyennd

  3 replies

  15 years ago

  By: The Dixie Flatline

• Create Index SQL 2005

  Hi Anyone can help me below I want to create index for below scripts in sql 2005. the correct index…

  Ayie

  2 replies

  15 years ago

  By: Gail Shaw

• How to make query for desired report output

  Hi, I have to create a report for billing to clients: Here are some details: -- create sample tabl…

  Shamshad Ali

  7 replies

  15 years ago

  By: Shamshad Ali

• Procedure not able to run

  Hi All, i had a xyz sp in abc database.. when i ran the select * from sysobjects where name like…

  balaji.ganga

  2 replies

  15 years ago

  By: jerry-621596

• Help needed: Moving rows to columns

  Hi, I have a database with several tables, containing clinical info. One of the tables (let's name …

  pierre.daubresse

  5 replies

  15 years ago

  By: LutzM

• Automatically generating a value in a column

  HI I HAVE A TABLE CREATE TABLE [dbo].[Url]( [UrlID] [int] NOT NULL primary key, [UrlName] [varc…

  SQL006

  1 replies

  15 years ago

  By: The Dixie Flatline

• Help with PIVOT!

  Hi, Been a while since I have visited here. I have got a query which gives me a result set shown be…

  CodeLake

  13 replies

  15 years ago

  By: CodeLake

• Help with PIVOT?

  Hi, Been a while since I have visited here. I have got a query which gives me a result set shown be…

  CodeLake

  2 replies

  15 years ago

  By: Gail Shaw

• (sql 2008) t-sql concurrency question.

  We have a table containing a single row, single column (bigint) “counter” value (1,2,3,4…). We cre…

  Barkingdog

  24 replies

  15 years ago

  By: Jeff Moden

• Deadlocking in stored proc calls (sql 2008)

  The deadlock revolves around 3 tables (A, B, and C), shown simplified below. ----------------------…

  Barkingdog

  3 replies

  15 years ago

  By: Jeff Moden

• Replace function accross entire table

  Is it possible to apply the replace function to all columns in a table? I have over 350 in a table …

  LoosinMaMind

  3 replies

  15 years ago

  By: LutzM

• Retrieve information about Log Shipping status

  Hi friends, This is a simple question. Imagine that you have a server involved in a Log Shipping im…

  wagnerbianchijr

  2 replies

  15 years ago

  By: wagnerbianchijr

• SQL count

  Hi I am trying to write a query to count all the telephone numbers with a table The below would ret…

  Simon Parry

  3 replies

  15 years ago

  By: steve-893342

• simple SELECT query takes ten seconds to return 5000 rows - can I optimize?

  I have a table and index: CREATE TABLE X ( HistoryID INT NOT NULL IDENTITY(1,1) PRIMARY KEY, …

  Jesse Reich

  23 replies

  15 years ago

  By: Paul White