SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How to select the column names of columns with a specific value

  Hey guys Suppose I had the following table columns as well as the row: MyTableCol_A  &nbs…

  dndaughtery

  4 replies

  8 years, 4 months ago

  By: Phil Parkin

• Parameterless stored procedure to update insert

  I am working on a stored procedure that is supposed to insert or update rows in a remote table. I t…

  itortu

  8 replies

  8 years, 4 months ago

  By: itortu

• Need help to find employee history

  Can anyone help me with this?I need to find the allocation history of projects for employees.For th…

  sunitkrishna

  2 replies

  8 years, 4 months ago

  By: TheSQLGuru

• Distinct values from 2 columns

  I want to get the distinct values from this table as row no 3 and 10 are the same .I just want to d…

  mnr123

  5 replies

  8 years, 4 months ago

  By: autoexcrement

• How to combine two rows as one row for transactional Data

  Hi, Because of the application issue, we are seeing partial duplicate row, how to combine duplicate…

  Sangeeth Raj

  6 replies

  8 years, 4 months ago

  By: Thom A

• Using Queues

  I have searched for the last 4 hours looking for how to implement a simple queue system in SQL Serv…

  mike 57299

  6 replies

  8 years, 4 months ago

  By: TheSQLGuru

• If exists table dynamic sql from variable database id

  Hi  I want to write if the table exists in the database in dynamic sql then select from that t…

  mnr123

  1 replies

  8 years, 4 months ago

  By: Ed Wagner

• Msg 203, Level 16, State 2, Line 38 s not a valid identifier.

  DECLARE @CountResults TABLE (CountReturned VARCHAR(1000)) declare @SqlStatement varchar(8000) …

  mnr123

  4 replies

  8 years, 4 months ago

  By: Thom A

• How to find all procs in a DB which cross reference other databases

  Hi AllI need to find all procs from a database which reference tables from another databases. all m…

  S_Kumar_S

  4 replies

  8 years, 4 months ago

  By: Super Cat

• Simplifying a CASE statement

  Hi  I'm new to CASE statements and wondering if the following can be simplified: SELECT &…

  Lorna-331036

  4 replies

  8 years, 4 months ago

  By: Thom A

• Using Variables in Stored Procedure

  Hi I have a stored procedure (see below) from which I need to get the Total Profit which will basic…

  Lorna-331036

  4 replies

  8 years, 4 months ago

  By: Lorna-331036

• Replicate process from excel to sql

  Hi All,I have a script that outputs data to a txt file which is then manipulated in excel to g…

  Radders

  10 replies

  8 years, 4 months ago

  By: Radders

• How to create a delta result-set by looking at a date_edited column

  Hello all, I have a stored procedure that looks at a user profile table, to create a list of users…

  itortu

  6 replies

  8 years, 4 months ago

  By: itortu

• is there any diffrence between fn:lower-case and lower_case function in sql server

  hi,       In x query of sql-server, there is a function which can be calle…

  rajemessage 14195

  1 replies

  8 years, 4 months ago

  By: Eirikur Eiriksson

• What's the best way to get a sample set of a big table without primary key?

  This is what is happening here: We have lots of big data, table's size is often around billion and …

  halifaxdal

  28 replies

  8 years, 4 months ago

  By: Jeff Moden