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 need some advice here... I am wanting to make a website that pulls data out of a database and compiles charts/ graphs. I do not want to use...
08-10-2009 09:06 AM
TheSQLGuru Go to last post
7 109
I create a full - replication between two SQL servers and set the time flame is 1 mins to run the replication Now, i found that some record cannot...
08-10-2009 09:01 AM
TheSQLGuru Go to last post
1 95
I 've been battling: Cannot open user default database. Login failed. When I use SQL 2005 Express. The same code (new connection string) works OK...
08-10-2009 07:41 AM
AAaron123 Go to last post
13 154
Hello, I have three tables: Users, Profiles and Professors. A User contains only one Profile. And a Profile might contain one or none...
08-10-2009 03:49 AM
Erland Sommarskog Go to last post
4 100
Hi SQL Server 2000. I have a stored procedure "Proc1" which includes quite a bit of logic, and ultimately does a Select to return 10 fields. I have...
Barry Flynn
08-10-2009 03:11 AM
Barry Flynn Go to last post
6 109
I found this procedure on the internet and choose to share it here. It ll locate any text string inside each procedure or scalar function. (you can...
André Freitas
08-09-2009 08:17 PM
Dan Guzman Go to last post
1 99
Hi All I have an existing CLR stored procedure on Sql Server Express 2005 which has 4 parameters I need to alter the procedure to add 2 more...
08-08-2009 08:41 PM
Steve Go to last post
2 91
Hi, I have a set of tables that I will be dropping some FKs and NC indexes then loading some data and then recreating the table objects. Is there a...
08-08-2009 11:21 AM
Sualeh Fatehi Go to last post
3 104
I'm not actually sure where the problem lies, so please bear with me. I'm using MS LogParser V2.2, to read events from an event log, and I want...
08-08-2009 10:03 AM
Jeremy A. Holovacs Go to last post
17 184
I've got a DB where some tables have columns that require localization and I'm trying to find what's the best way to handle this. For instance, in my...
08-08-2009 07:32 AM
Mike Go to last post
5 104
I have a query which is inserting records from another table which holds imports from another database. Sometimes I get errors on primary...
Rich Lawson
08-07-2009 05:31 PM
Rich Lawson Go to last post
6 89
Hello, I need to a have a column in query that is a string but looks like a number, The value would be something like "200,000 caps", where the...
08-07-2009 04:49 PM
Aaron Bertrand [SQL Server MVP] Go to last post
1 92
Hi all - Just trying to understand why this might be so slow. Takes 30 secs to run (returning 165 rows). Takes < 1 sec to run if I remove...
08-07-2009 03:03 PM
shawn@adova.com Go to last post
4 91
I'm trying to generate reports in Excel off a series of csv files generated from ad hoc queries in SQL Web Admin query analyzer. I need to get the...
.Net Sports
08-07-2009 12:10 PM
Aaron Bertrand [SQL Server MVP] Go to last post
1 100
Ok. So this is where I am at: DECLARE @GenNum INT SET @GenNum = (SELECT TOP 1 fldNumber from tblTable WHERE fldInUse IS NULL ORDER BY...
08-07-2009 11:09 AM
--CELKO-- Go to last post
10 145
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...
08-07-2009 10:39 AM
--CELKO-- Go to last post
5 105
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...
08-07-2009 10:30 AM
--CELKO-- Go to last post
2 93
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 107
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...
08-07-2009 09:35 AM
Plamen Ratchev Go to last post
1 124
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
08-07-2009 01:29 AM
Carlos Sacristan Go to last post
9 122
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 130
Hello, I am creating a few Stored Procedures after some tables and I always get the following errors: Incorrect syntax near the keyword...
08-06-2009 10:47 PM
Jeremy A. Holovacs Go to last post
7 110
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...
08-06-2009 10:18 PM
M.K Go to last post
4 116
Hi, After executing a select command I execute statements below: Select @@RowCount if @@RowCount = 0 Select 'ONE'
08-06-2009 09:25 PM
Jeremy A. Holovacs Go to last post
3 105
Hi I have the following Table X Y Z 1 2 3 1 3 4 1 4 5 1 5 7 1 6 9
08-06-2009 07:45 PM
Michael Go to last post
4 96
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...
08-06-2009 05:23 PM
altor77 via SQLMonster.com Go to last post
5 113
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 151
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...
08-06-2009 01:43 PM
Rubens Go to last post
9 119
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...
08-06-2009 12:58 PM
AAaron123 Go to last post
5 93
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 302
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...
08-06-2009 09:07 AM
Abba Go to last post
5 96
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...
08-06-2009 08:47 AM
Jack Go to last post
2 125
Hello, Is there any setting whereby the database connection would disconnect itself automatically after a script has been executed? For example, I...
08-06-2009 01:52 AM
Abba Go to last post
8 144
Hi, I have a table as follows. X 5 6 9 12
08-05-2009 08:18 PM
--CELKO-- Go to last post
5 149
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....
08-05-2009 05:12 PM
Jeremy A. Holovacs Go to last post
2 132
Hello, I got a problem with the Batch Separator: I wrote the following code: USE DBTEST GO CREATE Type .....
08-05-2009 04:52 PM
Erland Sommarskog Go to last post
4 102
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...
08-05-2009 03:00 PM
CLM Go to last post
5 129
Hello, I am creating the following tables: create table dbo.Groups ( Id uniqueidentifier not null rowguidcol constraint PK_Group primary key...
08-05-2009 01:53 PM
Aaron Bertrand [SQL Server MVP] Go to last post
6 125
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...
08-05-2009 10:58 AM
Tibor Karaszi Go to last post
3 117
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 91
I have data as follows field0 Fields1 A 10 B 20 C 30 Now I want to...
08-05-2009 09:25 AM
Uri Dimant Go to last post
1 130
Hi, I have a table A X Y 1 2 1 3 1 5 a table B
08-05-2009 09:21 AM
Plamen Ratchev Go to last post
4 101
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 111
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 91
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...
08-05-2009 08:19 AM
Plamen Ratchev Go to last post
8 120
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...
08-05-2009 08:02 AM
Chris Go to last post
3 92
Hi All how Can i Change the column Length with ALTER TABLE Tankes
08-05-2009 03:51 AM
taha105 Go to last post
2 107
Hi, create table tmp1 ( a int, b int ) insert into tmp1 (a, b) values (2, 10)
08-05-2009 02:29 AM
Erland Sommarskog Go to last post
5 97
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...
08-05-2009 02:23 AM
Erland Sommarskog Go to last post
5 117
Hi, I have a table like the following: X Y 1 1 1 7 1 5 1 9 2 2
08-04-2009 08:24 PM
Linchi Shea Go to last post
1 104
Post New Thread

Display Options
Showing threads 3251 to 3300 of 69256
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 - 2015, Jelsoft Enterprises Ltd.