Topics
Started by
Posts
Last post
Originally I had this query: Original value for starttime is 1800001 (Clarion time figures based up…
15 replies
Hello, I have two tables -- Table A in Server A of Database A -- Table B in Server B of Database B…
6 replies
Hi Team, I have a 2 tables with exactly same structure ( i.e. same columns and datatypes ) but dif…
3 replies
I'm trying to use plan guides to help some bad ORM queries ( hinting option(recompile ). Now I see…
5 replies
hi, This is a classic scenario of an SP wrapped in a sqlAgent job and despite SP failing to do its…
5 replies
I have a table of several millions of records for flight ticket. One of the indices is Flight Ticke…
6 replies
In the process of upgrading the front end of my DB and apparently, it doesn't like BigInt data type…
6 replies
Please can you help me in turning the following script into a Stored Procedure, I have just tried d…
3 replies
Hi Experts consider the below scripts, CREATE TABLE #TEMP(Source NVARCHAR(100),Target nvarchar(100…
4 replies
Hello, I have a query: SELECT "data" FROM t1... JOIN t2... JOIN t3... LEFT JOIN t4... JOIN t5... LE…
4 replies
Hi, I need a search routine for a carrier company to search for following parameters (you can mix t…
4 replies
I have a SQL 2012 R2 standard runtime edition server non VM using Virtual Drives for all dat and lo…
3 replies
Hi all, A colleague of mine has just asked me if I can explain why a SQL statement he's written tha…
10 replies
-- Source Create table staging (id int, name varchar(50), empid int, compan…
3 replies
Hi, We have tables that have primary keys that are not the clustered index. The primary key still …
9 replies
Viewing 15 topics - 1,501 through 1,515 (of 4,984 total)
You must be logged in to create new topics.