T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to copy a role and its permissions?

  Is there a similar command as the one for table to copy everything from a role to another role? For…

  tilew-948340

  20 replies

  14 years, 5 months ago

  By: tilew-948340

• Need help filtering out a record where 1 column makes it not a duplicate

  I have the following query SELECT Distinct SBBACLOAN ,[SBNAME1] ,[SBBRS…

  dndaughtery

  5 replies

  14 years, 5 months ago

  By: Paul White

• Restart Counting with Row_Number()

  I have a puzzle, I need to find out how many days an employee had a certain status in a row, like 1…

  g.griffin

  16 replies

  14 years, 5 months ago

  By: Paul White

• AS400 SQL Query

  Good morning, in light of the fact that I got such great help with a much simpler query yesterday, …

  mbrady5

  6 replies

  14 years, 5 months ago

  By: drew.allen

• Problem with syntax (declaration) in stored proc

  Hi all, I have the following query: -- ================================================ -- Template…

  info-849042

  6 replies

  14 years, 5 months ago

  By: GSquared

• Passing outer query value to inner query in update query

  I am having trouble getting this update correct: DECLARE @TopNumINT, @TopNum2INT, @AcctNum…

  DougG

  8 replies

  14 years, 5 months ago

  By: DougG

• Query help -

  I am working on SQL server 2008 R2 I have a table as following TableA clientcode | days 101 | 30 1…

  Guras

  4 replies

  14 years, 5 months ago

  By: Guras

• Query Help...very slow running

  Good morning, does anyone have any suggestions as to how I might be able to rewrite this query? It …

  mbrady5

  10 replies

  14 years, 5 months ago

  By: Paul White

• Help with a SELECT statement using GROUP and SUM

  [font="Courier New"]Given a table of transaction consisting of the following columns: CardType nv…

  raisleger

  8 replies

  14 years, 5 months ago

  By: Paul White

• Urgent help with T-SQL - good test!

  Hello everyone, I am working on a stored procedure which will be executed by SQL job on a scheduled…

  krishna.vanne

  4 replies

  14 years, 5 months ago

  By: krishna.vanne

• Generate CLuster IDs based on 2 columns

  Hello guys, I have the following table with the following data: create table tbl1 ( ClusterID VARCH…

  andrei.burdun

  14 replies

  14 years, 5 months ago

  By: andrei.burdun

• Table Partitioning Issue

  CREATE TABLE [dbo].[SalesHistoryArchive]( [SaleID] [int] IDENTITY(1,1) NOT NULL, [Product] [varch…

  Bhuvnesh

  12 replies

  14 years, 5 months ago

  By: Paul White

• aggregation, still learning how to produce results - please help #3

  I am having trouble constructing an aggregation query which shows the total number of invoices, tot…

  xenophilia

  7 replies

  14 years, 5 months ago

  By: drew.allen

• My XML skills are poor when querying SSRS

  I'm trying to query SSRS to find the data sources for reports based on models I have this query ;W…

  mtassin

  5 replies

  14 years, 5 months ago

  By: mtassin

• Help with Logic

  Help with query. I have a table with columns PAN ProgramID TransactDate I need to write a stored p…

  sandyschiru

  1 replies

  14 years, 5 months ago

  By: Gail Shaw