Topics
Started by
Posts
Last post
Hi. I wanted to create table describing hierarchy between various groups in our system. The table: …
4 replies
By: nimdil
I have a simple select statement that looked like this select top 1000 convert(varchar(30), conver…
14 replies
Hello This is my store procedure create proc usp_Fact @entFact smallint as declare @tipFact as var…
8 replies
I know cursors are generally not recommended but in this case it's needed. The issue I have is tha…
7 replies
By: Apurva
Hi, 😛 I want to know the query to get all the temporary local tables created by any SPID Eg. My …
2 replies
I have a [dbo].[DimOrders] table which has a OrderID column(autoID), trying to insert and update th…
3 replies
Ok....my syntax is below. I am running a merge statement that merges incomming data into a dimensio…
9 replies
By: villersk
Hello, I need some help please. I have 2 temp tables like so CREATE TABLE #fSales ( …
6 replies
An SQL puzzle that's tripped me up. I wound up doing it brute force. Simple Many to Many between Cu…
14 replies
Hello I'm trying to read from a table that contains an XML column: DECLARE @xmlDoc XML, @handle INT…
1 replies
Good Day Gentlemen, I have 4 date variables declared (BeginDate, LastBeginDate, ConcludeDate, LastC…
5 replies
Hi guys and gals, I have an import job on my database server I'm having a spot of bother with. At t…
1 replies
Good Day Guys, I have two tables that look something like the ddl info below CREATE TABLE #Merch_Ac…
4 replies
I have a table that I have created a non-clustered index with a filter. If I run Select * from ta…
9 replies
Can someone tell me why this script doesn't work? CREATE TABLE #temp (test INT) INSERT INTO #temp …
3 replies
By: matt6288
Viewing 15 topics - 10,516 through 10,530 (of 10,647 total)
You must be logged in to create new topics.