Development

• Topics

  Started by

  Posts

  Last post

• Convert ASCII strings to the integer groups of numbers?

  Please help me, my ignorance of SQL and ASCII has lead me to lose temendous amount of time trying t…

  SQL Dummy-659258

  1 replies

  14 years, 10 months ago

  By: WayneS

• Partitioning a HUGE table

  I'd like to get some input, thought on a partitioning project that I am working on. I've been read…

  SQLSalas

  13 replies

  14 years, 10 months ago

  By: SQLSalas

• Query help

  Hi All, Need a help from you guys! I have a column by name Amount and the data is stored in Numeric…

  vijay.singh 97987

  3 replies

  14 years, 10 months ago

  By: vijay.singh 97987

• Export VarChar(6500) column

  [font="Verdana"]Hi All, In a table, I have one column with VarChar(6500). I execute few queries on …

  Mahesh Bote

  2 replies

  14 years, 11 months ago

  By: Mahesh Bote

• Dynamically change the occurrence of columns in a table

  Hi, I have the follo specification Table -- ITEM, MONTH, QTY1, QTY2 A , 1 , 10 , 5 B …

  Ms. V J

  5 replies

  14 years, 11 months ago

  By: Ms. V J

• Cursor within a UDF

  Hi there, I'm having difficulties with the implementation of an existing (and working like a charm)…

  davrose

  30 replies

  14 years, 11 months ago

  By: spaghettidba

• Global Variables for SQL SERVER 2005

  I feel like a freaken idiot asking this :hehe: but searching the web didn't bring up any logical an…

  Rofty

  3 replies

  14 years, 11 months ago

  By: Rofty

• pivot help

  Hi guys, i have the following table TABLE N_1 N_2 N_3 N_4 Modes value abcnu…

  jondy87

  1 replies

  14 years, 11 months ago

  By: WayneS

• pivot\cross tab query generation for multiple aggregation

  Hi, I am in a need of help for pivot query generation for multiple aggregation with varying columns…

  sdevarajan

  3 replies

  14 years, 11 months ago

  By: sdevarajan

• table size issue

  Hi All, I was trying to optimize an enviorment and saw that some of the column in a very large tabl…

  Amit Pandey - Scalability Engineers

  4 replies

  14 years, 11 months ago

  By: Steve Jones - SSC Editor

• set @t1=(select sum(a) from order where type='1') + (select sum(b) from order2 where code='3')

  How can I combine the select clauses so the if order type='1' has a value of 2 and there are no ord…

  joe 82532

  5 replies

  14 years, 11 months ago

  By: WayneS

• Query row count across several databases

  Hi All, I have a server which hosts > 50 databases. About half of these have an identical struc…

  Adrian Smith-294236

  6 replies

  14 years, 11 months ago

  By: Adrian Smith-294236

• Cached Query Plan ...

  I’ve read some forum items regarding WITH RECOMPILE. But would like to know what it’s all about bas…

  Rofty

  18 replies

  14 years, 11 months ago

  By: Nils Gustav Stråbø

• What type of programs are used to create Forms to show data?

  Kind of new to database design and development. I am setting up a small production database to hold…

  Mrfixit1170

  1 replies

  14 years, 11 months ago

  By: steveb.

• Using a declared variable in SQL statement

  Dear All, How can I use a declared variable which has a value from an sql query, I wanna use the re…

  obarahmeh

  6 replies

  14 years, 11 months ago

  By: agnesloyola