SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• about @identitiy(1,1)

  Q1) I am using follwing tem table in stored proc to loop throught tmpid , will it create any gaps o…

  rajemessage 14195

  6 replies

  10 years, 1 months ago

  By: Ed Wagner

• Query result with a value condition

  Hi All, I need your help to figure out a query. create table #Ord (OrdID INT, OrdDt DATE, CustID …

  ssc_san

  17 replies

  10 years, 1 months ago

  By: Orlando Colamatteo

• IF or WHILE statements with Stored Procedures

  I am looking for some help with IF or WHILE statements EXAMPLE: DECALRE @Results INT EXEC @Results …

  TJT

  18 replies

  10 years, 1 months ago

  By: TJT

• Double plus ungood

  I'm using SSMS pointed to SQL Server 2012. Can anyone tell me why both of these return the same va…

  kkeeffe

  8 replies

  10 years, 1 months ago

  By: Jacob Wilkins

• Unable to get the expected result from the sql server query.

  Hello All, I am having three tables say table A, table B, table C of which table a and table b has …

  shaikhansar786

  2 replies

  10 years, 1 months ago

  By: Hugo Kornelis

• How to achieve "Full word match" value comes from source table column

  create table #Source(Column_source varchar(20)) Insert into #Source values('1'),('2') need to sea…

  Bujji1987

  2 replies

  10 years, 1 months ago

  By: Sergiy

• Select Statement retun records between 12:AM and 12:03 AM

  I'm trying to perform a Select Statement to a record between 12:AM and 12:03 AM select j.name as…

  Welsh Corgi

  2 replies

  10 years, 1 months ago

  By: ChrisM@Work

• Help with xp_cmdshell folder creation

  I have the following script which works great. It creates the folder as required. declare @MD varch…

  CRMUK

  11 replies

  10 years, 1 months ago

  By: Orlando Colamatteo

• Need to sum up a team's win totals in last 5 games

  I have a sports team stat database, where each record contains a teams performance (win , loss, aga…

  archyya

  12 replies

  10 years, 1 months ago

  By: Sergiy

• Are boolean clauses executed always in the provided order?

  Hi! I have a query which needs to filter table according provided filters. I need to filter just by…

  amns

  4 replies

  10 years, 1 months ago

  By: amns

• Trying to replace UNION

  Hi I have a following table CREATE TABLE #Test ( Id int, Principal float, Interest float, Cash…

  SQL006

  17 replies

  10 years, 1 months ago

  By: Luis Cazares

• t-sql 2012 self joins

  In a sql server 2012 database, I have the following table that I need to obtain data from by doing …

  wendy elizabeth

  6 replies

  10 years, 1 months ago

  By: Sergiy

• Pull string between a certain string and a tab (char(9))

  I need to pull whatever the string is in a text column that occurs after the word Requestor: and be…

  Jeff Sims-413169

  4 replies

  10 years, 1 months ago

  By: Jeff Sims-413169

• Simple replace() not working

  I have a table with the column [LC Call Num] (nvarchar(255)), and the table uses the SQL_Latin1_Gen…

  karen.harker

  3 replies

  10 years, 1 months ago

  By: karen.harker

• SQL Issue with minutes represented as decimals ie. 30mins = .30 not .5 ?!!

  My problem is that in the source system, time is entered in terms of .3 is 30 mins and .15 as 15 mi…

  Jabba1963

  3 replies

  10 years, 1 months ago

  By: drew.allen