Viewing 15 posts - 8,056 through 8,070 (of 26,490 total)
matthew.knudsen (4/10/2013)
guidA, market, isInMarket, guidB (lets just say all of these columns are strings)
I would like to get a count grouped by market, where...
April 10, 2013 at 2:08 pm
johnnyrmtl (4/10/2013)
Hello,I am trying to perform a select based on a condition that the "datetime" formatted column is today's date
2012-12-17 13:57:38.057
what would be the syntax?
thank you
Do you care about the...
April 10, 2013 at 2:03 pm
SQL_Surfer (4/10/2013)
I have difficult understanding this line of codewhere ISNULL(myfield, 'N') = 'Y'
Does this mean
where myfeild is NULL or myfield = 'N' or myfield = 'Y'
The string value 'N'...
April 10, 2013 at 2:00 pm
Prudhviraj (4/10/2013)
prasad-994585 (1/21/2009)
I have installed 2 instance of SQL Server on a same computer . One is a defualt instance and other is named instance:I am able to...
April 10, 2013 at 1:56 pm
Really not enough information to provide a decent answer, especially since we can't see what you see.
Did you have a recent mass update to the table, does the table have...
April 10, 2013 at 12:21 pm
vishalsurya50 (4/10/2013)
I have a query which is using left outer join. Query should execute in seconds instead it is getting executed in mins.
Tried the possibilities:
1) Ran profiler...
April 10, 2013 at 11:54 am
hayden_jones (4/10/2013)
April 10, 2013 at 11:44 am
I have a problem with 176,864 rows (text file) -> 93,456 rows (SQL table) -> 176,864 rows (text file). Something does not add up here, but since we can't...
April 10, 2013 at 11:42 am
If you post the DDL (CREATE TABLE statement) for the table(s), some sample data (not real data) as a series of INSERT INTO statements for the table(s), and expected results...
April 10, 2013 at 10:50 am
SQL Guy 1 (4/10/2013)
April 10, 2013 at 10:25 am
You can actually automate robocpy to automatically transfer your backup files when the backup completes. Did this at a previous employer to move backup files to an off-site file...
April 10, 2013 at 9:36 am
456789psw (4/10/2013)
If the CTE is using recursion then its uses a spool operator therefore tempdb is used....therefore not much performance benefit vs...
April 10, 2013 at 9:03 am
And please post the rest of the information requested.
April 10, 2013 at 7:19 am
abdielmomo (4/10/2013)
April 10, 2013 at 6:38 am
Why don't you show us what you have tried to solve your problem and where you are having problems.
Sample data (as INSERT INTO statements) for each table and expected results...
April 9, 2013 at 11:48 pm
Viewing 15 posts - 8,056 through 8,070 (of 26,490 total)