T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• View vs Synonym when the underlying table is partitioned

  We recently decided to partition a table in one database that is referenced in another. The current…

  nossivad

  9 replies

  14 years ago

  By: nossivad

• Need Some Help with an Odd Query

  Hello Everyone OK, I am going to do my best to explain this and not leave anything out. In the tabl…

  AndrewSQLDBA

  5 replies

  14 years ago

  By: GSquared

• pivot against two different columns

  I have a working pivot statement, which pivots againts one column. I'm trying to create some ddl t…

  polkadot

  10 replies

  14 years ago

  By: Jeff Moden

• URGENT PLEASE Got a SQL Scenario to solve

  hello everyone. i got a scenario like this i got 5 parent tables and 30 child tables in the source …

  vm.chowdary85

  19 replies

  14 years ago

  By: GSquared

• differing query plans from sql 2000 and sql 2008 R2

  I'm in the process of upgrading a sql 2000 environment to 2008 R2. I now have 2 servers, 1 with ea…

  Mark Thornton

  5 replies

  14 years ago

  By: Gail Shaw

• pivot?

  sample data: drop table #data create table #data(number int, name varchar(99), comment varchar(99)…

  sqld-_-ba

  6 replies

  14 years ago

  By: aaron.reese

• Bulk Insert works but leave's spaces in data

  I have read much data,tables This is a sample How can i get rid off spaces in the table during impo…

  eddy-961438

  5 replies

  14 years ago

  By: Brandie Tarvin

• sql

  how can i add timestamp columns in sqlserver

  vikaskuncham

  3 replies

  14 years ago

  By: Brandie Tarvin

• if------then ----else in select statement

  hi guys, i need help in my Stored procedure. select empname ,(select case when empno is null then …

  riya_dave

  67 replies

  14 years ago

  By: vinu512

• pivot by year using datetime column

  i would like a pivot query that aggregates counts by years 2012, 2011, 2012 for all workitems havin…

  polkadot

  7 replies

  14 years ago

  By: Jeff Moden

• pivot both horizontally and 'vertically'

  I need to add another aggregation to this query to make the distinction between applications that h…

  polkadot

  1 replies

  14 years ago

  By: Lynn Pettis

• Modified DateTimeStamp - No Default on record creation

  I was creating Insert_Date and Modified Date Columns on a number of tables. It is customary to set …

  Welsh Corgi

  10 replies

  14 years ago

  By: Jeff Moden

• grouped running totals

  Hi all. Firstly, here's some background and then some test data. I have a table that has lots of st…

  greg.bull

  9 replies

  14 years ago

  By: Jeff Moden

• Concatenate today's date and tomorrow's date

  I have to Concatenate today's date and tomorrow's date in the below format using T-SQL. 2012.04.21.…

  Jay Pete

  3 replies

  14 years ago

  By: Jay Pete

• sql server date time

  i am having the following sales details table with product code, date , time columns Product Code…

  varshini

  1 replies

  14 years ago

  By: Thinknook