Topics
Started by
Posts
Last post
I have scoured high & low for this solution, so in desperation I am posting here. I have a tab…
11 replies
Hi I would like to know if it's possible to pass NULL value to the database. I want to update a col…
5 replies
I have two tables as below create table #table1 (id int,name varchar(10),[sep-12] varchar(10),[oct-…
5 replies
table has 500 million rows. There are 21 million rows that have one ore more fully duplicate ones, …
6 replies
Hi, I have a two table. One Table having Country code and country name details. Another table havin…
3 replies
Hi all, Can someone tell me what are the pros and cons for choosing a character CHAR(3) data type f…
14 replies
I have two tables; CUSTOMER (customer_id NUMBER, customer_name VARCHAR2(100), recently_purchased VA…
3 replies
Hi, I'm restoring to a remote DB for our DR testing. After the restore I need to create come user m…
2 replies
Hi I am trying to think of the best way to calculate a count of 'no' values vs the count of total v…
2 replies
Hi, I am relatively new to SQL programming and have the following issue: I want to insert a number …
3 replies
here is a sample table: Create table #TableA (ID INT , [1] DECIMAL(6,5…
3 replies
Afternoon all, I need to be able to test columns in a table to see if they contain the correct data…
6 replies
I need my column called 'nameInternal' to derive from another column called 'nameFormal'. If the la…
5 replies
Hi, ;WITH cte2 AS ( SELECT a.personkey as APK, --b.personkey BPK, a.BaseLocationKe…
1 replies
I'm loading a bunch of csv-type files via bcp using an xml format file, and triggering the load fro…
3 replies
Viewing 15 topics - 2,461 through 2,475 (of 10,635 total)
You must be logged in to create new topics.