Topics
Started by
Posts
Last post
Good morning, does anyone know of a tool/method for formatting a large amount of date in prep for a…
3 replies
hi i have a table Product like this CustomerId,Product,quantity …
3 replies
What is driving the question is that I often write or troubleshoot stored procs that are complex or…
7 replies
hey all, there is a table: create table dbo.mytable ( colA int identity(1,1), colB varchar(50), co…
7 replies
On a SQL 2008R2 / SQL 2008 / SQL 2005 (or for that matter almost any version)instance, can someone …
11 replies
Hello friends, I am trying to create one database and tables through DDL, I’ve everything in one wi…
10 replies
I know I could query the system tables to return all the columns in a table, but what I want to do …
15 replies
Hi All, i have this cursor: DECLARE @cod INT DECLARE @getlista CURSOR SET @getlista = CURSOR…
7 replies
I have 2 types of transactions that possibly cancel each other out. It is possible to have transact…
22 replies
I have the following SQL statement: SELECT m.[property_id], m.[Address], m.[City], m.[Zip], m.Count…
4 replies
Is there any query to get the tables that are to be optimizated (defrag, reindex, update stats). Th…
3 replies
Hi all, I have a table with ten thousands of rows that looks something like this: CREATE TABLE #te…
3 replies
I am trying to show the total number of invoices per customer, and the total purchase amounts by cu…
11 replies
I have the following data in a query: CREATE TABLE EmpHours ( EMP_ID INT NULL, EMP_DATE_WORKED VARC…
8 replies
I have an employee table where in many instances the same ssn is listed for the more than one emplo…
6 replies
Viewing 15 topics - 6,706 through 6,720 (of 10,647 total)
You must be logged in to create new topics.