Topics
Started by
Posts
Last post
Hi, I am trying to work with data from the ProjectServer_Reporting database, which is a part of the…
6 replies
Hi people, I'm tunning a database and i've stumbled by some hierarchy queries, on the good old for…
32 replies
hi, i have 1 table which has millions of rows, i am doing select * from tablename and select count(…
20 replies
This procedure working fine in SSMS with multiple execution. Problem is application side(c#), first…
16 replies
Hi All Consider the following 2 tables create table T1 (Col1 int, Col2 int) go create table T2 (Col…
3 replies
Hi, Messing around withn SQL queries on a Sunday, so I have another question (posted my fist one th…
5 replies
I have 2 tables that are identical. I wish to copy some records from one table to the other with th…
10 replies
I have 2 tables in my database and am RIGHT JOINING the tables and it is acting like an inner join …
22 replies
Hi all - I'm trying to run an update query based on the last time the update query was run. Ex: I r…
5 replies
I have a table as: CREATE TABLE tbItems ( [ID] [int] IDENTITY(1,1) NOT NULL, [itemno] [varchar](1…
17 replies
I need to insert empty row in a temp table within a stored procedure. The data types are varchar, v…
14 replies
Hello all. Hopefully someone will be able to help me out with this query. The below query takes 42…
36 replies
hello guys is there any script to find duplicate unique constraints ,there are more than one uniqu…
6 replies
Hai friends , i ve one doubt in subqueries in oracle select col1,col2 from @tab1 where(col2,col…
5 replies
I have a table that contains permissions based on a group id. How would I go about building a scrip…
9 replies
Viewing 15 topics - 5,161 through 5,175 (of 10,640 total)
You must be logged in to create new topics.