Topics
Started by
Posts
Last post
I have a table from which i need to calculate the following - get total percentage where col2 is ei…
2 replies
Sample code is below. What I want to do is list the top 2 records that have the same name for a giv…
10 replies
Can some one please show me how I would structure a SQL query that gives me the Percetage of Items …
3 replies
Hi All, When I am trying to make lots of Inserts into my database ... it takes lots of time to inse…
4 replies
I have the following update statement that when thru the table and update the field, as you can see…
3 replies
I've done 95% of my development in MySQL in the past, but I have to use SQL Server 2005 for the pro…
3 replies
Hi I am having difficulty using the Pivot function: I have some SQL which generates a summary table…
6 replies
USE [Production_Warehouse] GO CREATE PROCEDURE [dbo].[usp_Production_Warehouse_PopulateDate] AS DE…
3 replies
Hello everyone. I am hoping to get some assistance as I normally try to research the forums before…
4 replies
I need to not use a temp table in my query (see #TempTable in the code below) because I am going to…
21 replies
Here is part of a stored procedure that is creating a general ledger with Lawson data: CREATE TABLE…
1 replies
Hi.., How to load table using select into and refresh it daily at particular time
3 replies
Here is my proc code... INSERT INTO dbo.CLM_HDR ( [EDI_CLM_ID] ,[VEND_ID] ,[VEND_CLM_NBR] ,[RE…
5 replies
Hey all, Can't figure this one out ... I use logic like this quite frequently for "optional paramet…
13 replies
plz help me out in sorting the way .... create table #abc ( source varchar(100, date datetime, stat…
7 replies
Viewing 15 topics - 8,176 through 8,190 (of 12,230 total)
You must be logged in to create new topics.