T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Select ALL logins, users, and user groups shown in SSMS Security > Logins

  Apologies for the repost. I may have posted in the incorrect (SQL Server 2005 General Discussion) f…

  mgmiller

  2 replies

  11 years, 6 months ago

  By: mgmiller

• how to calculate Average Time Duration

  Hi, I am counting values from database like Total Calls Made:0:53:29 , Total Calls Received:0:11:25…

  suresh0534

  2 replies

  11 years, 6 months ago

  By: fahey.jonathan

• Aggregate data based on 1 hour intervals

  Hello, I need to write a SQL query that aggregates data based on 1 hour intervals. So, basically I …

  DaveDB

  3 replies

  11 years, 6 months ago

  By: fahey.jonathan

• update table using parameter variable

  hi i have a stored proc which is used to make updates and inserts to a table passed in as a string …

  spin

  4 replies

  11 years, 6 months ago

  By: Jeff Moden

• How to duplicate existing rows?

  I have difficulties solving a problem. I'll try to explain the problem the best I can. I got two t…

  chholm

  8 replies

  11 years, 6 months ago

  By: Phil Parkin

• executing dynamic sql string

  hi (me again) i'm trying to get a proc to execute by passing in a dynamic sql string. this works...…

  spin

  6 replies

  11 years, 6 months ago

  By: spin

• unpivot dynamic columns

  hi i have a table which i need to unpivot. It is always in 2 year ranges (months) so looks somethin…

  spin

  5 replies

  11 years, 6 months ago

  By: Phil Parkin

• NTEXT data truncated when run from an Server Agent Job

  I am mystified by a problem when handling NTEXT data in SQL Server 2005 SP3. I often have to query …

  Andy sql

  4 replies

  11 years, 6 months ago

  By: karsten.jacques

• java.sql.SQLException: Warning: Fatal error 824 occurred at Dec 5 2013 10:11AM. Note the error and time, and contact your system administrator.

  java.sql.SQLException: Warning: Fatal error 824 occurred at Dec 5 2013 10:11AM. Note the error an…

  mohan11cbi

  2 replies

  11 years, 6 months ago

  By: Gail Shaw

• Column type conflict in Unpivot list

  hi All, I am having problem with the unpivot. Below is the sample table and the sample data, I have…

  sharonrao123

  10 replies

  11 years, 6 months ago

  By: zelriak

• create date list

  Hi i have a table with accountid, stockid, startdate, enddate. i need to create a table which is a …

  spin

  3 replies

  11 years, 6 months ago

  By: Dwain Camps

• Getting IS_Member to work as expected

  I have custom role with permissions called Admin_role. however, when I try to determine if current …

  Doug S.

  10 replies

  11 years, 6 months ago

  By: shimondspam

• Concatenating a varchar(max) column

  Hi, I'm having trouble concatenating multiple rows in a table into a single varchar(max) variable. …

  jonathon

  9 replies

  11 years, 6 months ago

  By: ravi090191

• fn_virtualfilestats

  Can anyone tell me why the following query will run against a database with a compatibility level o…

  JWOL

  5 replies

  11 years, 6 months ago

  By: Gail Shaw

• calculate months days for start and end date (each month)

  Hi i want to be able to return the number of days for each month in a given start/end date. so, sta…

  spin

  9 replies

  11 years, 6 months ago

  By: Lynn Pettis