SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Is it possible to grant CREATE PROCEDURE with schema limitations?

  Can privileges be granted to create tables in several schemas while limiting the creation…

  Pete Bishop

  5 replies

  9 years ago

  By: Pete Bishop

• Get total user session with client IP address

  Hi.The following script fetching number of user session. Is there way to get total user session alo…

  SQL Galaxy

  4 replies

  9 years ago

  By: SQL Galaxy

• use exec(@sql) in if exists and get output parameters dynamic sql

  I have result set from @runtimequery like below .I want to set 2 parameters according to the in it …

  mnr123

  4 replies

  9 years ago

  By: sgmunson

• 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

  9 years 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

  9 years 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

  9 years 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

  9 years 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

  9 years 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

  9 years 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

  9 years 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

  9 years 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

  9 years 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

  9 years 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

  9 years 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

  9 years ago

  By: Radders