T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• create column alias with concatenation.

  Hi guys, I want to create column name dynamically in select list. create table #temp(name varchar(…

  abhas

  4 replies

  11 years, 6 months ago

  By: ScottPletcher

• Identify columns which will create a unique record in a table

  I am looking to create a script that will go through a table a pick out the necessary columns to cr…

  mcinvalek

  4 replies

  11 years, 6 months ago

  By: mcinvalek

• Query help to find total

  select col1,count(*) from client1..table1 group by col1 union select col1,count(*) from client2..ta…

  Guras

  2 replies

  11 years, 6 months ago

  By: Alan Burstein

• Duplicates in Sub Query

  Dear Experts, I have the piece of sql code here below that has left me puzzled as it keeps giving …

  SQL DJ

  1 replies

  11 years, 6 months ago

  By: SQL DJ

• Check the Variable is Empty or Null

  Hi, I am sure that this is silly question, but i am confused about checking the empty string. ple…

  KGJ-Dev

  38 replies

  11 years, 6 months ago

  By: Luis Cazares

• Is Flag in SQL sever

  Hi I wanna add IsEllgible flag to this table what data type should I use and sytax this is for nvar…

  Smash125

  3 replies

  11 years, 6 months ago

  By: Luis Cazares

• Measuring the volume of data created temporarily to replace usage of physical tables in an SQL query

  Hi Please comment on how I can measure the volume of data created temporarily to replace usage of p…

  VSSGeorge

  1 replies

  11 years, 6 months ago

  By: Grant Fritchey

• Identifying 'active' linked servers

  Hello all I am performing analysis of linked servers across 2000-2008R2 and need to find/build a li…

  rocky.paiano

  4 replies

  11 years, 6 months ago

  By: rocky.paiano

• Getting undesirable trailing zeros after casting to decimal

  Hi Everyone, The following line of SQL returns the first screen shot below. ((T0.TotalSales - ISNU…

  david.dartnell

  2 replies

  11 years, 6 months ago

  By: Sean Pearce

• Combine 2 selects

  DECLARE @EmployeeID nvarchar(1000) DECLARE @FiscalYear nvarchar(1000) SET @EmployeeID = '101,102,10…

  jrusso

  2 replies

  11 years, 6 months ago

  By: jrusso

• Need help to convert No of Month in integer into How many year and how many month

  This is my table and data CVID | WorkExperience -------------------------------- 2838736 68181…

  Qira

  5 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• Need help with performance issue with a script

  Hi, am new to sql troubleshooting......Our Dev team is running the below sql script from 2 views di…

  Agnii

  5 replies

  11 years, 6 months ago

  By: Gail Shaw

• Identify the missing element [Query]

  Hi all, I have a new challenge for you! I have written a simple routine to do some address checking…

  joseph.robinson83

  3 replies

  11 years, 6 months ago

  By: ChrisM@Work

• When we need to use SET XACT_ABORT ON in Sql server procedures?

  hi ALl, I have the following doubts. 1. In my procedure i dont have any transactions still can i us…

  kbhanu15

  7 replies

  11 years, 6 months ago

  By: Gail Shaw

• copy table data between 2 sql servers in sql server 2008

  hi ALl, can you please provide the possible ways to do this task.

  kbhanu15

  5 replies

  11 years, 6 months ago

  By: it-2