T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

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

  By: sqldba.today

• sql query group by weekend

  Here is the scenario. I want to write a query to find out which employees have preformed a service…

  dweil

  13 replies

  14 years ago

  By: drew.allen

• How to use rank over this query

  Hi All, Any help with this query is really appreciated. create table test(stageid int,sta…

  Deepthy

  5 replies

  14 years ago

  By: Deepthy

• Query Help

  I have a table like this: Col1[Varchar(20)]Col2[numeric(28,2)]Col3[Datetime] DB112.242012-0…

  sqlnaive

  1 replies

  14 years ago

  By: Thinknook

• Script to get CPU usage

  Hi All We use the below script to calculate the CPU usage across our servers DECLARE @ts_now BIGIN…

  Ant-Green

  8 replies

  14 years ago

  By: Ant-Green

• Text file as script input

  Hiya, I have this script; USE [master] CREATE LOGIN [DOMAIN\User.Name] FROM WINDOWS WITH DEFAULT_DA…

  lanky_doodle

  3 replies

  14 years ago

  By: lanky_doodle

• A Developer's scalar UDF is takeing this query from 3 seconds to over 5 minutes to run

  Have a situation here where a developer has written a query that includes a scalar UDF to parse thr…

  MyDoggieJessie

  38 replies

  14 years ago

  By: Jeff Moden