Programming SQL

Adding extra rows in a select result set
Hello, I would like to generate extra rows based on a value from a table column without using union? I'm stump here..... --Rules: -- when partnumber = ty67892 add 2 extra rows in results -- when partnumber = nb67j3e add 4 extra rows in results -- when partnumber = sdx5x78 add 7 extra rows in reults --a... 11 Aug 2010 13:40

CREATE BLANK ROWS BETWEEN DATA
I wanted to reate blank rows in my data sheet which having more than 1,00,000 nos of rows On Tuesday, February 09, 2010 12:34 PM Rich wrote: I need to insert a blank row between each group of rows as follows. What is the tsql to accomplish this ? (2000 or 2005 tsql ok). create table #tmpA(rowID in... 11 Aug 2010 07:07

Question on anatomy of a query
I was looking at an article by Plamen Ratchev (which I had printed a while ago but can't find it online anymore) where he states that the first thing a query does if there are 2 tables involved is create a Cartesian Product (cross Join) between each table. Then the ON filter is applied. If Table A has 20,000,0... 12 Aug 2010 23:33

Top 2 from count
Hi! i have a table "tickets" and i need the top 2 most visited stores for every customer. create table #Tickets(ID int primary key, Store int, Customer int) insert #Tickets select 1,1,1 union all select 2,1,1 union all select 3,2,1 union all select 4,1,1 union all select 5,2,1 union all select 6,3,2 uni... 10 Aug 2010 16:56

UPDATE using SUM
I have a stored procedure where I am trying to update a temp table in the flow of the sp. I have tried the code below but it gives me an error "Incorrect syntax near the keyword 'GROUP' and I understand the error but don't know how to get around it and still get sums. Can anyone help? Thanks. UPDATE #tem... 11 Aug 2010 14:45

Sql server 2008 r2 hangs up
Dear all, I am using sql server 2008 r2 as a database and have enabled few properties of it as alter database databasename set ALLOW_SNAPSHOT_ISOLATION on alter database databasename set READ_COMMITTED_SNAPSHOT on because I wanted it to use it in buffering mode. Now I am facing problem as my ... 10 Aug 2010 16:56

Getting text message from DBCC commands
Hi All I'm developing an administrative tool to fix some of the frequent occuring issue just in time. For that I need to run DBCC CHECKTABLE with some parameters. I created a stored procedure for this and everything works fine except returning text message of DBCC commands back to calling application (Reporting Se... 11 Aug 2010 18:03

How to show chinese charaters?
Hi all I have a table with chinese characters, but when I try to do a select I have this... Select ID, chinese_text From table1 ID chinese_text 216 ?????? / ?? 117 ?????? / ?? 230 ?? (??) / ?? How to tell the server in order to show the correct strings in chinese? (Sql server 2005) Thanks a lot. ... 11 Aug 2010 08:11

Help with the SP.
LN (LN(a)discussions.microsoft.com) writes: I am try to search for a date like 01/01/1900 but it does not. I found this sp on web site and wonder if you can help debugging the probblem. I try to run the sp to return all the columns and tables that have 01/01/1900 values in the tables. Dates are not stor... 9 Aug 2010 16:49

impersonate SQL Server login
Hello, we are using SQL Server 2005 , I have the admin role and know SA Password , once in a while I receive calls from users in the network complain about some error , some times error is not clear and I have to login using user's password instead of SA to see what's happening , to do that I have to reset u... 9 Aug 2010 09:01