T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Compressing out consecutive runs of data quickly

  This is part of a long and much more complicated process, but I have tried to simplify it for posti…

  Ferguson

  2 replies

  14 years, 11 months ago

  By: Ferguson

• T SQL Trigger on certain columns

  I am looking for examples of an UPDATE query that will only fire if certain columns in a table are …

  GBeezy

  6 replies

  14 years, 11 months ago

  By: MysteryJimbo

• SQL QUERY using HAVING,GROUP BY

  Hi, I am new to SQL and I am still learning SQL. Please help me with this query . Here is the situa…

  NewBie23

  9 replies

  14 years, 11 months ago

  By: NewBie23

• How to write a circular function in T SQL for this scenario?

  Hi all, This is my first question in this forum. Please help me on following problem. Emp Table co…

  raj_paandy

  8 replies

  14 years, 11 months ago

  By: Ron McCullough

• Eliminating Duplicate Rows in SQL server

  Hi guys, I'm new to Sql Server. I have a question here.... I have a table with 6 rows here it goes.…

  sqlnew

  14 replies

  14 years, 11 months ago

  By: Sioban Krzywicki

• Case help

  I have a table table1 with CustomerID, OrderID, Address, AddressTypeID. So each CustomerID can have…

  varunkum

  2 replies

  14 years, 11 months ago

  By: varunkum

• error in select when converting to number and compare

  I have a table1 with it's fields all stored as text Name lastname Age ----- -------- ---- Jo…

  jaytaba

  3 replies

  14 years, 11 months ago

  By: Ron McCullough

• how to pass the bit value in parameters in ssrs2008

  Hi All, i am facing problem in my report, bellow sp working fine in SSMS but inmy report side i am …

  sambireddy chirra

  2 replies

  14 years, 11 months ago

  By: Ninja's_RGR'us

• way to check if windows auth user is real?

  I'm playing around with a little script to add new users. It's just for my own practice/learning fu…

  SQLSandwiches

  5 replies

  14 years, 11 months ago

  By: Ninja's_RGR'us

• *=

  I came across this syntax WHERE territories.regionid *= region.regionid what does *= mean??? I have…

  jameslester78-958147

  2 replies

  14 years, 11 months ago

  By: jameslester78-958147

• Do a grouping by year

  I am trying to write a script that will group by year based on a date: SELECT Count(qlkpApplicantWa…

  Arthur.Lorenzini

  1 replies

  14 years, 11 months ago

  By: Arthur.Lorenzini

• Studio Manager Editing

  Is there a way to edit more than 200 records in the grid in Studio Manager? Warm Regards, Arthur Lo…

  Arthur.Lorenzini

  3 replies

  14 years, 11 months ago

  By: Arthur.Lorenzini

• problem with insert statement

  There are actually many Distinct records that should have been inserted into the temp table. Howeve…

  Faye Fouladi

  7 replies

  14 years, 11 months ago

  By: Faye Fouladi

• RunningTotal on my TSQL don´t return values

  Hello comunity I have build this script above to return the account movment for determinate custome…

  luissantos

  3 replies

  14 years, 11 months ago

  By: luissantos

• Persisted computed columns VS index over computed column

  Hi. I'm wondering about marking a computed column as persisted is useful when I'm using a query ful…

  hillock666

  4 replies

  14 years, 11 months ago

  By: Evil Kraig F