T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• will there be a table lock situation while deleting records from a partitioned table ?

  HI Consider the below scenario: I Have a table with 5 partitions based on the org_id. In other word…

  koustav_1982

  4 replies

  13 years, 10 months ago

  By: Gail Shaw

• How to get the SP's based on certain search string

  Hi, I have 100 Stored Procedure. I want to search for 'Employee' key word in all 100 SP's, but it i…

  Shadab Shah

  7 replies

  13 years, 10 months ago

  By: Alan Burstein

• format for phone number

  hi i need to craete table which has phone number field, format (345) 234 - 2345 what is the best da…

  harri.reddy

  9 replies

  13 years, 10 months ago

  By: OTF

• Stored procedure in Where clause

  Hi, below is the query to display the project_name where project_name matches the condition. select…

  Minnu

  2 replies

  13 years, 10 months ago

  By: Eugene Elutin

• Is that strange behavior?

  I am trying to find all users who has no activity and in activity tables we do have some records wi…

  mak101

  2 replies

  13 years, 10 months ago

  By: mak101

• ##table question?

  hello. here is the scenario: sp 1 inserts data in #table, #table is in sp2 and sp3 sp 2 and sp3 are…

  SQL_path

  12 replies

  13 years, 10 months ago

  By: SQL_path

• Suppressinig error values

  I am using a trigger to check some business logic before doing an insert. If the business logic fai…

  sqlnaive

  2 replies

  13 years, 10 months ago

  By: vikingDBA

• Ranking Based on dates

  Hi, I am looking for a SQL which can group and rank the output based on date sequence. I can get th…

  Crazy Nash

  6 replies

  13 years, 10 months ago

  By: Mark Cowne

• missing index script?

  1. First script As below code, wirtten too much overlaping index whenever executing also impact app…

  SQL Galaxy

  2 replies

  13 years, 10 months ago

  By: Cadavre

• does not work with outer join or outer apply

  I am new sql server. I am trying to get the following data. I have 3 different tables table1 table2…

  ylsvani

  13 replies

  13 years, 10 months ago

  By: SQL Padawan

• Validate rows in 2 tables and write log

  Hi, I'm having 2 tables with old and new project numbers, If project number in Table A matches with…

  User7766

  6 replies

  13 years, 10 months ago

  By: John Mitchell-245523

• find a grouping with at least one row within the group containing a certain value

  Hi all, How do you find a group where number of rows in the group are gtr than 1 and at least one o…

  Sha_

  8 replies

  13 years, 10 months ago

  By: Smash125

• Fill the column data with specific row value

  I have 2 tables: A and B This is the result obtained: PKCostCenterAmountAssignment Xfd1 50100…

  deepeshdhake

  8 replies

  13 years, 10 months ago

  By: Lynn Pettis

• Selecting records based on string search

  i've below query to display the project_name column based on the search. here i am passing paramete…

  Minnu

  3 replies

  13 years, 10 months ago

  By: Eugene Elutin

• Nested Select

  I have a table with some Medication information (I didn't create it). One row has the Med Name anot…

  rothj

  8 replies

  13 years, 10 months ago

  By: rothj