T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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 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 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 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 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 ago

  By: drew.allen

• Replace Hard Code Table Names with Dynamic SQL, Execute and Return Results Single Row

  Hi Clever T-SQL Experts. I had the following, it returns the Count(*) in two tables in a single row…

  Welsh Corgi

  23 replies

  14 years ago

  By: Welsh Corgi

• No rows Returning

  Hello, I've a table with a numeric and date columns. Assuming a,b are the column names, I'm writing…

  sqlbi.vvamsi

  11 replies

  14 years ago

  By: Sean Lange

• Return Record Counts Dynamically in a single row result -- EXEC TASK

  Post removed. For better, quicker answers on T-SQL questions, click on the following... http://www.…

  Welsh Corgi

  3 replies

  14 years ago

  By: Welsh Corgi

• inner join with several fields...

  Is it possible to JOIN two tables by combining two columns in one table into a "key" and join it to…

  memymasta

  10 replies

  14 years ago

  By: Lynn Pettis

• What effects Indexed Views actually have

  I have an issue. We are dealing with a new system where they have thier schema(which is unbarable…

  xgcmcbain

  4 replies

  14 years ago

  By: Gail Shaw

• Urgent please help: Need the following.

  I have a table named as "querylog" which looks like follows with 3 columns. In the column "selected…

  Mac1986

  6 replies

  14 years ago

  By: drew.allen

• String search

  Hello all, I have an issue with string search from a free text field. --SAMPLE DATA CREATE TABLE #…

  ssc_san

  1 replies

  14 years ago

  By: ssc_san

• Question related to NOLOCK

  Session A: Select * from mytable (NoLOck) What does this query exactly do.. Option 1: If there is s…

  itskanchanhere

  8 replies

  14 years ago

  By: Gail Shaw

• dst and gmt adjustment

  Hello, I wish to have one of my date columns to adjust with dst and utc and populate in computed c…

  tracmonali

  2 replies

  14 years ago

  By: ColdCoffee

• inverting datetime!

  Hi i have this line in my store procedure: select * from MainVideo where LEFT (datetime,11)=LEFT (@…

  nazaninahmady_sh

  3 replies

  14 years ago

  By: Jeffrey Williams