T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Cumulative Total

  I have a table with this values: key year month value ------------------------ 1 2011 1 100 1 2011 …

  antonela

  7 replies

  14 years ago

  By: TheSQLGuru

• Number of clients per week on average during year

  I've got an interesting little problem that I can work my way around for a one-off exercise, but I'…

  phual

  6 replies

  14 years ago

  By: phual

• Order column with multiple dots in number

  Hi All, I have the following table: SELECT level INTO #myTable FROM(VALUES('1'),('1.1'),('1.2'),(…

  WesselN

  7 replies

  14 years ago

  By: Mark Cowne

• How to get the overall average

  Hi Forumer's How could i get the overall average for Jan to Dec transaction i want to incorporate i…

  Kaniguan_SQL

  6 replies

  14 years ago

  By: Kingston Dhasian

• Untrusted Foreign Key

  I am finding a few foreign keys in my database that are not trusted select object_name(parent_obj),…

  JohnnyDBA

  4 replies

  14 years ago

  By: okbangas

• Help geting TSQL correct result

  I have a table with an id and code(char(3)) 100, XXX 100, yyy 100, zzz 101, abc 101, XXX I'm trying…

  wrgarfield

  3 replies

  14 years ago

  By: vinu512

• Datetime and sp_executesql Issue

  Here's part of code i've been trying to run in a procedure, cursor is already defined: DECLARE @fo…

  RovanSQL

  10 replies

  14 years ago

  By: Gazareth

• ordering table content

  Hello all, I need to order the resultset from a query in a specific way, but I haven't got a clue h…

  WesselN

  4 replies

  14 years ago

  By: WesselN

• T-sql OrderBy

  Hello, I want the ORDER BY for the below SQL as to display NONE in the first row and then the remai…

  etirem

  3 replies

  14 years ago

  By: etirem

• Querying Week Start date

  Dear all, I have a table called Weeks which is having 2 columns: 1) WeekId [Primary Key auto indexe…

  ramsai1973

  4 replies

  14 years ago

  By: ramsai1973

• how to take database. script with data not backup

  How can I take my database script(with data). Not backup please provide any information . Thanks da…

  dastagiri16

  2 replies

  14 years ago

  By: Sony Francis @EY

• calculate the change in multiple values over time

  Hi all, Im not quite sure how to start scripting this so Im looking for someone to point me in the…

  jfriedl

  7 replies

  14 years ago

  By: Jeff Moden

• Exporting SSIS package in SQL SERVER 2008 R2

  We have an SQL SERVER 2008 R2,in which it has two SSIS packages deployed on it.(We do not have acce…

  Aspet Golestanian Namagerdi

  1 replies

  14 years ago

  By: Adam Haines

• Date Only from Date and Time

  HI Everyone I have something simple that I am getting stumped on. I have a complete date with time …

  AndrewSQLDBA

  12 replies

  14 years ago

  By: WayneS

• COLLATION ERROR

  Hi Guys First and foremost, before I decided to log this issue I did research through the forum and…

  shani19831

  5 replies

  14 years ago

  By: Mike John