Topics
Started by
Posts
Last post
Here is my test data.. CREATE TABLE Table1 ( ID INT, P#INT, LNAME VARCHAR(50), FNAME VARCHAR(5…
3 replies
Hi Everyone I am having an syntax issues I am not able to work out. I have a value in a column '0…
12 replies
Hi Team, We are designing a Staging layer to handle incremental load. I want to start with a simple…
10 replies
I have a small project to be done in which I need to fetch the pdf file from a my system and save i…
9 replies
Hi There, Following is the sample data , DECLARE @maxval int, @minval int select @maxval=201301,@m…
3 replies
Please explain following querys, how it works in back end and which one is preferable? Query 1: s…
2 replies
I am creating a SSRS report with geographic world map. I am able to to download few shape files and…
3 replies
Anyone can help me to come out a query for below ? The objective is to transform entity as shown in…
1 replies
I have an issue with a store procedure that takes roughly 25 minutes to complete. the table that th…
11 replies
We have a large OLAP database, about 2.5 TB spread out over 3 data files on three different drives,…
5 replies
Hello everyone, So for years I was using the int identity(1,1) primary_key for all the tables I cre…
3 replies
Hi There, I need to do some clean up activities in my databases... So i intended to drop unwanted …
2 replies
Hi all, I have tables with structures like this: /****** Object: Table [dbo].[ServiceCallJobPhoto…
7 replies
In a stored procedure I dynamically create a temp table by selecting the name of Applications from …
4 replies
I need a query to get the first value greater than a specific threshold value LoadTemp1 LoadTemp2 L…
11 replies
Viewing 15 topics - 4,411 through 4,425 (of 4,984 total)
You must be logged in to create new topics.