T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Getting the details of the rows into columns

  There are two table structures which will have the below columns Table 1 ---- RequestID, Requestorn…

  pawan.boyina

  2 replies

  14 years, 11 months ago

  By: Hunterwood

• Partition on existing partitioned tables!!!

  Hi, I have several partitioned tables.Tables are partitioned by monthly for 13 months.But now I hav…

  Stad

  2 replies

  14 years, 11 months ago

  By: Stad

• Export to flat file without using bcp or extended stored procedure

  Hi All, Sorry if the query exists previously. I would like to transfer data from SQL Server to flat…

  MSSQLBuddy

  3 replies

  14 years, 11 months ago

  By: Ron McCullough

• Need a way to write clever query with dynami columns

  Hello, I am facing a challenge of writing a query with dynamic columns. Here is the setup script: …

  Misha_SQL

  3 replies

  14 years, 11 months ago

  By: Misha_SQL

• Dropping a Temp Table

  In a stored proc, I am creating a temp table: DECLARE @TempResults TABLE (row_num smallint…

  Rog Saber

  2 replies

  14 years, 11 months ago

  By: parthi-1705

• Create index script for existing index

  Hi, Recently Migrated SQL Server 2008 from old version SQL server 2000, also windows 2008 enterpris…

  SQL Galaxy

  3 replies

  14 years, 11 months ago

  By: Syed Jahanzaib Bin hassan

• Inserting Incremented Alphabets into a column

  Hi, I have a table that is already populated. I need to add a new column & the values in the c…

  Hakuna Matata

  11 replies

  14 years, 11 months ago

  By: Hakuna Matata

• Open URL using t-sql code

  Hi All, Urgent Help is required frmo Excellent Group. I have one task in that i need to open URL …

  pxt_ce

  4 replies

  14 years, 11 months ago

  By: Sean Lange

• Script mismatch different database

  Hi, I want asking two question? 1. I have two database 1. PMSPRD and 2. PMSDEV. First database (PMS…

  SQL Galaxy

  5 replies

  14 years, 11 months ago

  By: HowardW

• Is there any testing tool available to test SQL Proc / Functions...?

  Hi Friends, Is there any testing tool available for the testing of SQL Stored procedures/functions?…

  only4mithunc

  1 replies

  14 years, 11 months ago

  By: Grant Fritchey

• How to execute sp_executesql on the linked server via dynamic sql

  Hi, Could you please help me take a look at the sql below? I want to use dynamic to execute the sq…

  lindsaywang

  1 replies

  14 years, 11 months ago

  By: lindsaywang

• Which index run first Clustered index or Non_Clustered index

  I am having Clustered index (not primay key)and Non-Clustered index on a table of 20 column.I would…

  parthi-1705

  12 replies

  14 years, 11 months ago

  By: Jeff Moden

• How it can be done..

  Hii Every body I retriving data from database and my out put is as follow? %A x1 x2 x3 %B y1 y2 y3 …

  amitsingh308

  7 replies

  14 years, 11 months ago

  By: Syed Jahanzaib Bin hassan

• Update if ID exists

  I have a Table X FileID CallID CloseddateTime 1 0001 NULL 2 0003 NULL 3 …

  PSB

  1 replies

  14 years, 11 months ago

  By: PSB

• Require assistance with T-SQL query (SQL 2008)

  -- create table query: CREATE TABLE mytable ( School varchar(160), Student varchar(160), SourceName…

  kevin_nikolai

  4 replies

  14 years, 11 months ago

  By: kevin_nikolai