Topics
Started by
Posts
Last post
Good morning/afternoon everyone I'm new to the community, and pretty new to MS SQL not having used …
7 replies
Hi, can any one expalin me what's the difference between "Subscriptions" and "Notificaitons" in gen…
1 replies
Howdy folks, I just realized I'm disappointed with sql server 2008's trigger capabilities because I…
11 replies
Hi. I wanted to create table describing hierarchy between various groups in our system. The table: …
4 replies
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
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
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
Viewing 15 topics - 10,501 through 10,515 (of 10,635 total)
You must be logged in to create new topics.