dbTalk Databases Forums  

Sponsored Links


microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming


Discuss in the microsoft.public.sqlserver.programming forum.



Post New Thread
Threads in Forum : microsoft.public.sqlserver.programming Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hello, I have a database named as 'Cellar duty'. Means, a database name with a space in between two words. When I run sp_msforeachdb in the...
Abba
08-07-2009 10:39 AM
--CELKO-- Go to last post
5 96
I am using SQL Server 2005. I am selecting numbers from a column based on a numtype and another column numtypeII. If the numtype in A, D...
gh
08-07-2009 10:30 AM
--CELKO-- Go to last post
2 85
I have a table that includes 2 fields, Month and IsLastOccuring, like this : Month IsLastOccuring 1 No 2 No 3 No 4 No 5 ...
Mike P
08-07-2009 10:03 AM
--CELKO-- Go to last post
3 98
I have a sql table which contain three columns: OrderNo, Code, and Modifier. I need to to exclude orderNo which contain code A with Modifier 1, code...
qjlee
08-07-2009 09:35 AM
Plamen Ratchev Go to last post
1 115
Hi, I basically have the following code select a.x, a.y, b.* from A as a left join B as b on a.x= b.x order by a.x, a.y
Michael
08-07-2009 01:29 AM
Carlos Sacristan Go to last post
9 101
Hi, I am running SQL Server 2008 Enterprise (64-Bit), on Windows 2008 Standard Server (64-Bit). Lastest service packs. The hardware isn't much,...
Russell Mangel
08-06-2009 10:57 PM
Jeremy A. Holovacs Go to last post
4 106
Hello, I am creating a few Stored Procedures after some tables and I always get the following errors: Incorrect syntax near the keyword...
shapper
08-06-2009 10:47 PM
Jeremy A. Holovacs Go to last post
7 101
Hi, I have three tables A,B,C that I am joining in 1 Query. Table A (Province Names) having matching record in other Tables B and C (B & C always...
M.K
08-06-2009 10:18 PM
M.K Go to last post
4 105
Hi, After executing a select command I execute statements below: Select @@RowCount if @@RowCount = 0 Select 'ONE'
Kursat
08-06-2009 09:25 PM
Jeremy A. Holovacs Go to last post
3 96
Hi I have the following Table X Y Z 1 2 3 1 3 4 1 4 5 1 5 7 1 6 9
Michael
08-06-2009 07:45 PM
Michael Go to last post
4 87
Hello all, I've ran across into a wierd dielma. I have a file that I sent over to another dept that gets a CSV file from our SQL server on a monthly...
altor77
08-06-2009 05:23 PM
altor77 via SQLMonster.com Go to last post
5 104
I have seen tons of things out there telling oyu to rollback a transaction in the catch block of a trigger, capture the error information and write...
John Couch
08-06-2009 05:21 PM
Erland Sommarskog Go to last post
12 137
Is it possible to change the server you are connected to through T-SQL? If so, how? I want to run queries against specific servers so that it will...
Rubens
08-06-2009 01:43 PM
Rubens Go to last post
9 110
For Error: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. Suggestion1 from the...
AAaron123
08-06-2009 12:58 PM
AAaron123 Go to last post
5 85
Why do you change the direction of the topic? What Tony was saying was that not a lot has been taken away. If I wrote code in 6.5, how does...
Jason R. Soby
08-06-2009 09:19 AM
Aaron Bertrand [SQL Server MVP] Go to last post
39 275
Hello, I came across a useful script, in http://www.mssqltips.com/tip.asp?tip=1510, that determines free space on data file level. I would like to...
Abba
08-06-2009 09:07 AM
Abba Go to last post
5 88
Hi, I have an empty table which is as follows: plant machine plan_date plan_hrs plant and machine are varchar plan_date is datetime and plan_hrs is...
Jack
08-06-2009 08:47 AM
Jack Go to last post
2 114
Hello, Is there any setting whereby the database connection would disconnect itself automatically after a script has been executed? For example, I...
Abba
08-06-2009 01:52 AM
Abba Go to last post
8 133
Hi, I have a table as follows. X 5 6 9 12
Michael
08-05-2009 08:18 PM
--CELKO-- Go to last post
5 135
Hi, I'm implementing the auto suggest feature in my ASP.NET application that makes suggestions for products as the user types the product name....
Sam
08-05-2009 05:12 PM
Jeremy A. Holovacs Go to last post
2 122
Hello, I got a problem with the Batch Separator: I wrote the following code: USE DBTEST GO CREATE Type .....
Rick
08-05-2009 04:52 PM
Erland Sommarskog Go to last post
4 91
We are starting to get a lot of deadlocking on one of our (2000) servers in the early am hours. We are going to the traceon's to hopefully capture...
CLM
08-05-2009 03:00 PM
CLM Go to last post
5 119
Hello, I am creating the following tables: create table dbo.Groups ( Id uniqueidentifier not null rowguidcol constraint PK_Group primary key...
shapper
08-05-2009 01:53 PM
Aaron Bertrand [SQL Server MVP] Go to last post
6 105
I have a job that runs a dts package in which executes Stored Procedures. I am trying to optimize some of the SPs and want to know if I can put in...
Chris
08-05-2009 10:58 AM
Tibor Karaszi Go to last post
3 110
I am making a Testimonials application. The database requirements say that a row must be randomly selected. On top of this, all of the rows from...
Andy B.
08-05-2009 10:01 AM
Plamen Ratchev Go to last post
3 80
I have data as follows field0 Fields1 A 10 B 20 C 30 Now I want to...
Navin
08-05-2009 09:25 AM
Uri Dimant Go to last post
1 119
Hi, I have a table A X Y 1 2 1 3 1 5 a table B
Michael
08-05-2009 09:21 AM
Plamen Ratchev Go to last post
4 92
Hello! I need to insert 4MM records into a table that contains 7MM records (same table structure), with a logic of ID = Id+1 on every new...
Test Test
08-05-2009 09:11 AM
Test Test Go to last post
5 100
Postgres windowing functions http://www.osdbzine.net/osdbzine_issue1.pdf Postgres window...
steve dassin
08-05-2009 08:45 AM
Aaron Bertrand [SQL Server MVP] Go to last post
3 85
Hi CREATE TABLE TableA (x INT PRIMARY KEY); INSERT INTO TableA (x) SELECT number FROM master..spt_values WHERE type = 'P' AND number BETWEEN 1 AND...
Michael
08-05-2009 08:19 AM
Plamen Ratchev Go to last post
8 109
Before I attempt it I was wondering if I can use a DDL trigger to deny altering a stored procedure. Would a test on the username and the RETURN...
Chris
08-05-2009 08:02 AM
Chris Go to last post
3 86
Hi All how Can i Change the column Length with ALTER TABLE Tankes
taha105
08-05-2009 03:51 AM
taha105 Go to last post
2 98
Hi, create table tmp1 ( a int, b int ) insert into tmp1 (a, b) values (2, 10)
Michael
08-05-2009 02:29 AM
Erland Sommarskog Go to last post
5 88
Hi, When I have the Create table in a Stored proc, the default user is the userid of the person logged in but when I go to drop the table, it...
Ellie
08-05-2009 02:23 AM
Erland Sommarskog Go to last post
5 105
Hi, I have a table like the following: X Y 1 1 1 7 1 5 1 9 2 2
Michael
08-04-2009 08:24 PM
Linchi Shea Go to last post
1 96
I have a column named 'img' for images, and i need to assign the names of the images with the names of the associated entry # 'eno' and concatenate...
.Net Sports
08-04-2009 06:47 PM
.Net Sports Go to last post
6 88
I have a SQL Server 2005 database that I saved in XML format in a text field. I would like a SQL Server function or script to determine if the value...
Joe K.
08-04-2009 05:42 PM
Erland Sommarskog Go to last post
3 99
Hello, I have the following: create table dbo.Roles ( Id uniqueidentifier rowguidcol not null constraint DF_Role_Id default (newid()), ...
shapper
08-04-2009 05:14 PM
Aaron Bertrand [SQL Server MVP] Go to last post
4 78
Here's the task: 1. A table has components 2. Each component has layers Sample: COKEY ..fields.. CHKEY | SOL_K1 | SOL_BD1 | SOL_...n row1 ...
Marilyn
08-04-2009 05:12 PM
Marilyn Go to last post
4 103
Hello, I have 3 tables: Posts, Tags and PostsTags. - When a Post is deleted I need to: Delete all PostsTags related to it. No record in Tags should...
shapper
08-04-2009 04:58 PM
Hugo Kornelis Go to last post
1 90
How to list datetime data for only date format, like mm/dd/yyyy? I knew how to use convert to make it working but it will not date type. It become...
aspfun via SQLMonster.com
08-04-2009 04:39 PM
Aaron Bertrand [SQL Server MVP] Go to last post
1 97
I have a column in a SQL table called AmountCharged, which contains numbers with decimal. What function I can use so that I could retrieve the...
qjlee
08-04-2009 04:24 PM
Jeremy A. Holovacs Go to last post
4 96
(First, sorry for the cross post...) Hi, all and thanks in advance for the assistance! In sql server 2000 i'm working with my first trigger and it...
MyD0j0
08-04-2009 03:19 PM
EJO Go to last post
6 124
I have a table that has multiple rows for each transactions and I need to select data from the second row based on criteria from the first row. Here...
Rocky20
08-04-2009 03:10 PM
Plamen Ratchev Go to last post
2 97
I imported a whole bunch of name and address. How can I write a select statement that will only show people with the same Lastname so I can see...
pvong
08-04-2009 03:05 PM
Plamen Ratchev Go to last post
4 96
Hello, Please, someone point me to a most excellent example of an aging of accounts receiveable. Thanking you in advance. wj
jazman58
08-04-2009 12:41 PM
Bob McClellan Go to last post
1 96
Hi, From a table I want to find out aggregated sales for each State every 5 minutes. i.e., for example something like below Minutes StateId Amount...
SqlBeginner
08-04-2009 12:40 PM
TheSQLGuru Go to last post
1 106
hello there i've just installed Failover clustering on servers. after that Insert data to table works very slow. What is the difference in...
Roy Goldhammer
08-04-2009 12:38 PM
TheSQLGuru Go to last post
3 111
I want to have one main server which holds all the data which is connected to two other servers which have the same data replicated as long as they...
Rajesh
08-04-2009 12:34 PM
TheSQLGuru Go to last post
4 94
Hello, I am running my SQL to create some tables and I get a few errors but not the code lines where they are. I am working with VS 2008 and have a...
shapper
08-04-2009 12:32 PM
TheSQLGuru Go to last post
5 117
Post New Thread

Display Options
Showing threads 3251 to 3300 of 69242
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.