Luis Cazares (8/5/2015)

---

Kutang Pan (8/5/2015)

---

Hi Luis,

Thanks for that. I've started preparing a list of some Q/A but i can't find a nice one about dynamic sql writing. I would like...

Hi Luis,

Thanks for that. I've started preparing a list of some Q/A but i can't find a nice one about dynamic sql writing. I would like check the candidates basic...

vipin_jha123 (8/5/2015)

---

Hi When I am trying to execute below command I am getting error

BULK INSERT ##MD_GEOGRAPHYLEVELTYPE

FROM 'H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\Loading_Geography_Table_Data\MD_GEOGRAPHYLEVELTYPE_US.txt'

WITH ( FIELDTERMINATOR =',', FIRSTROW = 9 )

error

Msg 4861, Level 16, State 1,...

You can use BULK INSERT

have a look here https://msdn.microsoft.com/pl-pl/library/ms188365(v=sql.110).aspx

Start with sttairways

http://www.sqlservercentral.com/stairway/72494/[/url]

EDIT:

too late :hehe:

if your query will return only one row, the code will work, but more then that it will fail because you can't assign many rows into a varchar variable using...

I'm a foreigner in UK and already have a 3’rd position working as DBA/DB Dev, never had a problem with nationality.

i assume Temp_Table contains many rows thats why you can't assign all of them to one variable.

What is the output you expecting? I can;t see declaration of @TheUser is that...

What country are you talking about?

Try this query, should give you the same result

SELECT COUNT(a.dex_row_id)

FROM (SELECT dex_row_id, ROW_NUMBER() OVER (PARTITION BY idfaktury ORDER BY dataexportu DESC) AS RowNo

FROM...

GilaMonster (7/28/2015)

---

Answer: Why are you enforcing silly and unrealistic restrictions on my code? Should I be...

you can as well try sp_helpExpandView from Andy Yun to understand what is lying underneath your views

https://sqlbek.wordpress.com/2015/03/03/debuting-sp_helpexpandview/[/url]

Have a look here

http://sqlandme.com/2011/07/13/sql-server-login-auditing-using-logon-triggers/[/url]

did someone do Insert on replicated table on subscriber? i would say reinitialize subscription.

Just a wild guess but maybe Adam Machanic sp_WhoIsActive can do that?

http://sqlblog.com/files/folders/beta/entry42453.aspx