Topics
Started by
Posts
Last post
Hi, I am confused. Pls answer my question. should I use IN or LEFT OUTER JOIN in my sql query ? and…
1 replies
My server is case sensitive (CS) My DataBase is no (CI) The smss query editor works fine for t…
1 replies
i have attached an image with this thread. my application is using jdbc drives. same operation in o…
3 replies
I have a huge DB and a view that pulls records from multiple tables, some as big as 2M records. I …
19 replies
Hello - I am trying to create a script which could give me all the dates from @StartDate to @EndDat…
5 replies
Hi guys, I have a procedure which can be invoked through other procedure and I can run it outside. …
5 replies
Hi, To understand my problem, I have created two tables with their sample data for you guys: CREATE…
1 replies
I've a dimension table dim_Quarter as below. Now I need to insert data into this table starting fro…
3 replies
Hi, I have a beginning Year and a End year and i have to compute/create a string based on the given…
3 replies
How do you get the most recent record ie it would be 150 for acct 1 and 75 for acct 2. CREATE TABLE…
6 replies
I have been asked to set up an archiving solution that automatically generates a series of SQL stat…
4 replies
Hi, i'm having problems with writing a pretty basic query: I have a table called #mydates, i want …
11 replies
Hi all. If I have a table such as : Queue - queue_id Int (PK) - Action Char(15) - Info varchar(max)…
4 replies
I have the following tables Product --stored for productid ProductRelation -- storing linked produc…
7 replies
Hi, I want to find out a way to extract the different or non-matching rows from two similar tables-…
12 replies
Viewing 15 topics - 4,366 through 4,380 (of 10,636 total)
You must be logged in to create new topics.