T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Only allow users to see their own records

  I'm working on the database from hell, so bear with me... (they think 'normalization' is a dirty wo…

  pietlinden

  14 replies

  13 years ago

  By: bgalway

• how to populate month value equally to all business days value and help me to write Stored procedure for below scenario?

  Hi Every Body, i am strucked up in creating stored procedure.... My scenario is: I Have a table S…

  friend.vasu

  4 replies

  13 years ago

  By: friend.vasu

• how to shows results from three queires to one please?

  Hello All I have below 3 sql queries which gives results on order by accounts, Now the question is…

  asita

  3 replies

  13 years ago

  By: Sean Lange

• 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 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 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 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 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 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 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 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 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 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 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 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 ago

  By: ChrisM@Work