Topics
Started by
Posts
Last post
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
Hi, I have often been doubtful on few things that I notice in my execution plan. Let's say that my …
5 replies
Hi all, I have a task which required me to sum value of all children level from bottom to top as t…
11 replies
I am running the following query select t.name as tablename, c.name as columnname from sys.table t …
6 replies
I think what I need to do might a little more complicated than my subject title, but in essence it'…
3 replies
Hi I have been given a new system to work on and the dates are held in three seperate columns day…
14 replies
I am currently working on a transaction table that has an IDENTITY column of type INT, which also h…
4 replies
Hi The bulk insert failing for the fieldterminator 'p' and i am getting the following error messag…
1 replies
Hi All, I have requirement to get old executed queries from sql server for 10, 14, or 30 days. I g…
1 replies
Hi, I am trying to join about 7 tables at the minute. Most of the joins work perfectly but I am tr…
8 replies
Viewing 15 topics - 5,176 through 5,190 (of 10,647 total)
You must be logged in to create new topics.