Topics
Started by
Posts
Last post
I have the following CASE statement: ,CASE WHEN SUM(v.PurchaseAmount) /15000 <=0 THEN 0 ELSE SU…
26 replies
I am wondering if a DDL trigger can be written to grant db_datareader access to a given login each …
3 replies
Hello every one well here is my problem.....I have a SQL statement going like this,and the result s…
3 replies
I'm am attempting to execute one stored procedure from inside another stored procedure and use the …
1 replies
Hi all, I've got a Sproc I'd like to alter so that it will accept input parameters, at the moment i…
4 replies
Hi, I have 3 statements below which I'm sure should really be one statement but I can't see how to …
6 replies
Hi, I have a problem of calculating an index. My Table is something like this: SID as int 'PrimaryK…
3 replies
I know how to create a structure of a table from another table without copying data but how do you …
9 replies
hi, plz check this query and find out y its not running .where is the fault select 'my details'=ad…
5 replies
hie all, I need a select query for Sql 2000 and also for sql 2005 find script : Create Table #Te…
1 replies
HI, Can I make a temprary table by using union operator. This is my query. (SELECT SUBSCRIBER_PHONE…
1 replies
Hello friends , I have table (MoneyTrans) with following structure [Id] [bigint] NOT NULL, [Tra…
9 replies
This piece of script says incorrect syntax near '=' and I am stumped at why. Thank you in advance f…
2 replies
I have 2 tables. master & detail in master i have columns: Client, Name in detail i have colum…
5 replies
Hi everybody, I want create a job and I want to purchase a select a few complex with subselect. How…
5 replies
Viewing 15 topics - 10,516 through 10,530 (of 12,234 total)
You must be logged in to create new topics.