T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Partition Switch to another database

  is it possible to switch the data from one database to another. See the below test code USE [Adven…

  Bhuvnesh

  3 replies

  13 years, 4 months ago

  By: Suresh B.

• Pivot to produce a timetable

  Hi everyone, I'm looking for a fix for an issue I'm working on. I've got a list of locations, start…

  kevinp81

  7 replies

  13 years, 4 months ago

  By: Greg Snidow

• How to find (or create) the stats_stream, rowcount, and pagecount used in Update Statistics

  I have been asked to script out the creation of specific tables in the database including primary k…

  hmbmeister

  3 replies

  13 years, 4 months ago

  By: Vedran Kesegic

• how to concatenate rows and join in another table

  Hi to all, Please bear with me. anyways, this is the tables i have Table1 Name Company ID…

  ernesto.yandoc

  1 replies

  13 years, 4 months ago

  By: Bhuvnesh

• Better Way to Perform this Query

  Hello Everyone I hope that everyone is having a very good day. I need to write a query to select ro…

  AndrewSQLDBA

  31 replies

  13 years, 4 months ago

  By: ChrisM@Work

• Has to Be a Better Way

  Good Morning Everyone I am performing a code review before sending any thing into QA and on up. I r…

  AndrewSQLDBA

  7 replies

  13 years, 4 months ago

  By: MyDoggieJessie

• Call a insert procedure with OPENROWSET

  Hi Folks, There's a simple procedure which inserts data into a table: ALTER PROCEDURE [tmp].[test_…

  Teutales01

  1 replies

  13 years, 4 months ago

  By: Teutales01

• Reverse Of Number without Using reverse()

  Hi, How will i reverse the number in SQL Server with out using reverse()

  Shadab Shah

  24 replies

  13 years, 4 months ago

  By: Dwain Camps

• Pivot problem

  Hi I have the following table CREATE TABLE #Test ( ProductID int, MainMasterFeatureID int,…

  SQL006

  9 replies

  13 years, 4 months ago

  By: vinu512

• string extraction help

  Hi, I have some code in c# which extracts the text from a string that complies with these wildcards…

  olibbhq

  8 replies

  13 years, 4 months ago

  By: Dwain Camps

• cross tab query

  hi all, how do i achieve this result division 2012 2013 2014 2015 2016 xyz 1 0 0 …

  imfairozkhan

  3 replies

  13 years, 4 months ago

  By: Dwain Camps

• Flattening a Parent Child Hierarchy

  Hi, We are starting work on a BI project that is given data in a traditional Parent-Child Hierarchy…

  Jason-299789

  18 replies

  13 years, 4 months ago

  By: Jason-299789

• CTE or while loop or an other?

  Hello, I am new to this board so thanks in advance for any help that can be provided here...:-) I w…

  finno

  6 replies

  13 years, 4 months ago

  By: finno

• Reg: Image Directly Insert into database binary Format

  Dear All I am working in University Project.I have 10000 students physical photos in …

  vs.satheesh

  3 replies

  13 years, 4 months ago

  By: SQL Fool

• Convert space seperated string into rows - but with associated id field

  Hi, I am stuck with getting the data into rows. I would like to turn ID Well_id Figure 1 …

  olibbhq

  3 replies

  13 years, 4 months ago

  By: olibbhq