Topics
Started by
Posts
Last post
I am wondering if I can show the Excel window when the SQL server agent job runs. The SSIS package …
2 replies
Hi There, I'm new to SQL development.. please assist me something that every developer must know &#…
5 replies
Hello, I need to auto increment an alphanumeric field in a table. The process is as follows: 1. Fir…
11 replies
Hello, Attached text file contains a script I started putting together this evening. The basic prem…
1 replies
Experts, I have an sql query am using which takes over 10minutes to draw data. it is divided into…
21 replies
CREATE TABLE GROUPS( CONTRACT VARCHAR(5), PACKAGE VARCHAR(3), GROUPNBR VARCHAR(5), SUBGROUP VARCHAR…
2 replies
This is the file name: aSNAP_Data_20140929_P-2014-09-29_07.01.34.dat I need to give this name to th…
4 replies
Here is the data I am working with: CREATE TABLE CUSTOMERS( CUSTOMER VARCHAR(11), CONTRACT VARCHAR(…
1 replies
Hi, I need help with an update query given below, CREATE TABLE #Tracking ( ID INT IDENTITY(1,1),COr…
2 replies
Hi There, I'm dealing with huge database. So I thought to go with the data compression because it w…
3 replies
Hi all, I'm using SQL Server 2012 and I need to run a query against my database that will output th…
15 replies
Hi all, I have a stored procedure and in that I will be calling a stored procedure. Now, based on t…
3 replies
We have a hierarchical table of some 2-3k of rows that grows slowly at only 3-5 rows a month, and i…
5 replies
Hi There, Index is double edged sword. So we have to be very careful while creating index. Pls sugg…
1 replies
I have a query i have been optimizing. Now runs in about 15 minutes but was wondering if there is a…
11 replies
Viewing 15 topics - 3,781 through 3,795 (of 4,984 total)
You must be logged in to create new topics.