T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Query that returns change details

  I have attached a sample database (forum) that contains a single table 'Audit'. The table has 3 rec…

  2Tall

  3 replies

  14 years, 10 months ago

  By: 2Tall

• help to find 90% records.

  Hi, I am having a table which contains iislogs in standard format.From that table i have to find to…

  abhas

  5 replies

  14 years, 10 months ago

  By: spaghettidba

• Backup/Zip Operation: Too many resultsets

  I have a SQL Server 2005 box with about 300 databases on it. The server doesn't have enough space f…

  Seth Kramer

  2 replies

  14 years, 10 months ago

  By: Seth Kramer

• Update statement returns different results each time it runs

  I have an update statement that returns a different value each time it runs. I'm not sure why. Th…

  Luke79

  6 replies

  14 years, 10 months ago

  By: homebrew01

• Shirnk .Ldf File

  Hello Can anybody give suggestion for shrink .ldf file my ldf file size is 37 GB how can I shrink 5…

  uplavvpatel

  5 replies

  14 years, 10 months ago

  By: arindamb

• Help to write a query to calculate # of hours between two records.

  From the below table, I need to calculate the number of hours took from creation to finalize and sh…

  lookpete

  1 replies

  14 years, 10 months ago

  By: GSquared

• Looping through variables

  Hi All I’m trying to write a query that would loop through ten variables and print the values of th…

  nplace6530

  2 replies

  14 years, 10 months ago

  By: TheSQLGuru

• Variable field length join

  Hi, I have a join consisting of two tables (VCTMovements and VCTHaulageMileageLog). SELECT * FROM V…

  DerbyNeal

  2 replies

  14 years, 10 months ago

  By: DerbyNeal

• Incomplete Dataset when Using Over(Partition By)

  Does anyone else has an experience of using Over(Partition By) and getting an incomplete data set. …

  Janie.Carlisle

  2 replies

  14 years, 10 months ago

  By: SQLRNNR

• Trying to determine the value one column when selecting MAX aggregate on another column

  I have a table that looks something like this: EventID Ev_Cat Ev_Date Ev_status 1 …

  dmcquade

  3 replies

  14 years, 10 months ago

  By: GSquared

• SQL Query - Return operation over Multiple Dates

  Hi I am new to SQL and I am just wondering if there is a solution to a problem I am having. I am us…

  eoghanmaths

  1 replies

  14 years, 10 months ago

  By: Ron McCullough

• Help with a basic query

  Hello, I hope someone can help me out. I am trying to select the maximum log size in a table column…

  Duran

  2 replies

  14 years, 10 months ago

  By: Duran

• Stored procedure with parameters not working

  I have created a stored procedure that takes 2 parameters which are 2 database names. Within the pr…

  eseosaoregie

  5 replies

  14 years, 10 months ago

  By: Arjun SreeVastsva

• script out database permissions to a file

  Hello I have a restore job that runs one of our servers and I have to script out all the permission…

  matthew.peters

  5 replies

  14 years, 10 months ago

  By: pankushmehta

• get the negative and equal value of the other column

  Hi to all, Need help on this one, Basically the problem is this. If the ItemSubID is NULL then the …

  Teemo

  2 replies

  14 years, 10 months ago

  By: Teemo