Topics
Started by
Posts
Last post
Hi all , I have a user in a database who has db_owner rights . I want to remove this db_owner right…
2 replies
Here is the challenge. We provide custom reports/scripts for 100+ clients across the US where they …
6 replies
Please can you see my below code for some reason it does not work I want a % of column [NumberAffec…
2 replies
DELETE FROM loadprogress.[PUB].[TC-CARD] FROM loadprogress.[PUB].[TC-CARD] JOIN #TCCard_Temp t…
10 replies
A friend asked me how to do this but do not know how. It is actually in MS-Access but I know you gu…
3 replies
Posted - 02/24/2012 : 05:30:42 I have 2 tables Loads and Balance CREATE TABLE [dbo].[Loads]( [ID] …
11 replies
Hi there,I have a DB which has 10,000,00 rows in it. when I use select Statement in my DB it takes …
7 replies
I’d like to create several views using the command below, but would like a loop that goes through a…
2 replies
Dear SQL experts, I need some help to solve the following problem: I've created a table made by an …
12 replies
I am creating a query with case statement inside an in clause but I dont know if it is possible to …
1 replies
Hi, I wanted to compress my XML data in the database. As I receive loads if data and create report …
2 replies
Hi, I have a rather large table (2-3 mill rows) and im creating a view to put on top of this table.…
20 replies
Hi, im wondering if it's possible to replace certain words in a string... like numbers or email add…
1 replies
I have one query (say qry1) which return a result set as follows symbol bit value d…
6 replies
Hi All, I guess it is row processing logic I'm after, where the returned value is calculated on the…
2 replies
Viewing 15 topics - 6,496 through 6,510 (of 10,635 total)
You must be logged in to create new topics.