T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months 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

  13 years, 10 months ago

  By: Mike John

• Need hale parsing the following string example

  Hello, looking for t-sql that would be able to parse the following strings and convert them to just…

  oradbguru

  7 replies

  13 years, 10 months ago

  By: oradbguru

• Try Catch error

  Could someone explain to me why this try catch still returns an error if the job is not running? I…

  GregoryF

  1 replies

  13 years, 10 months ago

  By: HowardW

• Query to return 1 or unique value

  Hello, I am using SQL 2k8 R2. My colleague would like query that will return unique value if all th…

  Hardy21

  5 replies

  13 years, 10 months ago

  By: Cadavre

• Extract related values recursively

  I have a table like this : salesinvoiceidsalesreceiptid aA1 aB1 bB1 bC1 cC1 dD1 At any point…

  sridhar_kola

  6 replies

  13 years, 10 months ago

  By: Dwain Camps

• is nvarchar(2000) is big or BIGINT is big in size

  Hi Experts, I have a column of nvarchar type. is it good to create index on this. …

  chaithu559

  3 replies

  13 years, 10 months ago

  By: Gail Shaw

• Insert into two different tables

  Hi, i have two tables and i want to insert data in these two table with one click IF OBJECT_ID('Te…

  MuhammadShafiq

  9 replies

  13 years, 10 months ago

  By: MuhammadShafiq

• Bulk Insert/BCP .xml file containing Chinese characters

  Hello specialists. I am attempting to load an xml file that contains Chinese/Russian characters int…

  david.tyler

  1 replies

  13 years, 10 months ago

  By: Jesse Reich