Topics
Started by
Posts
Last post
I have two identical tables. Table 1 has 12,000 rows and Table 2 has 11,000 rows. I need to insert …
4 replies
I have two tables Table A -------- ItemID Date Table B --------- ItemID ParentID Records in Table A…
21 replies
Hi I'm not sure if I misunderstand something. I use CHECKIDENT to reset the value of a IDENTITY col…
2 replies
I am getting the out put of a query as SN NodeName NodeValue 1 Address address1 1 Addres…
6 replies
Hi, Just for the sake of information i was learning how to store data into database. I came across …
2 replies
hi i am getting following error while attaching mdf file in my SSMS. ------------------------------…
5 replies
Hi , Consider the below scenario : I have a huge table where records are present based on organizat…
1 replies
Hi All, I need to create a process that looks for a table in database with date(YYYYMM) appeneded t…
6 replies
I have 2 queries asselect id,sum(a)/count(id) as e from table1 group by id and another query as sel…
12 replies
declare type v_arr is varray(10) of varchar empy.ename%type x_arr v_arr=v_arr() begin x_arr.extend …
4 replies
hi i have a table with columns id,value if id is unique (only one time it exists in the table value…
17 replies
I have a table which contains data for 12 months. Now i want to delete the data for the month of Au…
5 replies
Hi all, I am trying to get a high precision difference of dates in SQL Server 2008 R2, and can't se…
36 replies
The sample data below details my issue!! I want to avoid using a cursor any way I can, but this is…
1 replies
Hi, I came across a situation today.I need to restore the database from A server to B server having…
1 replies
Viewing 15 topics - 5,206 through 5,220 (of 10,647 total)
You must be logged in to create new topics.