T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Using the salary table on the left, write a SQL Server T-SQL query to find the Top 2 salaries for each employee. The result of the query is on the right.

  Employee id Salary Employee id …

  rko.37gags

  28 replies

  15 years, 4 months ago

  By: Jeff Moden

• TSQL 2K5 - How to get All parent tables followed by all child tables in one select

  hello guys, I want to get parent-child PK-FK hierarchy in one select statement and one table output…

  iBar

  2 replies

  15 years, 4 months ago

  By: iBar

• sum - union

  Okay so I have writing this SQL query and I am trying to pull the total sum of 3 selected rows as a…

  tn_350z

  3 replies

  15 years, 4 months ago

  By: Hardy21

• Store values in variable

  I have a list of values that I want to store in a variable in SQL server 2005. DECLARE @State varch…

  mark_close11

  4 replies

  15 years, 4 months ago

  By: WayneS

• matching values

  Hi, would the following query make any difference if I joined the two tables using a candidate key …

  Marcus Farrugia

  11 replies

  15 years, 4 months ago

  By: Marcus Farrugia

• Pad nvarchar with trailing spaces

  I'd like to pad an nvarchar field with trailing spaces to make the length a uniform 23. Is there an…

  Glenn

  5 replies

  15 years, 4 months ago

  By: Sean Lange

• Getting Time gap in day

  I have a requirement wherein there are 2 columns : In Time and Out Time. I need to get the time gap…

  ns.sharath

  4 replies

  15 years, 4 months ago

  By: dbuendiab

• How to prevent the truncation of the leading zero in a varchar string?

  I am working on a function that will return the military julian time in the format of YYDDD, where …

  MothInTheMachine

  4 replies

  15 years, 4 months ago

  By: MothInTheMachine

• Linked Servers

  Hi I have various scripts that use linked servers to obtain data from various distributed systems -…

  guynethers

  1 replies

  15 years, 4 months ago

  By: Adiga

• Minimum one Transation for a given day

  Hi all, I have a transaction table. I'm filtering on date values to get a report. the situation …

  Anamika

  4 replies

  15 years, 4 months ago

  By: tfifield

• IN operator only returning first match

  Hi, I have a problem with some code in my query. I'm using an IN operator as a filter (within a WHE…

  DerbyNeal

  4 replies

  15 years, 4 months ago

  By: scott.pletcher

• Help with max value that includes Image in select ....

  I have the following table: ID EmployeeNumber EmployeePhotograph EmployeeSignature …

  Roy Wiggins

  2 replies

  15 years, 4 months ago

  By: Derrick Smith

• Any way to get OPENQUERY to connect back to a SQL Server table

  Basic situation: I run one complicated set of OPENQUERYs against DB2 and T-SQL queries against my D…

  Pam Brisjar

  5 replies

  15 years, 4 months ago

  By: GSquared

• master.dbo.xp_cmdshell Error

  I need to create a stored procedure that would perform an automatic database restore from 1 server …

  LOOKUP_BI-756009

  5 replies

  15 years, 4 months ago

  By: bbowersock

• UDF in UPDATE affect performance ???

  All, will UDF in an UPDATE statement affect the performance? I hope so. UPDATE #Result SET DataSour…

  karthik M

  18 replies

  15 years, 4 months ago

  By: Jeff Moden