Topics
Started by
Posts
Last post
I am designing a database for a web app which needs to store user profiles. However I need to be a…
2 replies
I need to add user data types to the sys.types table in my database by getting all the user datatyp…
2 replies
I have a table of around 200k records – this table holds groups of duplicate records. I have used r…
2 replies
We are now int the process of checking our environment in Sql server 2008. The server for the 2008 …
13 replies
Here's my situation: I have a column in a table which is defined as SQL_Variant which seems to cont…
1 replies
Hi Here is my sample data. CREATE TABLE #WaterDays ( MeterCode VARCHAR (25) NULL …
8 replies
I need to find the 4 last reports from a company and ad them to 4 different colums of my "denormali…
2 replies
I'm working on a problem trying to update field payrtamt in following table: SET ANSI_NULLS OFF GO …
5 replies
Hello, We had one of our DBAs go to a SQL Server Admin class. The instructor, well known SQL Serve…
8 replies
How to create 3 seperate rows for comma seperate values For example - DECLARE @T VARCHAR(10) SET @T…
16 replies
Hi, I have a table with columns proj_id char(5), tenant_id char(6), lease_id char(8), Sales_yr num…
4 replies
Is there a way to see the contents of a temp table while in the middle of SSMS debugging mode?
1 replies
Hi All, I wonder if anyone can help shed some light on an issue i've run into. I'm attempting to ca…
4 replies
How to select this ID -- 1 2 3 4 5 6 and return it as : id1 id2 --- --- 1 2 3 …
10 replies
Hi guys, i have a transaction table 🙂 I need to find a sale frequency for each customer. In the end…
12 replies
Viewing 15 topics - 9,721 through 9,735 (of 10,635 total)
You must be logged in to create new topics.