T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• columns compare

  --drop table #temp create table #temp (id int, idvalue int) insert into #temp(id,idvalue) select 1…

  raghava_tg

  3 replies

  11 years, 10 months ago

  By: ChrisM@Work

• Need help with employee hierrarchy

  Hi, I need help with the following query: ---------------------------------------------------------…

  sunitkrishna

  4 replies

  11 years, 10 months ago

  By: sunitkrishna

• Script for firstname first letter and lastname

  Hi, I have a column with firstname lastname say 'john fernandez' i have to get jferandez..Please h…

  susmitha117

  1 replies

  11 years, 10 months ago

  By: Sean Lange

• Updating multiple rows

  I need to update a empty column in our SQL database with the login ID for employees of our company.…

  npatel 17252

  2 replies

  11 years, 10 months ago

  By: npatel 17252

• Combine data into one row

  I have two tables that I need to combine, they are as follows: AccountCheckInDT 3289442/14/2014 1…

  pbakos 55417

  3 replies

  11 years, 10 months ago

  By: pbakos 55417

• ms sql pivot count

  I have student table store in student contact number ,parent contact number , name address ,etc. an…

  chamindak

  3 replies

  11 years, 10 months ago

  By: djj

• Procedure Parameter length declaration less than Column length

  is there any way or a tool to identify if in procedure the Parameter length was declarated less tha…

  Bala'

  2 replies

  11 years, 10 months ago

  By: Bala'

• Query for treeview

  I have a query which is working fine. Is it possible that if the table3's column(Child) is only rel…

  fzshah76

  6 replies

  11 years, 10 months ago

  By: tafinami

• Find the Tables that are generated from a SSIS package

  Hi, I have three databases and 40 tables within each database on my server, for each of the tables …

  SQL_Kills

  6 replies

  11 years, 10 months ago

  By: SQL_Kills

• Search based on a table name and add code to the existing Stored Procedures

  Below is sample SQL: SQL_1: Creates a database SQL_2: Creates 2 stored procedures Now, I need to se…

  etirem

  6 replies

  11 years, 10 months ago

  By: Sean Lange

• show changes from and changes to in a history table

  hi! I have a table history of Employee data. id | EmpNo | EmpName | MobileNo | Email | EmpSSS | Upd…

  idaaureajimenez

  4 replies

  11 years, 10 months ago

  By: Xedni

• Query help- Need to create dummy rows

  Hi All, I have a requirement that I need help with, I am getting the table Mytemp populated from S…

  sql_learner29

  4 replies

  11 years, 10 months ago

  By: sql_learner29

• Is the comparison of HashPasswords happens at the client level or db level?

  This is to follow up this thread on writing a user authentication script for a client application. …

  sleekbinary01

  5 replies

  11 years, 10 months ago

  By: x

• Need help with query

  Hi All I have a data set as given below : CodeStartDate EndDate UpdatedDate 1…

  arijit rath

  6 replies

  11 years, 10 months ago

  By: Jeff Moden

• Query help

  I have two tables. The first (tblInternalAuditRequirement) houses internal audits that are require…

  skilly2

  4 replies

  11 years, 10 months ago

  By: Eirikur Eiriksson