T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Running Totals on PIVOT in T-SQL

  I have the following query SELECT * FROM ( SELECT Product ,[201101],[201102],[201103],[201104],[201…

  SQL STEWIE

  7 replies

  14 years, 3 months ago

  By: SQL STEWIE

• clubbing a group of column values orderwise

  Hi, could you please help me to get a T-SQL statement for a scenario where if there is a table with…

  DataAroma

  2 replies

  14 years, 3 months ago

  By: Dwain Camps

• Grouping by month with null months

  So I've been working on this for a little while now and I just can't get it. Consider it a real big…

  calvo

  2 replies

  14 years, 3 months ago

  By: Gazareth

• Error while bcp

  I'm trying to bcp in data from a text file in unix to my sql server. It gives error as Unexpected E…

  sqlnaive

  5 replies

  14 years, 3 months ago

  By: sqlnaive

• Get the course which has maximum no.of students enrolled

  Hi , We have 3 tables for ex student(sid,sname,dob), course(cid,cname,duration) and enroll(sid,cid,…

  ralm

  5 replies

  14 years, 3 months ago

  By: ralm

• PIVOTING on more than One Col. to get data in given format.

  Dear All, Hi! I am searching a solution to PIVOT more than one column to get output in below mentio…

  bharat sethi

  1 replies

  14 years, 3 months ago

  By: Dwain Camps

• Using (Updlock,Rowlock) in Select statment

  I have (Updlock,Rowlock) in a select statment(Transactional).The Select statment has a structure as…

  Aspet Golestanian Namagerdi

  5 replies

  14 years, 3 months ago

  By: sayap

• Delete Incremental Load of Data without Identify Column or DateTime Stamp

  I performed an initial load of data into hundered of tables. I did not create the tables, if I had,…

  Welsh Corgi

  3 replies

  14 years, 3 months ago

  By: Dwain Camps

• create forign key statement

  whenever I generate SQL statement of Forign key I got something like the below statement: ALTER TA…

  sqlfriend

  13 replies

  14 years, 3 months ago

  By: sqlfriend

• syntax error

  hi whats wrong with this exp =iif(trim(cstr(Fields!Total.Value ="")),"?",iif(trim(cstr(isnothing(Fi…

  hbtkp

  3 replies

  14 years, 3 months ago

  By: Gail Shaw

• Query doesn't return data when checking a varchar(max) field...

  How can I get my query to get results and stop timing-out when I include a varchar(max) field in my…

  andegre

  12 replies

  14 years, 3 months ago

  By: andegre

• best way to load data

  I have a new sql server 2008 r2 database that I am in the process of setting up. I would like to kn…

  wendy elizabeth

  1 replies

  14 years, 3 months ago

  By: CapnHector

• 2008 import from excel not allow to run immediately

  I am trying to copy an excel file to my table. I have 2 tables (Cert and Cert$). If I use Cert$, …

  tshad

  3 replies

  14 years, 3 months ago

  By: drew.allen

• rmove leading zeros

  --basically just need a quick way to remove leading zero's declare @string varchar(7) set @string …

  Snargables

  11 replies

  14 years, 3 months ago

  By: Snargables

• String Concatenation with Colon Issue

  Am i missing something glaringly obvious here, i thought it would be good practice to play around w…

  ubeauty

  2 replies

  14 years, 3 months ago

  By: sqldba.today