Topics
Started by
Posts
Last post
Hi guys, I have a stored procedure which contains a cursor to loop through a queue (The queue is ju…
9 replies
I'm trying to find duplicate records, so basically I wanted to do a select distinct * from myTable …
3 replies
Hi, I have two tables with below structure: Table A: ID, FName, Age, City, Date Table B: id, Lname,…
8 replies
Hi please help me, Is index view is save into the database. Thanks Prithvi
2 replies
hi can anyone tell me how i should do it. normal way of opening the database is use database_name s…
1 replies
I have a challenge that I have not been able to solve (without using a cursor). I have products th…
14 replies
hi all, I need to join 4 tables 3 are in one database and the other table is in other database, Tab…
13 replies
Hi, I have a table with below structure: COLA B C D E int int int datetime varchar I want to …
6 replies
Many thanks in advance?
5 replies
Hi, ----–Queries taking longest elapsed time: SELECT TOP 50 qs.total_elapsed_time / qs.execution_co…
6 replies
Does anyone know of a tool that can do more structural and syntactic checking on T-SQL code than Ct…
2 replies
hello, i have a data to be processed in t-sql. The data looks like below: ordernumber session_time …
43 replies
Recently i migrated from SQL Server 2005 to SQL Server 2008. At one place our code was giving error…
12 replies
Sample here populates a table for all of August 2011, incremented in 30 minute intervals: declare …
2 replies
Hi, In Oracle, If you do an update, delete and insert, then we can use COMMIT to commit the transac…
12 replies
Viewing 15 topics - 7,591 through 7,605 (of 10,647 total)
You must be logged in to create new topics.