T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• UPDATE statement with INSERT

  This works okay, but it's not really what I want... :crazy: Can anyone help me with a script? IF E…

  SQL_Enthusiast

  2 replies

  14 years, 7 months ago

  By: R.P.Rozema

• Using Intersect in a IF statement

  Assume table1 and table2. col1 in table1 has a row values 'HELLO WORLD' and 'HELLO ALL', which can…

  Blue Rabbit

  4 replies

  14 years, 7 months ago

  By: Lowell

• CASE Statement to count non-nulls

  Hello All, See the sample data below. I need to evaluate Field1, Field2, Field3, and Field4 and ret…

  Chrissy321

  4 replies

  14 years, 7 months ago

  By: Chrissy321

• Difference in PATINDEX behaviour in SQL 2008 vs 2000

  Hello All, I am doing a database migration from SQL Server 2000 to 2008. During migration, I found …

  SMNayak

  2 replies

  14 years, 7 months ago

  By: SMNayak

• Using table valued parameters with SPs pros and cons

  Hi, Just was wondering, from the best practices point of view, are there any disadvantages in using…

  Roust_m

  4 replies

  14 years, 7 months ago

  By: TheSQLGuru

• Help on XML read and insert

  Need help on below XML read and insert... DECLARE @x XML SET @x = '<i18n> …

  s-sql

  2 replies

  14 years, 7 months ago

  By: s-sql

• please interpret sql clause

  What is the following clause, placed in front of an INSERT statement, accomplishing? Specifically …

  KoldCoffee

  11 replies

  14 years, 7 months ago

  By: KoldCoffee

• how to alter user name?

  Hi, Login Name - HWDATA User name - HWData I want to change the user like HWDATA. how to do that? …

  SQL Galaxy

  1 replies

  14 years, 7 months ago

  By: baabhu

• Error with converting to bigint in case statement

  I'm having a problem properly converting a value properly using a case statement. For some reason …

  Rogman

  9 replies

  14 years, 7 months ago

  By: Rogman

• Help with SQL Query

  Hi, i got a table which resembles like IdTypeAddressCity 1Homeabcca 1Officexyzal 1Workrj…

  tripri

  7 replies

  14 years, 7 months ago

  By: tripri

• Date and Time Query Help

  Hello - I need some T-SQL help and hope someone can clear my head of this. I have a query I want t…

  david.ostrander

  6 replies

  14 years, 7 months ago

  By: david.ostrander

• Basing the where clause on certain conditions

  I have some tables which I am trying to perform a join. My result set data comes from the DATA_TABL…

  Rog Saber

  4 replies

  14 years, 7 months ago

  By: Rog Saber

• Help on SQL query

  Hi, I am having data in 2 tables in the following format and I should get data in a single row with…

  NLV

  5 replies

  14 years, 7 months ago

  By: GSquared

• using a table variable.

  So table variables can only be used in cursor functions. What's the best way to handle something li…

  foxjazzG

  4 replies

  14 years, 7 months ago

  By: Sean Lange

• script for Unused index

  Hi, SELECT o.name, indexname=i.name, i.index_id, reads=user_seeks + user_scans + user_lookups, writ…

  SQL Galaxy

  4 replies

  14 years, 7 months ago

  By: deepak.a