T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• MERGE issues with OUTPUT into table with IDENTITY column

  Hi all, (using SQL 2008 Standard, , database compatibility set to SQL 2005). I am getting this erro…

  barokzi

  11 replies

  9 years ago

  By: barokzi

• Indexing - Should primary key be a natural key or an identity?

  I have long been in the camp that says all rows should have a single unique identifier, usually an …

  The Dixie Flatline

  14 replies

  9 years ago

  By: Sergiy

• Updating Table with CTE?

  Given the following setup: Base Data if object_ID('tempdb..#baseTable','U') is not null drop table …

  LinksUp

  2 replies

  9 years ago

  By: LinksUp

• SQL Union all & Group by clause not working

  Hi all, I have a table as per below detail:- CREATE TABLE ITEM_DIM (DOCKET_NO VARCHAR(9),DOC_DT DAT…

  neellotus07

  5 replies

  9 years ago

  By: The Dixie Flatline

• Random Values between 0.25-6.5

  Hi all, I am working on Sql Server 2008 and I have a requirement that for a specific column I have …

  ammit.it2006

  8 replies

  9 years ago

  By: DesNorton

• Checking a string for valid TSQL

  I want to be able to pass a string into a stored proc and then check to see if it is a valid TSQL s…

  John Deupree

  7 replies

  9 years ago

  By: Ed Wagner

• Summing records in one column in two ways by value in another column to get proportion

  Hi, I am trying to calculate the proportion of records by City and YearMonth that have Male in the …

  quentin.harris

  5 replies

  9 years ago

  By: Sean Lange

• Parameter Sniffing Issue

  i have a Parameter Sniffing issue due to the execution plan that gets created at runtime for a pa…

  JALLY

  9 replies

  9 years ago

  By: Grant Fritchey

• Export data from SQL server to multiple tabs

  Hi, Is it is possible to export data from SQL server to multiple tabs? Say i am having 5 tables i n…

  yuvipoy

  2 replies

  9 years ago

  By: drew.allen

• calculating time difference

  Hello, I have a problem where i want to get the diffrence in minutes between two times, my datatype…

  JALLY

  3 replies

  9 years ago

  By: Eirikur Eiriksson

• Views not changing when table changes

  I have the following view, I get 10 columns back. If I add a new column to the "dbo.Jobs" table, I…

  tshad

  3 replies

  9 years ago

  By: MMartin1

• how to remove leading 1 and zeros

  i am getting numbers like as below, 1000000017777 1000000017342 how can i remove leading 1 and zero…

  dastagiri16

  7 replies

  9 years ago

  By: Sergiy

• Parallel insert in a table

  Hi All, Is there a way to perform parallel inserts in a table ? I have any huge table in one databa…

  sqlenthu 89358

  20 replies

  9 years ago

  By: xsevensinzx

• Table Partitioning

  Hi, I am new to table partitioning. I have a large table with millions of rows, There is no Dat…

  sanjaydut26

  6 replies

  9 years ago

  By: sanjaydut26

• Eliminate Duplicate

  I have a table Consumer and Consumer Account. The consumer can be primary consumer or secondary con…

  Loner

  2 replies

  9 years ago

  By: Loner