Topics
Started by
Posts
Last post
I created 3 different views and I need a common column to join these 3 views. There is an AMOUNT co…
4 replies
I need help with SQL PIVOTExample SELECT Manufacturer, CarTypeFROM Vehicles Manufacture &nbs…
12 replies
Let's say, hypothetically, I have a table with three columns--LastName, FirstName, MiddleName and I…
17 replies
Hello,We have a lot of sql server unit tests which works like following:1. Begin tran2. Setup testd…
2 replies
I am struggling to finish a simple query and it seems that I will never succeed. It's about a NAV r…
2 replies
Back in the days of my Oracle database college courses, I always thought indexes were very simple: …
3 replies
Below stored procedure taking more time to complete the process.This procedure contains left join w…
13 replies
Hi guys, let me try to explain the problem. There is a hotel with rooms for 2, 3 …
14 replies
All,As per the requirement that I am working in which seems to be a pretty common scenario that we …
3 replies
This T-SQL works perfectly (and i AM aware of security implications of enabling xp_cmdshell, n…
7 replies
I'm struggling to delete a post here
2 replies
Let's say I have Table A and Table B.Table A can join onto Table B because both tables have a commo…
31 replies
Hi, CREATE TABLE #GetMax ( ID INT, CName VARCHAR(10), Value1 INT, Changeval INT, Value2 INT …
4 replies
I have an SQL query which uses a DateFrom and DateTo variable. This query later will go into a stor…
28 replies
Do the fields of both objects and/or select statements between which i use EXCEPT keyword hav…
6 replies
Viewing 15 topics - 1,891 through 1,905 (of 3,091 total)
You must be logged in to create new topics.