T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Complicated query

  Hi all ! i have the following table structure : id(Identity) time action 1 …

  jenyaalt

  5 replies

  14 years, 2 months ago

  By: Jeff Moden

• how can i insert in udf

  i have 1 udf which returns RETURNS TABLE how can i add into it

  hbtkp

  85 replies

  14 years, 2 months ago

  By: Jeff Moden

• using t-sql to roll-up aggregated info.

  I think that what I want is impossible to achieve with T-SQL alone. . . please tell me if it *is* p…

  KoldCoffee

  29 replies

  14 years, 2 months ago

  By: CapnHector

• Multiple self joins with Count function goes wrong

  Hello everyone 🙂 good site, very comprehensive, though after routing round I’m still having trouble…

  turk_thrust

  6 replies

  14 years, 2 months ago

  By: turk_thrust

• The DELETE statement conflicted with the REFERENCE constraint

  I tried to delete records in some tables. I got an error: The DELETE statement conflicted with the …

  sqlfriend

  17 replies

  14 years, 2 months ago

  By: sqlfriend

• Looping through each server and each database in the estate to find dbo aliases

  Hi Guys, As a part of security audit reporting i need to find out all logins who have the dbo role …

  Swanand Bagve-354281

  1 replies

  14 years, 2 months ago

  By: GSquared

• Index Rebuild and Fillfactor

  Hi, I have a table with 17 indexes... I execute a query to check the fragmentation level and get 16…

  PiMané

  8 replies

  14 years, 2 months ago

  By: Eugene Elutin

• fetching date from 1 sp to another

  i have one sp(sp1) which return values for the specific periods now i have another sp (sp2),which…

  hbtkp

  87 replies

  14 years, 2 months ago

  By: Brandie Tarvin

• Syntax help required

  I want to return one (top) row for each set of events, a set of events are defined by having the sa…

  ZombieRick

  18 replies

  14 years, 2 months ago

  By: jimbobmcgee

• mult joins

  Can you join a table to multiple columns?

  l090475

  6 replies

  14 years, 2 months ago

  By: Lynn Pettis

• Migrating data in sql server from source to target with Schema change in target

  We have a strange scenario, in which source DB's (sql server 2005) table will just have the data wi…

  PiratePrasad

  4 replies

  14 years, 2 months ago

  By: PiratePrasad

• pivoting against two columns

  I have a working pivot query. I want to add two more columns to it, that also must be pivoted. I …

  xenophilia

  4 replies

  14 years, 2 months ago

  By: vinu512

• how to integrate a solution into existing query

  I have a working query. It was given to me by ColdCoffee ( http://www.sqlservercentral.com/Forums/…

  KoldCoffee

  4 replies

  14 years, 2 months ago

  By: CapnHector

• Do not grant permission to create or modify the database objects

  Hello All, I have created 2 active directory groups.One groups has full permissions with sysadmin r…

  SQL Prog

  4 replies

  14 years, 2 months ago

  By: Lynn Pettis

• T-SQL help

  Hi, Can you please help me in getting the result set in a different way. I used CROSS JOIN but it i…

  etirem

  8 replies

  14 years, 2 months ago

  By: drew.allen