Forum Replies Created
Viewing 15 posts - 11,551 through 11,565 (of 13,460 total)
-
RE: Not getting Topic Reply Notifications
very weird...i created a new email address for myself on my email server, and changed my email notification address here on SSC to the new one; could you please just...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Merge two tables, one column each into one table with two columns
psuedocode sucks....when you abstract the real problem, you get crappy answers, that you end up having to explain lots of times till you come around to teh real answer. Show...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Writing out a one column result set as a concatenated string
here's an example for you to look at:
stuff all values into a column
------------DDL----------------
create table test (id int identity, category varchar(100),
name varchar(100), allnames varchar(8000) null)
insert test (category, name)
select 'fruit', 'apple' union...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Using Variables in SELECT statements
i think either your server is SQL 2000, or the database's compatibility level is still sitting at 80 instead of 90. the xquery is a 2005/90 feature.
change your compatibility level...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS
like others said, you have to JOIN the two aliased groups:
Select
ALIAS1.naam,
ALIAS1.Aantal_Incidenten,
--ALIAS2.naam, --now that they are joined, no need to repeat
ALIAS2.Aantal_Inc_Portal
FROM
(
select vestiging.naam, count(*)...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Break out a description field.
if you add a tally table, this is one of those magical Tally table wonders that extracts between two delimiters: it pulls out the ID and each of the Id's...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: help with a trace
my fault... i was running the query in a database that was Compatibility level 80....duh!
Lowell (2/18/2009)
Jack I get an error when trying to test the code snippet you pasted...Msg 156,...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: help with a trace
Jack I get an error when trying to test the code snippet you pasted...
Msg 156, Level 15, State 1, Line 19
Incorrect syntax near the keyword 'CASE'.
I must be blind, because...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Named Instance
most likely this is related to installing an EXPRESS version ..express does not allow remote connections by default, you must enable it using the Surface Area Configuration Manager:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Question: same code, diferent name
ok, what happens int eh case of a tie?...for code 75360412, two names have been used twice in your example
results:
code ...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Enterprise Edition Vs Developer Edition
you hit the reason on the head...Cost.....Developer version is not licensed for production.
imagine you have 20 developers on your team, building an application that will be deployed in production...each developer...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Question: same code, diferent name
psuedo code sucks big time.
what does the REAL data look like? if you just want the first character, or do you want to strip out non- letter stuff fromt...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: IP adress for SPID ?
it's possible to connect to SQL server without using TCP/IP (you can use named pipes); so those named pipes users would not have an IP address available to query;
Just like...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Database objects & version control- Best practices?
when i use that script wizard in 2005 SSMS, i get an option at the end to script per file:
but i'll be darned if i see the equivilent in Tools>>Options...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: BAK file many times larger than MDF file
Also could it be that the log file is being appended to instead of overwritten WITH INIT, so the big backup actually contains 30 or so regular 5 Meg backups...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 11,551 through 11,565 (of 13,460 total)