SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Problem with query???

  Hi, I have a table that looks like this: Table1: ID - int Type - nvarchar(50), Date -…

  vasko102

  1 replies

  14 years, 5 months ago

  By: Cadavre

• connecting local database to SQL server database on the server

  I have a SQL Server database running on the server. I have a desktop application that needs to pull…

  anumeha.gupta

  2 replies

  14 years, 5 months ago

  By: anumeha.gupta

• How to merge multiple rows into fewer rows

  Hi I am stuck at one problem where I need to append values from multiple rows to fewer rows using S…

  Sgedela

  3 replies

  14 years, 5 months ago

  By: Ninja's_RGR'us

• Two or more aliases refer to same DB

  How shall i make the second alias referring to DB already having its alias?

  belkobot

  2 replies

  14 years, 5 months ago

  By: belkobot

• Differential querying based upon a parameter value

  Hi, I have a complex stored proc, but only the necessary code is shown below. Depending upon whethe…

  nadarajan_v

  13 replies

  14 years, 5 months ago

  By: Jeffrey Williams

• Are cursors bad for iterating through the result set returned by a function?

  Hi all, I know that cursors are evil, so I try not to use them. I've read that they are evil becaus…

  pdonley

  25 replies

  14 years, 5 months ago

  By: ian.hadlington

• Performing queries on multiple servers

  I have 2 SQL Servers. One is running SQL Server 2008. The other - SQL Server 2005. I need to do a…

  doug 37293

  9 replies

  14 years, 5 months ago

  By: doug 37293

• Customer Authentication,Authorization or Default Membership

  Hi. i have to create database for E-Commerce and Social Networking Website. Both have the common l…

  gopalchettri

  1 replies

  14 years, 5 months ago

  By: Maksymilian Mulawa

• DB Schema version Info

  HI all I want to get the Schema version info for a DB. Help me in resolving it Thanks

  harish224227

  2 replies

  14 years, 5 months ago

  By: Maksymilian Mulawa

• Need advice on returning data based on specific day and time ranges

  Hi, looking for some insight to see if anyone else has had to solve a problem that I'm encountering…

  DucatiRider

  3 replies

  14 years, 5 months ago

  By: Ysaias Portes-QUI Group

• Data Warehouse - Rows to columns Query

  Hi All, Back for some more advice and learning. Having transfered our data from our very old system…

  LoosinMaMind

  2 replies

  14 years, 5 months ago

  By: spaghettidba

• Assign values: SET or SELECT

  I see a lot of older code where variable are given value with a SELECT command, vs. SET: declare @s…

  alan.berger

  6 replies

  14 years, 5 months ago

  By: Rich Mechaber

• Visual Studio on a Production Server

  Is this a question of religion, where some folks say, "Never" and others say, "Why not?" I'm intere…

  Chris Duncan

  3 replies

  14 years, 5 months ago

  By: Craig Purnell

• UDF with UNION query that returns table

  I created a UDF which returns the result of a Union query as a table. The UNION query gets data fr…

  Daniel Joosten

  3 replies

  14 years, 5 months ago

  By: Daniel Joosten

• Create a Job code help...

  i am using the MCTS exam 70-432 MSSQL server 2008 training kit.. on page 237-238, i have retyped th…

  iczerz

  2 replies

  14 years, 5 months ago

  By: iczerz