T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Get windows user..

  Hi, Is there a way of getting the windows user name using an application accessing SQL Server with …

  PiMané

  5 replies

  13 years ago

  By: PiMané

• Multiple reference to a single column

  I have created 3 table in which in T3 table I am referencing the ID columns of table T1 and T2. I h…

  kapil_kk

  4 replies

  13 years ago

  By: Jason Wolfkill

• Extract string between two special characters upto 4 sublevels

  Hi Everyone, Can anyone of you please help me to get the T-SQL to extract a string between two spec…

  ksrikanth77

  3 replies

  13 years ago

  By: Jeff Moden

• convert a PLSQL to T_SQL for a function

  I would like to convert a function from PL-SQL to T_SQL, not sure about the syntax, Any one can hel…

  sqlfriend

  10 replies

  13 years ago

  By: Sergiy

• COLLATION Between two databases, checking on which collate to use

  DATABASE A SQL_Latin1_General_CP850_BIN DATABASE BSQL_Latin1_General_CP1_CI_AS TEMPDBSQL_Latin1…

  TRACEY-320982

  4 replies

  13 years ago

  By: Sergiy

• How to do this type of insert?

  I'm sorry if this question has been asked here, but I couldn't find. I am new to sql and need to do…

  Like2SQL

  6 replies

  13 years ago

  By: J Livingston SQL

• How to create a frequency report

  Hi, I have two tables containing test results in categorical scale. Table one contains PCR results …

  RZ52

  3 replies

  13 years ago

  By: pietlinden

• HOW TO PASS UPDATE QUERY WITH EXECUTE COMMAND

  HI, I have small confusion send the "update" query in execute statement. My requirement is: Without…

  dastagiri16

  6 replies

  13 years ago

  By: Gail Shaw

• Trouble with the IN keyword

  I am creating a script where I am querying a table using the IN keyword. When I type the data insid…

  Dave Bodenheimer-467684

  1 replies

  13 years ago

  By: geoff5

• select the output of stored procedure with count of returned rows

  I want to select the output of stored procedure and the count of the row affected So am trying to d…

  Ali.M.Habib

  1 replies

  13 years ago

  By: brad.mason5

• Logging Raiserror log messages into a table

  Hi, I have several raiserror statements (all informational messages ) inside my stored procedure, C…

  aravind-305595

  15 replies

  13 years ago

  By: Orlando Colamatteo

• HHMMSS int field to human-friendly time?

  I'm looking at the next_run_time field in sysjobschedules, which is stored as an integer with a pre…

  Pam Brisjar

  20 replies

  13 years ago

  By: aniruddh123

• Replacing a string when the value is found in a table

  Hi guys, I'm trying to create a function where I can pass a string value that will be used for sea…

  Jani Lane

  4 replies

  13 years ago

  By: kapil_kk

• A Pivot, but not exactly.

  I have a table that could look like the following: ID FK_ID Value 1 100 …

  TheGreenShepherd

  4 replies

  13 years ago

  By: TheGreenShepherd

• Making Query SQL 2000 compatable

  I have a query i wrote for 2008 to get the top 3 salesPeople per territory by their total sales. It…

  winston Smith

  3 replies

  13 years ago

  By: ScottPletcher