T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Counting Decimal Places in a float field

  I have a table with three columns: UniqID, Latitude, and Longitude. I need to write a query to ide…

  hughesj23

  7 replies

  11 years, 8 months ago

  By: Eugene Elutin

• APR Calculation NEEDED.

  I was hoping someone could help me with doing an APR calculation in SQL. I have Loan Amount, # of …

  murrabp

  4 replies

  11 years, 8 months ago

  By: Chris_M

• Need to add Balance of previous Row to Current Row

  Hello I am novice to intermediate writer of T-SQL. I need help with a query. Here is my current Que…

  jameslauf

  9 replies

  11 years, 8 months ago

  By: Alan Burstein

• 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, 8 months ago

  By: ChrisM@Work

• Need help with employee hierrarchy

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

  sunitkrishna

  4 replies

  11 years, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 months ago

  By: sql_learner29