Forum Replies Created
Viewing 15 posts - 7,486 through 7,500 (of 13,460 total)
-
RE: Converting data to wav format
Sean Lange (5/31/2011)
Pretty sure this article will provide you with some useful information.nice link!
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: insert row of the data with special character as content in the table
char(44) is a comma, is that your special character?
this statement in syntactically correct:
--the char
select char(44)
--an example
select 'the severity level of the patient or resident' + char(44) + 'injury'
INSERT INTO [dbo].[Events]
([ID]
,...
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: Find out who dropped a table in a db that's in simple mode.
if not too much time has past, the default trace, which logs DDL events like CREATE ALTER DROP, might still have it:
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: Generate data from a ramdom combination of temp tables
ok, an update to random is certainly possible... you were really thin on the actual firstname/lastname table definitions, so i cannot provide you with a perfect example...
but, based on your...
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: sys.dm_exec_request showing negative total_elapsed_time
dbcc timewarp? (inside joke)
actually, i think the issue is the times are cumulative, and are since the server restarted...
so it's quite possible if your server is active, or has been...
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: Generate data from a ramdom combination of temp tables
this will be boatloads faster and is a single set based query, instead of using a cu..cur... i can't even say the word...it's so evil....
SELECT top 1000 *
FROM (
SELECT
A.FName,
B.LName
FROM FNAMES...
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: What Events does the Default Trace Capture?
they way i would recommend is by using the script i contributed in this article:
Reverse Engineer A Database Trace[/url]
first find all the traces on your server with SELECT * FROM...
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: bcp error through xp_cmdshell
huslayer (6/1/2011)
Hi,I'm having the same problem and Ive sybase client installed, so what path variables you're talking about here and how to change it?
Thanks
the %PATH% allows you to do things...
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: What is the difference between for and after trigger?
In SQL Server, they are the same thing...in ORACLE and maybe other DBMS systems an AFTER trigger is different.
The first ingredient in properly employing triggers is to understand the differences...
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: Data conversions for hours.
ruff if you only have hours and minutes, how are you going to get a datetime? you need a base/starting point...is that jan 1 of this year, for example?
you could...
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: random select
there's a trick that you can get randomly ordered records by using the NEWID() function...is that what you are after?
select top 10
ColumnList
From SomeTable
order By NEWID()
and this?
in both...
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: create variable name???
something like this?
--SandBox_2011-05-27_10-51-42.bak
SELECT db_name()
+'_'
+ REPLACE(
...
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: T-SQL help
ColdCoffee (5/27/2011)
Lowell, actually, if u look at the new dataset the OP provided, there are dups.. so, a GROUP BY of managerID with COUNT > 1 wont work on dups.....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: T-SQL help
what i posted works...whether there's more than one manager or not.
change the query to work on YourTable instead of mySampleData... then tell us what you expected that is different 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: find out database name
physical file? no...you have to ask the SQL isntance what databases it currently has ...usually via a query, though...for example
SELECT name from master.dbo.sysdatabases
why don't you want to connect to discover...
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 - 7,486 through 7,500 (of 13,460 total)