T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Multiple condition based on where clause in sql server 2008

  I had a table Product with these fields ProductName, Description, Manufacturer, Product Code, Tech…

  SQL006

  2 replies

  13 years, 1 months ago

  By: SQL006

• help with inventory of database logins and permissions

  I ran this script to get a list of all database logins, but it does not give the same results as wh…

  KoldCoffee

  14 replies

  13 years, 1 months ago

  By: KoldCoffee

• Remove characters after last slash in string

  Hi All I have the following string declare @string varchar (100) set @string = 'x:\folder1\folder2\…

  SQLSACT

  9 replies

  13 years, 1 months ago

  By: ScottPletcher

• Splitting rows in HTML from sp_send_dbmail

  Greetings, I would like to send a daily email that shows in HTML the changes of our staff from the …

  gmrose

  1 replies

  13 years, 1 months ago

  By: Robert Klimes

• PK insertion error

  Hello everyone. I hope someone can confirm or deny my thinking here an offer some advice. Here is m…

  MickyD

  2 replies

  13 years, 1 months ago

  By: MickyD

• Odd behavior

  I have the follwing line generating a where condition for me in my dynamic sql statement (select ca…

  Erin Ramsay

  2 replies

  13 years, 1 months ago

  By: Erin Ramsay

• Problem with CAST to VARCHAR with SUBSTRING Function

  I'm haveing trouble with a simple CAST to VARCHAR Statement. SELECT CASE WHEN CAST(LEFT(Customer.S…

  Welsh Corgi

  23 replies

  13 years, 1 months ago

  By: MMartin1

• First Stored Procedure

  I have written my first stored procedure to try to pass a table name in a variable to SSRS. USE XXX…

  ringovski

  4 replies

  13 years, 1 months ago

  By: MMartin1

• System M Derived in SQL Server ?

  All, I have recently read the below articles. https://www.simple-talk.com/sql/performance/join-reor…

  karthik M

  4 replies

  13 years, 1 months ago

  By: David Webb-CDS

• Some guidance needed....

  I am wondering how I should go about handling weighted by month calculations for a trending report.…

  Paul Morris-1011726

  2 replies

  13 years, 1 months ago

  By: Paul Morris-1011726

• how to retrieve the data when a comma separated ids are sent as input parameters

  Dear all, I have two tables namely: 1. User table 2. Location table Given below are their design de…

  ramsai1973

  3 replies

  13 years, 1 months ago

  By: Lynn Pettis

• Performance Problem In a Procedure

  Hi, I feel sorry that in my previous post I put very limited information about my question and apol…

  chandan_jha18

  9 replies

  13 years, 1 months ago

  By: ChrisM@Work

• Mapping Old identity values to new ones

  Hi All, I have a requirement in which I insert values into same table, but I need to map old identi…

  chandrakant_gaurav

  2 replies

  13 years, 1 months ago

  By: Kingston Dhasian

• nvarchar

  From my understanding nvarchar allows you to store more than one language compared to varchar. Does…

  sstacy7

  3 replies

  13 years, 1 months ago

  By: Jeff Moden

• Remove Duplicates from a Table using specific columns

  Hi Gurus, I am new to Teradata and working on a requirement. Below is the table Col1 Col2 Col3 Col…

  Babbi

  2 replies

  13 years, 1 months ago

  By: Sergiy